Filter results by multiple columns

[pselman]

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?

[Nikita Kurguzov]

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!