Filter Source Records using DBQuery

Situation :

We have some data present in the Database table on basis of which we want to filter out the records of Incoming Source file. To achieve this we have created a Db Query that takes value from Source record and verifies the condition.

DB Query: DbQuery { Select FirstName from tablename where LastName = '/Field2' , $DbConnInfo , true}

Example :

DB Table

Source Record

Target Record (Filtering Data on basis of LastName)

and verifies the condition but we are unable to get the desired results.

Solution:

In order to achieve the desired output, you need to follow the below steps :-

• Create a local variable for Dbquery at /Root level i.e. $DbQueryRecord with below Query.

DbQuery { Select FirstName from tablename where LastName = '/Field2' , $DbConnInfo , true}

• Place the Xpath of the Source Record (/Record) in For-each at /Root level.
• Now, use the variable defined in step1 ($DbQueryRecord) within IFF condition in textual rule at /Record level. As shown below :

         "  IFF {$DbQueryRecord > 0 } VALUES ['true'] "

After following the above-mentioned steps, the desired output will be achieved.