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.
Discussion posts and replies are publicly visible
Have you handled the null checks in your interface.
Yes but it is throwing error in the query expression itself.
You will need to make changes in your view to make sure that it runs even when there is no data in the tables.
Check if the datasubset contains data before accessing it.
Could you post tour code here?
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
Did you try to execute that view directly in the database?