Reltio Connect

Example, I have an Organization entity that has a reference entity of Client Organization. 

I'd like to search for organizations containing x value in the name but only those that have a reference entity of client organization entity Id: cbPmQTq

I've tried many combinations of the filter and can access the attributes of the reference entity (name, etc) but can't see to filter by exact match on the uri. 

Ex: filter(equals(type,'configuration/entityTypes/Organization') AND containsWordStartingWith(attributes.name,'App') AND equals(attributes.ClientOrganization.uri,'abc123'))

Also tried many other variations (ex: equals(attributes.ClientOrganization.uri,'abc123').
There is an attribute on the reference entity called entityuri that is marked as searchable, but it's not showing up. 

Any ideas?  

Hi Sarah,

If I'm understanding correctly, what might help would be to make sure you include entityuri as one of the attributes in your Organization.ClientOrganization reference attribute definition.  With that done, your filter could look like this:

filter(equals(type,'configuration/entityTypes/Organization') AND containsWordStartingWith(attributes.name,'App') AND equals(attributes.ClientOrganization.entityuri,'abc123'))

Please let me know if this helps.

Kind regards,

Matt