DBQuery from a Root Level Node

David Paras

• May 09, 2012 18:57

I am having issues with the Adeptia DBQuery from a Root Level Node. The
query is selecting 2 columns from the database table and I have a ForEach on
two target nodes. However, if the query can not find a value in the table
the record is being excluded from the target. Is there a way to prevent
this?

0

• 

  David Paras

  • May 09, 2012 18:57

  Please follow the steps below to achieve your requirement:

  1. In the Data Mapper create a duplicate Target node.
  2. This duplicate node won't have any forEach statement.
  2. In the Target node Textual Rules provide an IFF condition for filtering records.

  IFF CONDITION{ count($dbQuery/Record) = 0} VALUE=[' You can also hard code the value here. ' ].

  0

Please sign in to leave a comment.