Hello there!
I am using Export Data Store Entity to Excel/CSV Smart Service to export the data in Excel sheet. If I check database, there are records, but through the smart service, in Excel sheet, I am getting the message "No data available due to empty data source, applied filter/selection criteria, or fields visibility."
Also, I have applied filters for specific data shown in excel sheet on the basis of id.
= a!queryFilter( field: "caseid", operator: "=", value: pv!transactionDetails.caseID_int)
Please assist me in this.
Thanks
Discussion posts and replies are publicly visible
Have you checked that the filter you're applying has a value that matches a value in the DB?
Yes, both has same datatype int
Just to be clear - the value you're providing in the process - let's say 100 - has a corresponding value in the 'caseid' column in the target DB table?
Yes
Have you tried testing a Query Entity in isolation from the Process Model? Just to prove to yourself that the DSE is connected to your datasource and that you can retrieve any data at all through any query.
Getting this error: Either selection or filters are invalid: Cannot apply operator [EQUALS] to field [caseid] when comparing to value [TypedValue[it=101,v={23,23,23}]]. (APNX-1-4505-009)
Ok so this error is saying you're trying to compare caseid (which is an integer) using the "=" operator to a list of integers - {23,23,23} which isn't allowed. You either need to compare to a single integer value e.g. 23, or use the "IN" operator (whch does allow you to compare against a list of values)
Yes, I have fixed this