Skip to content

Show Variables

Shows the variables.

Permissions

Command KindNeeded User Kind
ReadAll

Parameters

NameTypeDescriptionRequiredDefaultValues
FindstringValue to search for in name and captions.no
MaxRecordsintegerMaximum number of records to be returned. The default value is 500000.no500000
SortstringSorts the output by name or caption ([Field].[Caption1]). The field can be [Variable]/[Name], [Caption1], [Caption2], [Caption3], [Caption4], [Caption5], [Caption6], [Caption7], [Caption8], [Caption9], [Caption10]. Sort can be Ascending (Asc) or Descending (Desc), e.g. [Caption1].[Ascending]no

Result

NameTypeDescription
VariablestringName of the variable.
Caption1stringCaption 1
Caption2stringCaption 2
Caption3stringCaption 3
Caption4stringCaption 4
Caption5stringCaption 5
Caption6stringCaption 6
Caption7stringCaption 7
Caption8stringCaption 8
Caption9stringCaption 9
Caption10stringCaption 10
ValuestringValue of the variable.

Code

text
SHOW VARIABLES
FIND=[string]
MAXRECORDS=[integer, default=500000]
SORT=[string]