View this page in the latest version of Appian. a!queryColumn() Function Share Share via LinkedIn Reddit Email Copy Link Print On This Page Function a!queryColumn( field, alias, visible ) Creates a Column object for use inside a Selection object. See also: Column, Selection, Query Parameters Keyword Type Description field Text The field of the data type you want to retrieve. The fields available depend on the source of the data and the data type of that source. alias Text The short name by which the result of the Column value can be referenced in other areas of the Query value. Values are case-sensitive. visible Boolean Determines whether the column should be visible to end users. If false, the data for the column will not be retrieved, but it can be used for sorting. Default value is true. Returns Selection Usage considerations Using the fields parameter The field parameter is required. Fields that are children of a multiple cannot be selected. Using the alias parameter If no alias is given, the alias for the column will be inferred as the field value. If the alias is not provided and the field name collides with another existing alias, the field name will be suffixed with an incremented digit appended to the end when returned in the result. Feature compatibility The table below lists this function's compatibility with various features in Appian. Feature Compatibility Note Portals Partially compatible Can be used with Appian Portals if it is connected using an integration and web API. Offline Mobile Partially compatible Can be used with offline mobile if it is loaded at the top of the form. Sync-Time Custom Record Fields Incompatible Real-Time Custom Record Fields Incompatible Custom record fields that evaluate in real time must be configured using one or more Custom Field functions. Process Reports Incompatible Cannot be used to configure a process report. Process Events Incompatible Cannot be used to configure a process event node, such as a start event or timer event. Feedback Was this page helpful? SHARE FEEDBACK Loading...