State Not Answered
+1 person also asked this people also asked this
Replies 3 replies
Subscribers 6 subscribers
Views 6067 views
Users 0 members are here

Execute Stored Procedure

Amit Chaugule

A Score Level 1

over 6 years ago

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 Amit Chaugule
A Score Level 1
over 6 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 6 years ago in reply to Amit Chaugule

Not sure. Certainly sounds strange. Have you raised logs to DEBUG to see where the column order gets switched around (stored proc building, in DB, out of DB?)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Cichy
Appian Employee
over 6 years ago in reply to Amit Chaugule

Not sure. Certainly sounds strange. Have you raised logs to DEBUG to see where the column order gets switched around (stored proc building, in DB, out of DB?)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data