BO related to the same kind of BO

yuri.rj

I have a BO called Contact
Contact can be related to many Contacts

So...When i'm Viewing a Contact i have to option to "See All Related Contacts"

I tried using this, but it was REALLY REALLY SLOW:
FIND Contact WHERE (Contact IN ThisContact.REL_CONTACTS OR ThisContact in Contact.REL_CONTACTS) AND Contact<>ThisContact

Then i changed this and created a process to "addRelationship". This process add the "related1" to the REL_CONTACTS of "related2" and the related2 to the REL_CONTACTS of "related1" so the query would be like this
FIND Contact WHERE Contact IN ThisContact.REL_CONTACTS AND Contact<>ThisContact

Now it's almost perfect. It's fast and it shows all related contacts, but there is a problem:
In the Related Contacts Query i have a button next to the item that call a process called EDITCONTACT(i can't use the Edit Object behavior), but when i call this process, the process tries to open BOTH Contacts... The original and the related.

I thought i was doing something wrong so i created another process called AlertContactName and called from the same button next to the item.
And it shows 2 alerts calling the related1.contactName and the related2.contactName

What i did wrong? it is my query? i spent all day trying to figure this out and i can't.
Hope some one helps me.

yuri.rj

And if i use the default behavior(Edit Object) it opens the correct contact(the one listed in the resultgrid)

tford

Please share the 2 processes that you tried.

yuri.rj

EditContact: (This one is the one i need to use)
IF Contact.TPO_CONTATO='PJ' THEN VIEW Contact USING 'Form PJ'
ELSE IF Contact.TPO_CONTATO='PF' THEN VIEW Contact USING 'Form PF'

AlertContactName🙁this one show 2 alert messages, showing the main contact and the related one. I think the EditContact process is trying to do the same and thats why it does not work)
DISPLAY MESSAGE Contato.NME_CONTATO

AddRelationship(This one i made to make the query goes faster)
PICK ONE OR MORE FROM Contact WHERE Contact<>ThisContact AND Contact.NME_CONTACT CONTAINS ?'Name'
INSERT Contact IN ThisContact.REL_CONTATOS
INSERT ThisContact IN Contact.REL_CONTATOS

RemoveRelationship🙁This one has nothing to do with the problem, but its here to illustrate the whole case)
PICK ONE OR MORE FROM Contact WHERE Contact IN ThisContact.REL_CONTACTS AND Contact<>ThisContact
REMOVE Contact FROM ThisContact.REL_CONTACTS
REMOVE ThisContact FROM Contact.REL_CONTACTS

And the query that shows the button that doesn't work is this
FIND Contact WHERE Contact IN ThisContact.REL_CONTACTS AND Contact<>ThisContact

yuri.rj

EditContact: (This one is the one i need to use)
IF Contact.TPO_CONTATO='PJ' THEN VIEW Contact USING 'Form PJ'
ELSE IF Contact.TPO_CONTATO='PF' THEN VIEW Contact USING 'Form PF'

And the query that shows the button that doesn't work is this
FIND Contact WHERE Contact IN ThisContact.REL_CONTACTS AND Contact<>ThisContact

yuri.rj

i'm still trying to find out whats happening, so... looking at the logs i realize that when i start a process from an item of this query:

FIND Contact WHERE Contact IN ThisContact.REL_CONTACTS AND Contact<>ThisContact

It start the process TWICE!!!!

it's starting a process fro the original Contact and the RelatedContact
Whyyyyyyy?

tford

I would start by right clicking on the process in the tree of objects on the left side of the Config Tool & select "Find references to".