SysQuery Class [AX 2012]
Syntax
class SysQuery extends Query
Run On
Called
Methods
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 |
Top
Remarks
The SysQuery class enables you to create, read, update, and delete X++ code and metadata.
Inheritance Hierarchy
Object Class
TreeNode Class
Query Class
SysQuery Class