Question: What are operators in Act!?
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium (access via web), Act! Premium, Act! Premium Cloud
Version: 2010 (v12) and later
Answer:
Operators are used for defining criteria for lookups, advanced queries, and dynamic group membership. They define the relationship between a chosen field and the value you wish to search for. For example, if you were to create a lookup in your database for all Contacts whose City is Equal to Denver, “Equal to” would be considered the operator for that lookup, whereas "Denver" would be the value
See the table below for a list of operators available in Act!:
Note: Operator availability is dependent upon the type of field chosen. Not all fields will have all of the operators listed below as an option.
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium (access via web), Act! Premium, Act! Premium Cloud
Version: 2010 (v12) and later
Answer:
Operators are used for defining criteria for lookups, advanced queries, and dynamic group membership. They define the relationship between a chosen field and the value you wish to search for. For example, if you were to create a lookup in your database for all Contacts whose City is Equal to Denver, “Equal to” would be considered the operator for that lookup, whereas "Denver" would be the value
See the table below for a list of operators available in Act!:
Note: Operator availability is dependent upon the type of field chosen. Not all fields will have all of the operators listed below as an option.
Contains/b> | Chosen field contents contained the specified value |
Contains Data/b> | Chosen field is not blank (This operator does not allow you to specify a value) |
Does Not Contain/b> | Chosen field does not contain the specified value |
Does Not Contain Data | Chosen field is blank (this operator does not allow you to specify a value |
Ends With | Chosen field contents end with the specified value |
Equal To (=) | Chosen field contents match the exact specified value |
Greater Than | Chosen field contents consist of a numeric value that is greater than the specified value |
Greater Than or Equal To | Chosen field contents consist of a numeric value that is less than or equal to the specified value |
Less Than | Chosen field contents consist of a numeric value that is less than the specified value |
Less than or Equal To | Chosen field contents consist of a numeric value that is less than or equal to the specified value |
Not Equal To (!=) | Chosen field contents do not match the exact specified value |
On or Before | Chosen field contents consist of a date that matches or is prior to the specified date |
Starts With | Chosen field contents begin with the specified value |
Within Last (days) | Chosen field contents consist of a date that is equal to or before today’s date within the number of days specified (Ex: a value of 2 will find items for today and yesterday only) |
Within Next (days) | Chosen field contents consist of a date that is a specified number of days beyond today (Ex: a value of 2 will find items for tomorrow and the day after only) |
After Next (days) | Chosen field contents consist of a date that falls after a specified number of days (Ex: a value of 2 will find the date that is after the next 2 days from today) |
Day Equals (number) | Chosen field contents consist of the numeric day of the month specified (1-31) |
Month Equals (number) | Chosen field contents consist of the numeric month specified (1-12) |
Year Equals (number) | Chosen field contents consist of the 4-digit year specified |
On or After (date) | Chosen field contents consist of dates that are on or after a specified date |