Skip to main content
manjit.1486
October 31, 2023
Question

No data available due to empty data source, applied filter/selection criteria, or fields visibility.

  • October 31, 2023
  • 8 replies
  • 0 views

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

8 replies

stewart.burchell
October 31, 2023

Have you checked that the filter you're applying has a value that matches a value in the DB?

manjit.1486
October 31, 2023

Yes, both has same datatype int

stewart.burchell
October 31, 2023

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?