• State Not Answered
  • Replies 2 replies
  • Subscribers 6 subscribers
  • Views 3378 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Process

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

Ravi
A Score Level 1

Hi,

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

Parents
  • 0
    Hi Ravi,
    Are you using Export SQL to Excel smart service? If so, you can use a script task to build the SQL query if you have multiple filters. Once you have built the query, you can use the smart service and pass the values to the parameters in the service and it should generate you the report. Make sure you are using the correct JNDI name, if you have multiple datastores defined in your server.

    Thanks
Reply
  • 0
    Hi Ravi,
    Are you using Export SQL to Excel smart service? If so, you can use a script task to build the SQL query if you have multiple filters. Once you have built the query, you can use the smart service and pass the values to the parameters in the service and it should generate you the report. Make sure you are using the correct JNDI name, if you have multiple datastores defined in your server.

    Thanks
Children
No Data

© 2024 Appian. All rights reserved.