query

An query datasource that uses a free-formed SQL select to provide read-only data.

Syntax:

[ ApiDoc ] ( DynamicComponentDependency )* query QueryName {
( LuDefinition | KeysDefinition | LunameDefinition | KeyrefDefinition | DependenciesDefinition | FromDefinition | WhereDefinition | DataitemDefinition | ComputeditemDefinition | FunctionDefinition | ActionDefinition | ArrayDefinition | AggregateDefinition | TransactionGroupDefinition | SyncPolicyDefinition | ExcludeFromConfigFlagSetting | OfflineQueryDefinition )*
}

This is typically generated for all referenced entity models and need not be specified, unless some properties or attributes need to be changed. Note: Avoid using prefix and suffix like LOV, Query, Qry etc for the Query name. 


         query MaintenanceObject {
            from = "maintenance_object_lov";
            keys = Contract, MchCode;
            attribute Contract Text;
            attribute MchCode Text;
            attribute MchName Text;
         }

QueryName

Query name

Syntax:

<Identifier>

Restrictions:

This page is generated from IFS Developer Studio at 2021-08-13 08:48.