l4i
...
Connections
Microsoft SharePoint (On Premi...

Filters

4min

Many of the SharePoint methods allow a Filter Input Parameter to be defined. This will filter the results of the method to only items that match the criteria specified.

The format of the filter expressions follows the Microsoft SharePoint API format, except omit the $filter= portion of the filter string as this is implied by L4i.

The following String Comparisons are supported:

String Comparison

Notes

startsWith

Starts with

substringof

Substring match

eq

Equal

ne

Not Equal

The following Numeric Comparisons are supported:

Numeric Comparison

Notes

lt

Less Than

le

Less Than or Equal

gt

Greater Than

ge

Greater Than or Equal

eq

Equal

ne

Not Equal

The following String Comparisons are supported:

String Comparison

Notes

startsWith

Starts with

substringof

Substring match

eq

Equal

ne

Not Equal

The following Numeric Comparisons are supported:

Numeric Comparison

Notes

lt

Less Than

le

Less Than or Equal

gt

Greater Than

ge

Greater Than or Equal

eq

Equal

ne

Not Equal

The following String Comparisons are supported:

String Comparison

Notes

startsWith

Starts with

substringof

Substring match

eq

Equal

ne

Not Equal

The following Numeric Comparisons are supported:

Numeric Comparison

Notes

lt

Less Than

le

Less Than or Equal

gt

Greater Than

ge

Greater Than or Equal

eq

Equal

ne

Not Equal

Some examples Are:

Filter Parameter

Result

Title eq 'README'

returns only items whose Title equals README

startswith(Title,'T')

returns only items whose Title start with the letter T