IC SunsetThe developerWorks Connections Platform is now in read-only mode and content is only available for viewing. No new wiki pages, posts, or messages may be added. Please see our FAQ for more information. The developerWorks Connections platform will officially shut down on March 31, 2020 and content will no longer be available. More details available on our FAQ. (Read in Japanese.)
Topic
  • 1 reply
  • Latest Post - ‏2017-06-28T16:01:31Z by CraigPhipps
fredericMarchal
fredericMarchal
4 Posts

Pinned topic compare two lists of tricontactrole records and find the records that are not into the two lists

‏2017-06-28T09:26:14Z | comparison list records

Hello,

 

I would like to know if there is a way to compare two lists of tricontactrole records and find the records that are not into the two lists.

 

The case is as following :

- one list of tricontact role records is associated to "tricapitalproject" object

- the other list of records is associated to "triPurchaseOrder" object.

- I would like "copying" the tricontact roles records from capital project to purchase order, but only those that does not already exist in purchase order.

 

Is there any method to do that ?

Thanks in advance for your feedback

 

  • CraigPhipps
    CraigPhipps
    35 Posts
    ACCEPTED ANSWER

    Re: compare two lists of tricontactrole records and find the records that are not into the two lists

    ‏2017-06-28T16:01:31Z  

    One way might be to have a query task grab all the resulting contact role records associated to the capital project record.  Then have an iter task that goes through each of those records.  Within the iter, you can have another query task grabbing the contact role records of the purchase order record using the iter record as a filter.  Then have a switch that says if the result count of the second query task = 0, then create the contact role record for the purchase order record.

  • CraigPhipps
    CraigPhipps
    35 Posts

    Re: compare two lists of tricontactrole records and find the records that are not into the two lists

    ‏2017-06-28T16:01:31Z  

    One way might be to have a query task grab all the resulting contact role records associated to the capital project record.  Then have an iter task that goes through each of those records.  Within the iter, you can have another query task grabbing the contact role records of the purchase order record using the iter record as a filter.  Then have a switch that says if the result count of the second query task = 0, then create the contact role record for the purchase order record.