Literals Available in Query Builder

Often you might want to use a literal value when building a group using the Query Builder, such as the userid of the currently logged in user. There are some undocumented literals available in the Query Builder that allow you to do just this. Here’s a list of the literals available to you:

Literals used in both clients (using “=” or “starting with” as the operator)
:now
:time
:date
:BindID
:AdHocGroupID
:UserID
:OwnerID

Literals ONLY in the Support Client (using “in” as the operator)
:accountownerlist
:pluginownerlist
:ticketassignlist
:defectownerlist
:defectassignlist

If you want to build a group that displays all accounts created by the currently logged in user, select your field containing a userid, in this case CREATEUSER, then enter :userid as the value and check the box that says use value as literal.

ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!