Query Properties |
![]() |
The Query type exposes the following members.
Name | Description | |
---|---|---|
![]() |
Author |
Gets and sets the name of the person who created this query
|
![]() |
BlendingDetails |
Gets and sets an object that defines the properties required for a blending query
|
![]() |
BusinessLogicFixedValueParameterValues |
Gets and sets a dictionary of objects that represent the values to populate the business logic parameters for the subject used in this query
|
![]() |
Category |
Gets and sets the category this query will be published too
|
![]() |
Children |
Gets the collection of child queries
|
![]() |
ChildrenList |
Gets and sets a list of child subjects of this query
|
![]() |
ClearData |
Gets and sets a property that indicates if an accumulating query should clear data on this refresh
|
![]() |
CombineResults |
Gets and sets a value that indicates if the results of a multi level query should be combined into a single dataset
|
![]() |
Comments |
Gets and sets a comments string for this query
|
![]() |
Conditions |
Gets and sets an list of query conditions to be applied to this query
|
![]() |
DataSetName |
Gets a property that indicates the dataset name that will be used for this query's results
|
![]() |
DebugQuery |
Gets and sets a property that indicates if this query will run in debug mode.
|
![]() |
DecimalSeparator |
Gets and sets the Decimal separator
|
![]() |
Description |
Gets and sets a description for this query
|
![]() |
DisplayFields |
Gets and sets the display fields for this query
|
![]() |
ErrorMessage |
Gets and sets a string that will contain any error recorded at the time this query was last run
|
![]() |
ExcelExportProperties |
Gets and sets an object that describes
|
![]() |
ExcelImportProperties |
Gets and sets an object that describes
|
![]() |
FieldLabelsChanged |
Gets a dicionary of the fields that have changed name since the query was last opened
|
![]() |
ForcedConnectionID |
Gets and sets the ID of the connection this query is forced to use
|
![]() |
GoogleAnalyticsDetails |
Gets ansd sets an object that defines the properties for a Google Analytics query
|
![]() |
ID |
Gets a unique identifier for this object
|
![]() |
ImportFile |
Gets and sets the path of the file from which this query will import data
|
![]() |
inmydataSourceData |
Gets and sets the source data for this inmydata query
|
![]() |
inmydataTenant |
Gets and sets the name of the tenant for this inmydata query
|
![]() |
InnerJoin |
Gets and sets a property that indicates if this object is joined to it's parent with an inner join
|
![]() |
Keywords |
Gets and sets a list of keywords to identify this object
|
![]() |
LastRefreshCompleted |
Gets and sets the date and time this query was last refreshed
|
![]() |
LastRefreshCompletedNotNullable |
Gets and sets the date and time this query was last refreshed
|
![]() |
LastRefreshStarted |
Gets and sets the date and time the last refresh of this query started
|
![]() |
LastRefreshStartedNotNullable |
Gets and sets the date and time the last refresh of this query started
|
![]() |
MaxRows |
Gets and sets the maximum number of rows for this query to return
|
![]() |
MillisecondsTakenLastSuccessfulRefresh |
Gets the number of milliseconds taken for the last succesfull refresh of this query
|
![]() |
Modified |
Gets a property that indicates if the Query has been modified since it was last saved.
|
![]() |
Name |
Gets and sets the name of this query
|
![]() |
ObjectSizes |
Gets a dictionary of serialized objects contained in this object, along with their sizes (in bytes)
|
![]() |
OpenAPIClassFile |
Gets and sets a string that identifies the Open API assembly file that will be used to provide data
|
![]() |
OpenAPIClassIdentifier |
Gets and sets a string that identifies the Open API class that will be used to provide data
|
![]() |
OpenAPIConfigurationString |
Gets and sets the configuration string used in conjunction with the OpenAPI class to generate data
|
![]() |
OpenAPIRuntimeConfigurationString |
Gets the configuration string used in conjunction with the OpenAPI class to generate data, with any required field values populated
|
![]() |
ParameterParentColumns |
Gets and sets a dictionary of fields that represent the parent columns used to provide values for a required field in for this subject in a multi-level query
|
![]() |
Parameters |
Gets the query parameters collection
|
![]() |
ParametersList |
Gets and sets a dictionary of parameter objects for this query
|
![]() |
Parent |
Gets and sets the parent query
|
![]() |
QueryBasedOnSubject |
Gets a value that indicates if this query is dependent on a subject
|
![]() |
QueryBasedOnSystem |
Gets a value that indicates if this query is dependent on a system
|
![]() |
QueryLookups | |
![]() |
QueryType |
Gets and sets a value that identifies the type of this query
|
![]() |
RequiredFields |
Gets the query parameters collection (depricated, use parameters)
|
![]() |
ResultsSet |
Gets and sets property that contains the datasets for this query.
|
![]() |
RootQuery |
Gets the root query of this query
|
![]() |
SavedDataAvailable |
Gets a boolean value that indicates if the file required to run a test execution of this query exists and the query has data
|
![]() |
SavedDataFile |
Gets the fully qualified path of the file required to run a test execution of this query
|
![]() |
Silent |
Gets and sets a property that indicates whether the run query screen should be fully hidden in the client if possible
|
![]() |
SkipExport |
Gets and sets a property that indicates if the export screen should be skipped in the rubn query wizard
|
![]() |
SkipIntro |
Gets and sets a property that indicates whether the run query wizard will be forced to skip the introduction screen regardless of the users settings
|
![]() |
SortFields |
Gets and sets a list of columns used to sort the data from this query
|
![]() |
SourceFields |
Gets and sets a collection of fields available from the source dataset
|
![]() |
SplitResults |
Gets and sets a property that indicates if this query will return multiple result sets
|
![]() |
SQLString |
Gets and sets the SQL Query string for this query
|
![]() |
StoredData |
Gets and sets a string that can be used to store any data string in this query
|
![]() |
Subject |
Gets the subject object that this query is based on
|
![]() |
SubjectID |
Gets and sets the ID of the subject used for this query
|
![]() |
SubjectTitle |
Gets a property that indicates the title of the Subject this Query uses.
|
![]() |
SubjectType |
Gets a property that indicates the type of the Subject this Query uses.
|
![]() |
Summarise |
Gets and sets a property that indicates whether this query will summarise the data returned by the Open API query
|
![]() |
SummaryFill |
Gets and sets a value that indicates if any date groupings in a summary query should populate periods without any data
|
![]() |
SystemName |
Gets and sets the system name this query relates to (if any)
|
![]() |
Systems |
Gets and sets the systems object that the subject this query relates to should belong to
|
![]() |
ThousandSeparator |
Gets and sets the thousand separator
|
![]() |
TrendingDetails |
Gets and sets the trending details for this query
|
![]() |
UseLabels |
Gets and sets a property that indicates if this query should us the fields labels in the dataset.
|
![]() |
UseParametersAsDefault |
Gets and sets a value that indicates if the parameter values in this query should be used as the default values for the query required fields
|
![]() |
UserLevel |
Gets and sets the user level for this query
|
![]() |
Version |
Gets and sets the version for this query
|