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
7 replies
Subscribers
8 subscribers
Views
2710 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I want to execute a query without using Query Database node. I think Query Rule
anilkumark
over 9 years ago
I want to execute a query without using Query Database node. I think Query Rule is the best way execute a query for faster performance. But how to use Query Rule for multiple entities? Which is best way to execute below query?
"select T1.* from TABLE_ONE T1 , TABLE_TWO T2
where T1.CUST_ACCT_ID = T2.PRNT_ACCT_ID
and T2.ORDR_ID = pv!order_id; "
Thanks.
OriginalPostID-155351
OriginalPostID-155351
Discussion posts and replies are publicly visible
Parents
0
anilkumark
over 9 years ago
@sikhivahans After fetching the data, I have to insert into one another table.
Result of that query having about 40 columns. If I use Query Rule, then I have to run that Query Rule for each and every column (40 Times) in the Script Task and insert into table (CDT). Is it good? If not what is the better way to save into another table. Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
anilkumark
over 9 years ago
@sikhivahans After fetching the data, I have to insert into one another table.
Result of that query having about 40 columns. If I use Query Rule, then I have to run that Query Rule for each and every column (40 Times) in the Script Task and insert into table (CDT). Is it good? If not what is the better way to save into another table. Thanks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data