Appendix 2: Query Language

You can create a search that is built using query language (i.e., syntax such as AND and OR statements). This allows you to be more specific with the inputs in order to filter the data accordingly. See Add a Query for more information on using the following functions in the advanced query:

  • CurrentUserId() - user.UserId
  • CurrentUserSid() - user.EmployeeSid
  • Abs
  • Ceiling
  • Concat
  • Contains
  • DatePart
  • Floor
  • Ln
  • Log10
  • Power
  • Round
  • StringLength
  • Substring
  • ToLower
  • ToUpper