Skip to main content
New Participant
Mar 12, 2024 7:26 AM UTC
Question

Expression evaluation error

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.

6 replies

prakhars0731
Inspiring
Mar 12, 2024 7:43 AM UTC

Have you handled the null checks in your interface.

New Participant
Mar 12, 2024 7:46 AM UTC

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

stefanhelzle0001
Brainy
Mar 12, 2024 5:35 PM UTC

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

harshitb6843
Brainy
Mar 12, 2024 8:20 AM UTC

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
Mar 12, 2024 8:27 AM UTC

Check if the datasubset contains data before accessing it.

Could you post tour code here?

karumurua531442
Participating Frequently
Mar 12, 2024 5:14 PM UTC

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