Deal All,
I'm trying to export the report as excel using smart service "Export Data Store Entity to Excel",
This smart service is working for simple query filters. In my case, I have multiple logical expressions and getting below error in Excel.
Error:
"No data available due to empty data source, applied filter/selection criteria, or fields visibility."
Conditions:
a!queryLogicalExpression( operator: "AND", logicalExpressions: { a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter(), a!queryFilter() } ), a!queryLogicalExpression( operator: "OR", filters:{ a!queryFilter(), a!queryFilter() }), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(), a!queryFilter()
} )
Could you please help with this issue. Thank you.
Discussion posts and replies are publicly visible
Does the same query entity statement/logic return data correctly when you run it from the expression rule editor? That should be your primary place to debug this.
Hello Mike,
Thank you for the response.
Yes, same query works in Interface for Report. When I try to export the report to excel, getting the error message in the document.