I want to execute a query without using Query Database node. I think Query Rule

anilkumark over 10 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 10 years ago

@anilkumark Out of interest, may I know why the query should be made for each column separately? The only thing we need to take care of is querying but not the writing part because Write to Data Store entity anyhow handles the write part in an elegant manner.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 10 years ago

@anilkumark Out of interest, may I know why the query should be made for each column separately? The only thing we need to take care of is querying but not the writing part because Write to Data Store entity anyhow handles the write part in an elegant manner.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data