Forums

Sir,

Please, I want to display a "no record found" message when there is no record returned or displayed on the table.

Kindly assist

I think you would do that by creating a separate Switch function to check for any record(s) and return true or false. For example, if the db read function is called "data_read", create a Switch function called "check_result". Then, under the Data Provider for the "check_result" put:

{var/empty:data_read}.

Then under the Values Setup of "check_result" put :

true:{error: No Record Found}

Hope this helps.

-Brian

Sir Edi,

Thanks it worked as shown below but I want something similar to the 2nd image below. Kindly assist me further

[attachment=73180_20170307202232_screenshot-www-probun-com-2017-03-07-21-20-23-png.png][/attachment]

[attachment=73180_20170307202300_screenshot-www-probun-com-2017-03-07-21-20-04-png.png][/attachment]

Hi atanunu,

It will be a bit difficult to have something like the 2nd image, because a custom table row should be added.

instead you can change the line in the "check_result" function:

true:{error: No Record Found}{view:css_view}

Create a CSS view and use CSS to hide the table when no records were found.

Best regards,
Max