Relationship: Help with OR statement and query list field

[Desmo]

Hello Community,

I've created a relationship  where 'Applies to table' and 'Queries from table' are the same tables.

This query works.

	current.addQuery('customer', parent.customer);

Next, I'd like to include or statement and query a list field

	current.addQuery('customer', parent.customer);//or...
	current.addQuery('customer', parent.u_related_customer);//u_related_customer list field

Thank you!

[pony_ma]

Hi，Try whether this method is feasible

addEncodedQuery(String query)

[Ankur Bawiskar]

Hi,

you cannot compare reference field with list field directly

you need to query and check

Regards
Ankur

[Ankur Bawiskar · Accepted solution]

@Desmo 

try this once

current.addQuery('customer', parent.customer).addOrCondition('u_related_customer', 'LIKE', parent.customer);

Regards
Ankur

[Desmo]

@Ankur Bawiskar This is helpful.

I reversed the last condition and it produced results.

current.addQuery('customer', parent.customer).addOrCondition('customer', 'LIKE', parent.u_related_customer);

However, it does not produce results when there is more than one (1) entry in u_related_customer list field.

Regards,

Desmo