• h3. DESCRIPTION:

The unique() function is applied to arrays in order to return a comma separated list of the unique values returned by the select() statement that created the array. Note that the parameter and returned value of the unique() function is an array.

SYNTAX

  • unique(x)
  • unique(Path)

WHERE

  • unique is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
  • x is a variable that contains (points to) the results of select statement
  • Path is a series of ‘Table Names’ and, optionally, a ‘Field Name’ that indicated to Ninox where to find the contents of the array to be returned and analyzed. The path may stay inside of the family or cross over table boundaries to terminate at schema locations other than those inside the current stack or data family.

EXAMPLE

  • let x := select ‘Customer Invoices’.‘Customer’.‘Customer Name’ / unique(x)

SEE ALSO

arrays
select()
Path
Data Family

Revision: 2
Last modified: 2019/11/10

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment