Filter results by multiple columns

Discussions about Cross-site Lookup
Locked
pselman
Posts: 24
Joined: Wed Nov 04, 2015

29 Jan 2018

We have a column called IAS - Monitoring Supplier {IAS_x0020__x002d__x0020_Monitori0} in a list called Maintenance Contracts. This looks up to System/Service Type {System_x002f_Service_x0020_Type} column in Products/Services List. This is a multiple choice PlumSail Lookup.

We also then have a column called IAS - Monitoring Type {IAS_x0020__x002d__x0020_Monitori} This is the field which we wish to filter as follows;

Where, in Products/Services, System/Service Type {System_x002f_Service_x0020_Type} CONTAINS "Intruder Alarm" and Supplier {Supplier} = same value as selected in IAS - Monitoring Supplier {IAS_x0020__x002d__x0020_Monitori0}

Please could you advise at all?

User avatar
Nikita Kurguzov
Posts: 889
Joined: Mon Jul 03, 2017

30 Jan 2018

Dear Pselman,
We'll gladly advise you on this topic! First thing you can do is check out our Cross-site Filtering article which shows you how to filter lookups by multiple fields and also Cascading Cross-site Lookup article which shows how to use another lookup for filtering.

The only issue I see here is that there is no contains querry option in OData, instead you can try to use substringof(), check out all OData query options here.

If you'll have any questions - please, let us know!
Cheers

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 2 guests