Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Result.RecordsMatched=2 - how touse the first record that matched


Henrik Lapinkaira 2

Recommended Posts

  • 4 weeks later...
  • 4 weeks later...

Hi Henrik,

Aside from the initial query block, you can retrieve/querydatain two different ways:

1 - Using Lookup Block, to retrieve 1 result when Resultmatch =1 . (always only one record in the result, when match =0(meaning no match was found) or match=2(meaning 2 or more matches were found),

Warning:When Resultmatch = 0 or Resultmatch=2 the Lookup Block resultfields are all set to Null Values, if you try to map the Null values you may get errors.

2 - Using a Fetch Block to retrieve match =X results, it will basically loop thru each result and execute any target block you add in the Fetch Loop.

When Fetch has 0 results, all blocks inside the Fetch Loop are skipped.

 

Note:

in order to be selective on which matched records to map, you can add an IF Block in the Fetch Loop and add some criteria to de-duplicate your record or do other data validation before mapping the data to a target system or deciding in skipping a record.

 

More info on using a Fetch block can be found here:

https://support.tibco.com/s/article/update-or-delete-multiple-records-wi...

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...