SysQuery Class [AX 2012]
| Method | Description | |
|---|---|---|
| addBaseQuery | (Inherited from Query.) |
| addCompanyRange | (Inherited from Query.) |
| addDataSource | Adds a data source to the top level of the query. (Inherited from Query.) |
| addHavingFilter | (Inherited from Query.) |
| addQueryFilter | (Inherited from Query.) |
| allowCheck | (Inherited from Query.) |
| allowCrossCompany | (Inherited from Query.) |
| allowHavingFilters | (Inherited from Query.) |
| allowQueryFilters | (Inherited from Query.) |
| AOTadd | Creates a subnode to the tree node in the Application Object Tree (AOT). (Inherited from TreeNode.) |
| AOTaddExtendedDataType | This method is not supported in Microsoft Dynamics AX. If you need to add a subnode of this type, use the instead. (Inherited from TreeNode.) |
| AOTaddRelation | This method is not supported in Microsoft Dynamics AX. If you need to add a subnode of this type, use the instead. (Inherited from TreeNode.) |
| AOTaddSubNode | Creates subnodes for extended data types and relations. (Inherited from TreeNode.) |
| AOTaddXref | (Inherited from TreeNode.) |
| AOTAllowEdit | (Inherited from TreeNode.) |
| AOTbitmapId | Returns the resource ID of the bitmap of the tree node. (Inherited from TreeNode.) |
| AOTchildNodeCount | Counts the number of child nodes that a given tree node has. (Inherited from TreeNode.) |
| AOTcompile | Compiles this node and its subnodes. (Inherited from TreeNode.) |
| AOTconfigure | (Inherited from TreeNode.) |
| AOTdelete | Deletes the tree node in the development layer that you are currently working in. (Inherited from TreeNode.) |
| AOTDrop | Creates a copy of a specified tree node as a child to the TreeNode object. (Inherited from TreeNode.) |
| AOTDuplicate | (Inherited from TreeNode.) |
| AOTedit | Opens the appropriate editor for this node. (Inherited from TreeNode.) |
| AOTendXref | (Inherited from TreeNode.) |
| AOTfindChild | Finds the specified child node of this node. (Inherited from TreeNode.) |
| AOTfirstChild | Retrieves the first child of the tree node. (Inherited from TreeNode.) |
| AOTfirstChildEx | (Inherited from TreeNode.) |
| AOTgetExecutableLineCount | Returns the number of executable lines of code for this node. (Inherited from TreeNode.) |
| AOTgetExecutableLines | Returns the executable lines of code for this node. (Inherited from TreeNode.) |
| AOTGetModel | (Inherited from TreeNode.) |
| AOTgetProperties | Returns a string containing the properties of the tree node. (Inherited from TreeNode.) |
| AOTgetPropertiesExt | (Inherited from TreeNode.) |
| AOTgetProperty | (Inherited from TreeNode.) |
| AOTgetSource | Returns the source code of this node. (Inherited from TreeNode.) |
| AOTIncludeInCompare | (Inherited from TreeNode.) |
| AOTinsert | Inserts a node among the subnodes of this node. (Inherited from TreeNode.) |
| AOTIsDirty | (Inherited from TreeNode.) |
| AOTIsOld | Indicates whether this node is from a file found in the old model store. (Inherited from TreeNode.) |
| AOTIsPersisted | Indicates whether this node has been persisted in the model store. (Inherited from TreeNode.) |
| AOTIsProxyNode | (Inherited from TreeNode.) |
| AOTiterator | Returns an object which can be used to iterate the child nodes of the tree node. (Inherited from TreeNode.) |
| AOTKernelHelpType | (Inherited from TreeNode.) |
| AOTLayer | Returns the layer of the tree node. (Inherited from TreeNode.) |
| AOTLayers | Returns a collection of the layers the tree node is defined in. (Inherited from TreeNode.) |
| AOTload | Ensures that the object is loaded. (Inherited from TreeNode.) |
| AOTmakeXref | Compiles this node and its subtree in the AOT, updating the cross-reference system. (Inherited from TreeNode.) |
| AOTmessageLine | Writes text to the Application Object Tree (AOT) Message window. (Inherited from TreeNode.) |
| AOTMove | (Inherited from TreeNode.) |
| AOTname | Returns the value of the name property of the node. (Inherited from TreeNode.) |
| AOTnewWindow | Opens a new AOT tree window with the tree node as the root. (Inherited from TreeNode.) |
| AOTnextSibling | Returns the next node on the same level as the tree node. (Inherited from TreeNode.) |
| AOTObjectNode | Indicates whether the node is an application object. (Inherited from TreeNode.) |
| AOToverlayBitmapId | Returns the resource ID of the overlay in the AOT associated with this node. (Inherited from TreeNode.) |
| AOTparent | Returns the parent node of the tree node. (Inherited from TreeNode.) |
| AOTprevious | Returns the previous sibling of this tree node. (Inherited from TreeNode.) |
| AOTrefresh | Refreshes the node with the latest changes to the .aod file. (Inherited from TreeNode.) |
| AOTregenerate | (Inherited from TreeNode.) |
| AOTRename | (Inherited from TreeNode.) |
| AOTrestore | Reloads this node from the disk, if applicable. (Inherited from TreeNode.) |
| AOTrun | Compiles this node and its subtree in the Application Object Tree (AOT). (Inherited from TreeNode.) |
| AOTsave | Saves an Application Object Tree (AOT) node. (Inherited from TreeNode.) |
| AOTSetModel | (Inherited from TreeNode.) |
| AOTsetProperties | (Inherited from TreeNode.) |
| AOTsetPropertiesExt | (Inherited from TreeNode.) |
| AOTsetProperty | (Inherited from TreeNode.) |
| AOTsetSource | Sets the source code of this node. (Inherited from TreeNode.) |
| AOTshowProperties | Opens the property sheet (if not already open) and shows the properties for this node. (Inherited from TreeNode.) |
| AOTtoolTip | Returns the tool tip associated with the tree node. (Inherited from TreeNode.) |
| AOTToString | (Inherited from TreeNode.) |
| AOTtypeStr | Returns the internal string code for the element type used in XPO files. (Inherited from TreeNode.) |
| AOTUtilFileType | Retrieves the value of the UtilFileType enumeration type for the TreeNode object. The UtilFileType indicates which kind of file the application object is stored in. (Inherited from TreeNode.) |
| applObjectId | Returns the application object ID, if applicable. (Inherited from TreeNode.) |
| applObjectLayerMask | Returns a bitmask that specifies which layers contain this element. (Inherited from TreeNode.) |
| applObjectOldLayerMask | Returns a bitmask that specifies which layers contain this element in the baseline model store. (Inherited from TreeNode.) |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| changedBy | Gets or sets the name of the user that last changed the Query object. (Inherited from Query.) |
| changedDate | Gets or sets the date an application object was last changed. (Inherited from Query.) |
| changedTime | Gets or sets the time an application object was last changed. (Inherited from Query.) |
| checkAuthorizationOnOpenRanges | (Inherited from Query.) |
| checkFieldAccess | (Inherited from Query.) |
| checkRangeParsingErrors | (Inherited from Query.) |
| childDataSourceCount | Counts the number of data sources that pertain to the query. (Inherited from Query.) |
| childDataSourceNo | Returns the child data source corresponding to the specified number. (Inherited from Query.) |
| clearAllFields | (Inherited from Query.) |
| clearBaseQueries | (Inherited from Query.) |
| clearCompanyRange | (Inherited from Query.) |
| clearGroupBy | (Inherited from Query.) |
| clearHavingFilters | (Inherited from Query.) |
| clearOrderBy | (Inherited from Query.) |
| clearQueryFilters | (Inherited from Query.) |
| createdBy | Gets or sets the name of the user who created the application object. (Inherited from Query.) |
| creationDate | Gets or sets the date an application object was created. (Inherited from Query.) |
| creationTime | (Inherited from Query.) |
| dataSourceCount | Returns the total number of data sources for the query, including any embedded data sources. (Inherited from Query.) |
| dataSourceName | Returns the data source that has the specified name. (Inherited from Query.) |
| dataSourceNo | Returns the data source specified by the data source number. (Inherited from Query.) |
| dataSourceTable | Returns the data source that has the specified table assigned to it. (Inherited from Query.) |
| dataSourceUniqueId | (Inherited from Query.) |
| description | (Inherited from Query.) |
| equal | Evaluates whether one query is equal to another. (Inherited from Query.) |
| exportXML | (Inherited from Query.) |
| finalize | (Inherited from Query.) |
| findHavingFilterByField | (Inherited from Query.) |
| findQueryFilter | (Inherited from Query.) |
| forceNestedLoop | (Inherited from Query.) |
| forceSelectOrder | (Inherited from Query.) |
| form | (Inherited from Query.) |
| getCompanyRange | (Inherited from Query.) |
| getMostRestrictedQueryFilterStatus | (Inherited from Query.) |
| getNextUniqueId | (Inherited from Query.) |
| getNodeInLayer | Retrieves a version of the tree node from a specified layer. (Inherited from TreeNode.) |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| getValidTimeStateDateRange | (Inherited from Query.) |
| getValidTimeStateDateTimeRange | (Inherited from Query.) |
| getValidTimeStateQueryType | (Inherited from Query.) |
| groupByField | (Inherited from Query.) |
| groupByFieldCount | (Inherited from Query.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| hashKey | (Inherited from TreeNode.) |
| hasRangeOrFilter | (Inherited from Query.) |
| havingFilter | (Inherited from Query.) |
| havingFilterCount | (Inherited from Query.) |
| inReport | Determines whether the query is part of a report. (Inherited from Query.) |
| interactive | Specifies whether or not the query is interactive, such as showing a dialog box. (Inherited from Query.) |
| isCompositeQuery | (Inherited from Query.) |
| isPureUnionAll | (Inherited from Query.) |
| levelNo | Determines the level of indentation of the specified data source. (Inherited from Query.) |
| levelTable | Determines the tree level, in the hierarchy of data sources, of the data source assigned to the specified table. (Inherited from Query.) |
| literals | (Inherited from Query.) |
| makeCopy | (Inherited from TreeNode.) |
| name | Gets or sets the name that is used in code to identify a form, report, table, query, or another Microsoft Dynamics AX application object. (Inherited from Query.) |
| new | Creates a query object. (Inherited from Query.) |
| newObject | Creates a query that exists on the same Client/Server side as the source query. (Inherited from Query.) |
| newObjectName | Returns a string that contains the name of the new element. (Inherited from TreeNode.) |
| nextUniqueId | (Inherited from Query.) |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| orderByField | (Inherited from Query.) |
| orderByFieldCount | (Inherited from Query.) |
| origin | (Inherited from Query.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| pack | Packs the query into a container and returns that container, which can then be used when you create a query. (Inherited from Query.) |
| packInternals | (Inherited from Query.) |
| queryFilter | (Inherited from Query.) |
| queryFilterCount | (Inherited from Query.) |
| queryType | (Inherited from Query.) |
| recordLevelSecurity | (Inherited from Query.) |
| report | Returns the report in which the query is defined, if the report exists. (Inherited from Query.) |
| resetValidTimeStateQueryType | (Inherited from Query.) |
| saved | Indicates whether the query has been saved to the disk. (Inherited from Query.) |
| searchable | (Inherited from Query.) |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| title | (Inherited from Query.) |
| toString | Returns a string that represents the current object. (Inherited from Query.) |
| treeNodeExport | Exports this node and its subtree from the Application Object Tree (AOT). (Inherited from TreeNode.) |
| treeNodeName | Returns the name of the tree node. (Inherited from TreeNode.) |
| treeNodePath | Returns the unique path to the tree node within the Application Object Tree (AOT). (Inherited from TreeNode.) |
| treeNodeRelease | Releases the tree node explicitly. (Inherited from TreeNode.) |
| treeNodeType | Retrieves an instance of a TreeNodeType class that provides reflection information for the tree node. (Inherited from TreeNode.) |
| unpackInternals | (Inherited from Query.) |
| updateNodePermissions | (Inherited from TreeNode.) |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| userUpdate | Gets or sets whether the query is allowed to update the records it fetches. (Inherited from Query.) |
| utilElement | Returns a UtilElements record that is related to the node. (Inherited from TreeNode.) |
| utilIdElement | Returns a UtilIdElements record that is related to the node. (Inherited from TreeNode.) |
| validateNameCharacters | (Inherited from TreeNode.) |
| validTimeStateAsOfDate | (Inherited from Query.) |
| validTimeStateAsOfDateTime | (Inherited from Query.) |
| validTimeStateDateRange | (Inherited from Query.) |
| validTimeStateDateTimeRange | (Inherited from Query.) |
| version | (Inherited from Query.) |
| wait | Pauses a process. (Inherited from Object.) |
| xml | Returns an XML string that represents the current object. (Inherited from Query.) |
| ::addCollectedSelectionFields | Adds the collected selection fields to the query data sources field selection list. |
| ::addDimensionAttributeFilter | Adds the appropriate joins and filters to the query to filter results by a specific dimension attribute and value. |
| ::addDimensionAttributeRange | Adds the appropriate joins and ranges to the query that are used to filter the results by a specific dimension attribute and value. |
| ::addDimensionDataSource | Adds the appropriate joins to the query to pivot the specified dimension information as a column on the query. |
| ::addFilterFromKeyData | Adds key data as filters to the query |
| ::addIndexToOrderBy | Adds the fields of an index to the order by list of a QueryBuildDataSource Class object. |
| ::addLockRange_RU | |
| ::addOrderByDimensionAttribute | Sorts the query by the specified dimension information. |
| ::addRangesFromKeyData | |
| ::addTableRelation | |
| ::clearAndCollectSelectionFields | Clears fields from a query that are not a database or computed column type. |
| ::clearDimensionRangesFromQuery | Clears all ranges related to the dimension field in the input query. |
| ::copyDynalinks | |
| ::countLoops | |
| ::countPrim | |
| ::countTotal | |
| ::deleteDynalinks | |
| ::disabledDataSourceSet | |
| ::disabledDataSourceSetChildren | |
| ::findField | Finds the index of the specified field in the list of fields of the specified data source. |
| ::findGroupByField | Finds the group by field based on the specified parameters. |
| ::findOrCreateDataSource | Finds or creates a QueryBuildDataSource from the specified parameters. |
| ::findOrCreateDataSourceByName | Finds or creates a QueryBuildDataSource object from the specified String. |
| ::findOrCreateGroupByField | Finds or creates a group by field on a given data source. |
| ::findOrCreateQueryFilter | Finds or creates a QueryFilter object from the specified parameters. |
| ::findOrCreateRange | |
| ::findSortingNo_W | |
| ::findTargetQueryFilter | |
| ::getDimComponentAttAndFieldFromOrderBy | Determines the dimension component being sorted by. |
| ::getDimensionAttributeValLocFromQueryRun | Retrieves the location of the value of the specified dimension from the QueryRun object and authorization information. |
| ::getDimensionAttributeValNameFromQueryRun | Gets the description of the specified dimension from a specified QueryRun object and authorization information. |
| ::getDimensionAttributeValueFromQueryRun | Retrieves the value of the specified dimension from the QueryRun object and authorization information. |
| ::getDimensionOrderBysFromQuery | Gets the list of dimension ranges in a query. |
| ::getDimensionProviderFromFieldInQuery | Gets the dimension provider for the specified field in the query. |
| ::getDimensionRangesFromQuery | Gets the list of dimension ranges in a query. |
| ::getDimensionStringValueFromCursor | Gets a string that represents the concatenated dimension information from the specified field. |
| ::getValueQueryForDimensionAttribute | Gets a query for the specified table with a pivoted column for the specified dimension. |
| ::hasIndexImplicit | Ensure if index field has field name matches with one provided |
| ::hasIndexImplicitFilter | Validates that the index field has an implicit query filter applied. |
| ::hasIndexImplicitRange | Validates that the index field has an implicit query build range applied. |
| ::hasSurrogateFKImplicitFilter | Validates that the field identifier has an implicit query filter applied. |
| ::isDimensionDataSource | Indicates whether a data source is a dimension data source. |
| ::isNullValue | |
| ::isPackedOk | |
| ::literalFilterValue | Transforms a non-literal filter value that contains special values into a String with all special characters escaped. |
| ::mergeFilters | Merges the filters from the source query to the target query. |
| ::mergeRanges | |
| ::packDataSource | |
| ::packDataSourceAggregates | This method packs the aggregate information from the data source into a container. |
| ::packDataSourceHaving | Packs the having clause information from the data source into a container. |
| ::packDimensionRanges | Packs dimension ranges from the query. |
| ::packHandleSortIndex | |
| ::packQueryFilters | Packs the query filters |
| ::packRangeAndSortorder | |
| ::packValidTimeRanges | |
| ::queryAddDynaCursorAsRangeAndValue | |
| ::queryAddDynalinksFromGroupBy | Creates dynamic links for all the fields by which the query should be grouped. |
| ::queryAddStaticCursorAsRangeAndValue | |
| ::queryAddUniqueRangeAndValue | |
| ::queryFromKeyData | |
| ::queryFromTableRelation | |
| ::queryHasFilters | Gets a boolean value that indicates whether the query has any filters. |
| ::queryHasRanges | Gets a boolean value that indicates whether the query has any ranges. |
| ::queryHasRangesOrFilters | Gets a boolean value that indicates whether the query has any ranges or filters. |
| ::range | Retrieves a string that represents a range filter that can be used as value for a QueryBuildRange object. |
| ::tableOccurrence | |
| ::tableOccurrenceText | |
| ::unpackCompanyRanges | Unpacks the ranges that are contained by the companyRanges parameter and adds them to the specified query. |
| ::unpackDataSource | |
| ::unpackDataSourceAggregates | Unpacks the previously packed aggregate information into the data source. |
| ::unpackDataSourceHaving | Unpacks previously packed having clause information into the data source. |
| ::unpackDimensionRanges | Unpacks dimension ranges for a query. |
| ::unpackGroupAndOrder | |
| ::unpackQueryFilters | Unpacks the query filters. |
| ::unpackRangeAndSortorder | |
| ::unpackValidTimeRanges | Unpacks the ranges that are contained by the specified valid time ranges container and adds them to the specified query. |
| ::updatePackedRangesAndSorting | |
| ::value | |
| ::valueEmptyString | |
| ::valueLike | |
| ::valueLikeAfter | |
| ::valueNot | |
| ::valueNotEmptyString | |
| ::valueUnlimited |
Community Additions
ADD
Show: