Compare Lists How To

PointsWell

I have two tables of data and one target table

Work has many Contributors and a Contract has many ContractParties.

From a Contract which has contract parties I need to find Work where the ContractParties are Contributors. Contract Parties might contain 2 entries or it might contain more. Contributors might contain 2 entries or it might contain more.

Other than writing a query that says

FIND Work WHERE EXISTS Contributor WHERE Contributor.psContact.Name='Jim' AND WHERE EXISTS Contributor WHERE Contributor.psContact.Name='Janice' etc etc for everyone in the ContractParties table

Does anyone have any tips on how to write a more generic version of that query, or am I going to have to create a string to capture all of that, store it in an attribute and then EXEC_STRING?

customaware

What is the commonality between Contributors and ContractParties?

Does not seem like they are the same thing but there is some relationship between then surely?

PointsWell

eagles9999 wrote
What is the commonality between Contributors and ContractParties?

Does not seem like they are the same thing but there is some relationship between then surely?

So there is no commonality per se between the two. ContractParties determines the Works to search for on the basis that the Contributors match the ContractParties.

customaware

Seems I asked the wrong question....

You write "ContractParties determines the Works to search for on the basis that the Contributors match the ContractParties"

How can we tell if a Contributor matches a ContractParties?

PointsWell

Apologies I misunderstood your question.

The Contributor and ContractParties are instances of Contacts.

Contributor.psContact
ContractParties.psContact

When you spend too long staring at the code and assume it’s common knowledge …