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