Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5309 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Contact records store their phone numbers in a related Phones table. While in the Contacts table I'd like a scripted solution for reducing the current found set to just those without any records in the Phones portal.

Yes, the script could loop through each record doing a test for not isvalid(Phones portal relationship), store the current Contact ID in an accumulating variable, then do a GTRR on that variable's list of Contact IDs.

Is there something more efficient that does not involve looping? I suspect there must be but haven't discovered one yet.

Any ideas? Much appreciated

Posted

Found the answer to my own question.

Execute a Constrain Found Set script step. Configure it to omit records which have Phone portal relationship::SerialID > 1

Sometimes writing out the problem and submitting it to a forum jiggles the mind to spontaneously come up with the answer.

Thanks.

This topic is 5309 days old. Please don't post here. Open a new topic instead.

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...

Important Information

By using this site, you agree to our Terms of Use.