Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
7 subscribers
Views
1213 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
#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
OriginalPostID-239081
Discussion posts and replies are publicly visible
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