Query object expressions

Official Content
This documentation is valid for:

When adding query elements to a query definition, several options are available to  be assigned.

Arithmetic expressions

Any valid arithmetic expression such as:

  • CustomerAge + CustomerIdentifierId – 1245
  • InvoiceSubtotal * 2

Aggregate expressions

Any valid aggregatte expression such as:

  • Sum(CustomerId + CustomerId)
  • Sum(InvoiceTaxes+InvoiceNonTaxes)
  • Sum(CustomerId) + Sum(CustomerId)
  • Sum(InvoiceTotal)/Count(InvoiceId)

Filtering expressions

A valid filtering expression:

  • Sum(InvoiceTotal) where Year(InvoiceDate) = 2008
  • Sum(InvoiceTotal) where Year(InvoiceDate) < 2008 / Sum(InvTot) where Year(InvoiceDate) > 2007

Functions

The following list of available functions can be used:

Examples

  • Month(InvDate)
  • Trim(Str(Year(InvoiceDate)))
  • Upper(CustomerName)


Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.