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
9 subscribers
Views
1259 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
A basic Question, I would appreciate if someone can answer it for me. I wa
anandi
over 12 years ago
A basic Question, I would appreciate if someone can answer it for me.
I was able to store a set of process variables in a data store. While trying to query for them later in the process I am expected to enter the SQL statement.
So my questions are:
1) What should be the table name that I need to use in the SQL statement?
I had to use the Custome data type name without underscores and without capital letters to make it work. Is this how it is supposed to work?
2) The queried variables which I received from the database were of a different TYPE. for example : I stored a boolean but what came out was Number( Decimal ), Again this is strange. So can some one clear the mist here please.
...
OriginalPostID-33286
OriginalPostID-33286
Discussion posts and replies are publicly visible
Parents
0
anithar888
over 12 years ago
If there is already a CDT and a corresponding entity for this table, using query rules instead of the Query Database node might be of help.
Further reference on query rules you can go through the links below:
forum.appian.com/.../Creating_Query_Rules
forum.appian.com/.../Query_Rule_Best_Practices
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
anithar888
over 12 years ago
If there is already a CDT and a corresponding entity for this table, using query rules instead of the Query Database node might be of help.
Further reference on query rules you can go through the links below:
forum.appian.com/.../Creating_Query_Rules
forum.appian.com/.../Query_Rule_Best_Practices
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data