Click or drag to resize
Query Properties DataPA OpenAnalytics
DataPA OpenAnalytics API Reference

The Query type exposes the following members.

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