#Stored Proc

melwynabrahamj over 7 years ago

Hi all,
I have a issue which i am facing currently. Consider a table of ten columns (say col1,col2....col10)and assume the col 10 is in date field ,rest is in simple text format and using execute stored proc i am getting a value instead of query rule or query entity. Now when i tries to retrieve data in expression rule, i can get the expected result whereas when i calls the same stored proc from process model, col 10(date field) value is missing. I thought that it could be due to type mismatch. But i checked it from my end, everything is fine. So could you please help me out how to overcome it? And what could be the possible reason for this issue?
Thanks in advance

Discussion posts and replies are publicly visible

Parents

0 yagyadeepk over 7 years ago

melwyn , try converting the date value to text or varchar depending on the database in the stored proc and after data is fetched in appian process,convert again to date using appian functions, this way you will be able to get the data
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 yagyadeepk over 7 years ago

melwyn , try converting the date value to text or varchar depending on the database in the stored proc and after data is fetched in appian process,convert again to date using appian functions, this way you will be able to get the data
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data