To filter the record(s) based on field type – Text

To filter the record(s) based on below fields (field type 'Text'), pass the attribute name along with the value. 

Record(s) not having an empty value — Object Text is not empty

Record(s) having an empty value — Object Text is empty

Record(s) having the passing value — Object Text == test1

Record(s) not having the passing value — Object Text != test1

Record(s) containing the passing value — Attribute 'Object Text' contains 'test1' (case sensitive)

For custom field type text

Everything will be the same except the key:
example : customkey == test1


To filter the record(s) based on field type – Boolean

Record(s) having not empty value — Backward Compatibility is not empty

Record(s) having an empty value — Backward Compatibility is empty

Record(s) not equal to the boolean value — Backward Compatibility != False

Record(s) equals to the boolean value — Backward Compatibility == False

For custom field type Boolean

Everything will be the same except the key:
example : customkey == False


To filter the record(s) based on field type – Integer

Record(s) having value equal to passing value — Absolute Number == 12345

Record(s) having value not equal to passing value — Absolute Number != 12345

Record(s) having value greater than passing value — Absolute Number > 12345

Record(s) having value greater than or equal to passing value — Absolute Number >= 12345

Record(s) having value less than passing value — Absolute Number < 12345

Record(s) having value less than or equal to passing value — Absolute Number <= 12345

Record(s) having empty value — Absolute Number is empty

Record(s) not having empty value — Absolute Number is not empty

For custom field type Integer

Everything will be the same except the key:
example : customkey == 123456


To filter the record(s) based on field type – Date

Last Modified On

Record(s) having equal value —  Last Modified On == 04/28/2022

Record(s) having not equal value — Last Modified On != 04/28/2022

Record(s) having greater than value — Last Modified On > 04/28/2022

Record(s) having greater than or equal value — Last Modified On >= 04/28/2022

Record(s) having less than value — Last Modified On < 04/28/2022

Record(s) having less than or equal value — Last Modified On <= 04/28/2022

Record(s) having empty value — Last Modified On is empty

Record(s) having not empty value — Last Modified On is not empty

Created On

Record(s) having equal value — Created On == 04/28/2022

Record(s) having not equal value — Created On != 04/28/2022

Record(s) having greater than value — Created On > 04/28/2022

Record(s) having greater than or equal value — Created On >= 04/28/2022

Record(s) having less than value — Created On < 04/28/2022

Record(s) having less than or equal value — Created On <= 04/28/2022

Record(s) having empty value — Created On is empty

Record(s) having not empty value — Created On is not empty

For custom field type Date

Everything will be the same except the key:
example : customkey > 04/28/2022


To filter the record(s) based on field type – String

Attribute 'Object Heading' contains 'test1' (case sensitive)

Record(s) having equal value — Object Heading == test1

Record(s) having not equal value — Object Heading != test1

Record(s) having empty value — Object Heading is empty

Record(s) having not empty value — Object Heading is not empty


Record(s) having equal value — Object Short Text == test1

Record(s) having not equal value — Object Short Text != test1

Record(s) having empty value — Object Short Text is empty

Record(s) having not empty value — Object Short Text is not empty

Created By

Record(s) having equal value — Created By == test1

Record(s) having not equal value — Created By != test1

Record(s) having empty value — Created By is empty

Record(s) having not empty value — Created By is not empty

Last Modified By

Record(s) having equal value — Last Modified By == test1

Record(s) having not equal value — Last Modified By != test1

Record(s) having empty value — Last Modified By is empty

Record(s) having not empty value — Last Modified By is not empty

For custom field type String

Everything will be the same except the key:
example : customkey == test1