Guide To Writing Queries

Supported Combinations

12min

Text-like
Property
Value
Sugar Field Types
text, varchar, name, html, longtext, phone, url, username
Supported Operations
﻿Equality﻿, Membership﻿, Text﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Text-like﻿﻿
Compatible RHS value types
﻿Text﻿, Numbers﻿﻿
﻿
Dropdown-like
Property
Value
Sugar Field Types
enum, multienum
Supported Operations
﻿Equality﻿, Membership﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Dropdown-like﻿﻿
Compatible RHS value types
﻿Text﻿﻿
﻿
Number-like
Property
Value
Sugar Field Types
tinyint, smallint, int, integer, long, float, decimal
Supported Operations
﻿Equality﻿, Comparison﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Text-like﻿, Number-like﻿﻿
Compatible RHS value types
﻿Numbers﻿﻿
﻿
Currency
Property
Value
Sugar Field Types
currency
Supported Operations
﻿Equality﻿, Comparison﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Currency﻿, Text-like﻿, Number-like﻿﻿
Compatible RHS value types
﻿Currencies﻿﻿
﻿
Temporal-like
Property
Value
Sugar Field Types
date, datetime, datetimecombo
Supported Operations
﻿Equality﻿, Comparison﻿, Temporal﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Text-like﻿, Temporal﻿﻿
Compatible RHS value types
﻿Text﻿, Temporal﻿﻿
﻿
Binary
Property
Value
Sugar Field Types
bool
Supported Operations
﻿Equality﻿, Emptiness﻿﻿
Compatible RHS field types
﻿Binary﻿﻿
Compatible RHS value types
﻿Binary﻿﻿
﻿
Links
Property
Value
Sugar Field Types
link, email
Supported Operations
﻿Emptiness﻿﻿
Compatible RHS field types
None
Compatible RHS value types
None
﻿
ID-like
Property
Value
Sugar Field Types
id, assigned_user_name, modified_user_name, relate
Supported Operations
﻿Equality﻿, Membership﻿, Text﻿, Emptiness﻿﻿
Compatible RHS field types
﻿ID-like﻿﻿
Compatible RHS value types
﻿Text﻿﻿
﻿

Property	Value
Sugar Field Types	text, varchar, name, html, longtext, phone, url, username
Supported Operations	Equality, Membership, Text, Emptiness
Compatible RHS field types	Text-like
Compatible RHS value types	Text, Numbers

Property	Value
Sugar Field Types	enum, multienum
Supported Operations	Equality, Membership, Emptiness
Compatible RHS field types	Dropdown-like
Compatible RHS value types	Text

Property	Value
Sugar Field Types	tinyint, smallint, int, integer, long, float, decimal
Supported Operations	Equality, Comparison, Emptiness
Compatible RHS field types	Text-like, Number-like
Compatible RHS value types	Numbers

Property	Value
Sugar Field Types	currency
Supported Operations	Equality, Comparison, Emptiness
Compatible RHS field types	Currency, Text-like, Number-like
Compatible RHS value types	Currencies

Property	Value
Sugar Field Types	date, datetime, datetimecombo
Supported Operations	Equality, Comparison, Temporal, Emptiness
Compatible RHS field types	Text-like, Temporal
Compatible RHS value types	Text, Temporal

Property	Value
Sugar Field Types	bool
Supported Operations	Equality, Emptiness
Compatible RHS field types	Binary
Compatible RHS value types	Binary

Property	Value
Sugar Field Types	link, email
Supported Operations	Emptiness
Compatible RHS field types	None
Compatible RHS value types	None

Property	Value
Sugar Field Types	id, assigned_user_name, modified_user_name, relate
Supported Operations	Equality, Membership, Text, Emptiness
Compatible RHS field types	ID-like
Compatible RHS value types	Text

Updated 25 Mar 2024

Did this page help you?

Values

Useful Examples