Advanced search filters

When using GetPipelineItems, you can provide an array of advanced filter objects to narrow the results. Each filter object has a Name, an Operation, and a Value. Legal values for each filter are based on which operation is selected. Read more about the type system here.

Because fields can be customized, the available filters are different on every account. This documentation shows fields for an example LACRM account. Please log in to see the filters for your specific account.

Date Lead was created

Name: PipelineCreated

Operation	Value Type	Description
IsExactly	Date	Date value.
IsBetween	{ StartDate: Date, EndDate: Date }	Object type.
IsBefore	Date	Date value.
IsAfter	Date	Date value.

Date Lead was last updated

Name: PipelineUpdated

Operation	Value Type	Description
IsExactly	Date	Date value.
IsBetween	{ StartDate: Date, EndDate: Date }	Object type.
IsBefore	Date	Date value.
IsAfter	Date	Date value.

Group

Name: Group

Operation	Value Type	Description
IsNotInAnyGroup	Null	No value.
IsInGroupList	Array of Uids	Array of group IDs.
IsNotInGroupList	Array of Uids	Array of group IDs.

Full name

Name: FullName

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.

First name

Name: FirstName

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Middle name

Name: MiddleName

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Last name

Name: LastName

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Company name

Name: CompanyName

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Company Uid

Name: CompanyId

Operation	Value Type	Description
IsExactly	Uid	Uid of company; filters for contacts that work there.

Salutation

Name: Salutation

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Suffix

Name: Suffix

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Date contact was created

Name: DateEntered

Operation	Value Type	Description
IsExactly	Date	Date value.
IsBetween	{ StartDate: Date, EndDate: Date }	Object type.
IsBefore	Date	Date value.
IsAfter	Date	Date value.

Date contact was updated

Name: DateUpdated

Operation	Value Type	Description
IsExactly	Date	Date value.
IsBetween	{ StartDate: Date, EndDate: Date }	Object type.
IsBefore	Date	Date value.
IsAfter	Date	Date value.

Email

Name: Email

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Address - Street

Name: AddressStreet

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Address - City

Name: AddressCity

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Address - State

Name: AddressState

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Address - Zip

Name: AddressZip

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Address - Country

Name: AddressCountry

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Phone

Name: Phone

Operation	Value Type	Description
Contains	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Website

Name: Website

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Job title

Name: Title

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Background info

Name: BackgroundInfo

Operation	Value Type	Description
Contains	Text	Any string.
DoesNotContain	Text	Any string.
IsExactly	Text	Any string.
IsNot	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Birthday

Name: Birthday

Operation	Value Type	Description
IsBetween	{ StartDate: Date, EndDate: Date }	Object type.
IsExactly	Date	Date value.
IsBefore	Date	Date value.
IsAfter	Date	Date value.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Number of years old

Name: Age

Operation	Value Type	Description
IsBetween	{ From: Number, To: Number }	Object type.
IsExactly	Text	Any string.
IsExactly	Text	Any string.
IsGreaterThan	Text	Any string.
IsLessThan	Text	Any string.
IsEmpty	Null	No value.
IsNotEmpty	Null	No value.

Tasks and events

Name: Cal

Operation	Value Type	Description
HasNoAttachedItem	{ Status: Pending or Completed, Type: Task or Event or Both, IncludeOverdue: Bool }	Object type.
HasAttachedItem	{ Status: Pending or Completed, Type: Task or Event or Both, IncludeOverdue: Bool }	Object type.