Getting No data in excel through Export Data Store Entity to Excel/CSV Smart Service in Process Model

A Score Level 1


I am working on Appian 17.4.

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 40 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."

I am mentioning both the selected columns as well as filters using a!querySelection under Selection Input and a!queryLogicalExpression(operator:"AND", filters:a!queryFilter) under Filters Input.

Do we need to fetch the data separately in expression rule using a!queryEntity (in script task) before calling this smart service.

Please suggest.

Thanks and Regards






  Discussion posts and replies are publicly visible