Question

Expression evaluation error

Forum|Forum|2 years ago
March 12, 2024
6 replies
0 views

Hi

I have an interface where I'm displaying data related to a case and that data actually from another source where they provided it as a view. Now since they have emptied the view the expression rule that fetches the data from this view is throwing error as an error occurred while retrieving the data:unexpected error executing query...Can anyone help me in handling this null data. It would be great if anyone can provide an example query expression.

Thanks in advance.

prakhars0731

Have you handled the null checks in your interface.

H

harithar9577Author

Yes but it is throwing error in the query expression itself.

stefanhelzle0001

Brainy

Did you try to execute that view directly in the database?

harshitb6843

You will need to make changes in your view to make sure that it runs even when there is no data in the tables.

davidj137213

Brainy

Check if the datasubset contains data before accessing it.

Could you post tour code here?

karumurua531442

Could you give more context on this, Check whether are you storing right data in table columns which you are using in the view., if the wrong data in a table column violates any constraints or leads to data inconsistency that affects the view's operation. There May be a possibility but not sure

Sign up

Login with SSO

Login to the community

Login with SSO