Hi All,
I am having a weird issue in executing the query entity. I have a query entity rule which returns the totalcount based on the date range(which is ideally current date/day). It is throwing error in some scenarios and testing this rule certain time, we can see the data is being populated.
Any help would be highly appreciated.
Discussion posts and replies are publicly visible
HOw much does the query takes when executed directly in SQL?
Maybe your filter using dates and between operator is too slow. Do you have an index created in that field?
Try removing the filter or filtering by Pk, in order to check if the problem is related with that field.