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.

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 9 years ago

@anilkumark Until and unless there is a strong reason (such as complex queries or OOTB query rules consuming lots of time etc) I would like to suggest you to opt for creating a view and then proceed with making use of Query entity because these doesn't require a change when the database vendor changes and also can be used anywhere without any constraints.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@anilkumark Until and unless there is a strong reason (such as complex queries or OOTB query rules consuming lots of time etc) I would like to suggest you to opt for creating a view and then proceed with making use of Query entity because these doesn't require a change when the database vendor changes and also can be used anywhere without any constraints.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data