LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Hi,

Is there a way we can use data coming out of a node as a search list in the other node in same graph ?

For example: I have an AggEx node with few records coming out of it and I would like to use them in another node with WHERE function ?

At the moment I am using a BRX to do this which is not a very dynamic approach.

Please reply.

Thanks
GK

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You should be able to accomplish this with a Lookup or Join (X-Ref) node.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Thanks. but I think I did not explain properly.

Basically, I have a DB Query node which contains millions of records and I don't want to run everything and then filter it. Looking for a way where I can insert the value using WHERE or IN function before running the DB node.

I hope I explained it properly this time.

Thanks
GK

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Change it to a DBExecute like this:


=====
The other option is to build your query string and then pass it in as a variable.
In a filter node, you would put something like this:
Then in the DbExecute, you would use simply this:

However, this last approach only works if there is a single input record. If you attempt to perform multiple queries with it (multiple records in), then Oracle will likely throw an error of "Query Changed". It works with one record, but not multiple.