1. Query detail

    Article: AN0002256Updated: 20.11.2020

    Defined query settings and properties.

    Toolbar

    Icon Description
    Return to the list of queries.
    Creation of a new query.
    Saving changes in the query
    Query deletion.
    Button Next - context menu with further selections.
    Displays query columns.
    Displays query data.
    It goes to the list of buttons defined for the query.
    It goes to the list of rules defined in the query.
    Displays Automated Time Operations defined in the query.
    Displays object relations of the query.
    Displays formular and order of columns in the list of records.

     

    TAB - Basic properties

    Section: Basic properties

    • Model - Name of model in which the query is defined
    • Code - Query identifier, that is used by export and import of the metadata of the model between various application instances.
    • Name - Query name
    • Note - Brief description of the query

    Section: Administration of records

    • Enable displaying list of records - Defines if it is possible to display records in the list.
    • Enable displaying record detail - Defines if it is possible to display record detail.
    • Enable displaying detailed list - Defines if it is possible to display records in the detailed list.
    • Default display of the list of records - Defines what is the default display of the record list.
      • Table list
      • Detailed list

    Section: Audit trail

    • Created by - User that created the record (query).
    • Created when - Date and time of record (query) creation.
    • Changed by - User that changed whatever data in the record (query) the last time.
    • Changed when - Date and time of the last change in the record (query).

    TAB - Query definition

    Section: Query definition

    • Enter the query by means of Transact SQL. You can refer to the model or class by the full or short reference (the other way only in case that the class and the query are in the same model) - {{:model.it-configurations.class.domains:}}, {{:class.domains:}}. After entering the class or another query it is necessary to name them in the query - e.g.: Select * from {{:class.domains:}} doms
    • Examples of query creation.

    TAB - Roles and display

    Section: Access permission

    • Enable access via web services - determines if the class data can be accessed via web service.

    Section: Default display 

    • Display in the default menu - Determines if the query should be displayed in the model menu.
    • Enable navigation in the form - Defines if the form with a record detail should contain navigation for a quick switch between query records.
    • Sort according to the column 1,2,3 - Defines default sorting of the list of records by up to three columns.
    • Display row numbering in the list - Defines if the number of the row should be displayed by the list display.

    Section: List of roles 

    • Role - Definition of the access right type to records of the selected query for roles working with model. Access right can be only granted to roles enabled for the model to which the class belongs to.
    • Operation - Definition of possible activities for the selected role:
      • Reading data in the list - user is authorized to display records of the query
      • Reading data in detail - user is authorized to display record detail of the query

    TAB - Further settings

    Section: Further functions

    • Enable record selection - It defines, whether there shall be checkboxes for records selection in the master-detail relation.

    Section: RSS

    • Enable RSS - Enables to create RSS channel publishing the query records.
    • Number of records in the RSS feed - Defines number of records that will be entered into the RSS feed. If the number is not entered or when it is set to 0, all the records will be returned.
    • Column for heading - Defines column from the query whose values will be used for heading.
    • Column for description - Defines column from the given query, whose values will be used for description.
    • RSS heading format - Text control for entering RSS heading with the possibility to create expressions.
    • RSS description format - Text control for entering RSS description with the possibility to create expressions.
    • Publicly available - Defines if the RSS feed should be accessible publicly also out of range of application users.
    • Reference to RSS channel - Displays RSS channel.

    Section: Information text

    • Information text in the record list - Localized text, that will be displayed at the given class in the list of records under the tool bar.
    • Information text in the record detail - Localized text, that will be displayed at the given class in the record detail under the tool bar.

    TAB - Pictures

    Section: Pictures

    • Query picture - Enables to define picture, that will be added to the query e.g. in menu.
    • Large query picture - The picture that will be used in schemes (Display type: Large Icon).

    TAB - Script

     

     

     

     

     

     

     

     

     

     

     

     

×