• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 7 subscribers
  • Views 6105 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Execute Stored Procedure

Amit Chaugule
A Score Level 1

I am facing a problem while fetching data from stored procedure.

M giving Select query as input through Appian to stored procedure where the column sequence is specified.

While retrieving the data the columns are in different order than specified in the select statement.

Is there any way to maintain the column order as per the select statement sequence as the select query is generic and can be provided at runtime.

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    Hi Robert,
    I am building kind of generic Export To Excel functionality for all grids we have in our application. I am going to use Exportable Data subset plugin for it.I also want to extend this feature as generic export to excel to generate run time export of data.

    Idea is
    1. Form a dynamic select query.
    2. Using execute stored procedure get the data.
    3. Parse the datasubset to get the column names.
    4. The output execute SP has all data in label value pairs but the sequence is not maintained.
Reply
  • 0
    A Score Level 1
    Hi Robert,
    I am building kind of generic Export To Excel functionality for all grids we have in our application. I am going to use Exportable Data subset plugin for it.I also want to extend this feature as generic export to excel to generate run time export of data.

    Idea is
    1. Form a dynamic select query.
    2. Using execute stored procedure get the data.
    3. Parse the datasubset to get the column names.
    4. The output execute SP has all data in label value pairs but the sequence is not maintained.
Children
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.