Query |
The QueryInformation type exposes the following members.
Name | Description | |
---|---|---|
DateEnd |
Data submitted until this datetime should be returned. This parameter will only be used if DateStart is also provided. This should be null if not specified. | |
DateStart |
Data submitted from this datetime should be returned. This parameter will only be used if DateEnd is also provided. This should be null if not specified. | |
Filters |
A list of data indices matching which data columns should be filtered. This means the indexes of the datacolumns, not the indexes of the form element, which means that PivotItem, LookupContainer and TextBlocks should be skipped when calculating the index. It is possible to do a filtering on SubmitDate (-2) and UserName (-1). The length and placement of indexes in the list, must be like the length and placement of values in FilterValues | |
FilterValues |
A list of filter values. See details at AnySenseService.AnySenseService.SearchFormData. | |
IDs | Parameter can be used to request specific data from ids, if the list is empty this parameter will be ignored. If this value is provided Filters and FilterValues will be ignored. | |
Page | The page (zero based) to be retrieved. | |
SortColumn |
The column index that the result should be sorted by.
0, 1, 2... corrosponds to a data column with the specified index. Additional sort by indexes: -1: Submitter username -2: Submitted date -3: Rowversion column -4: Last updater username -5: Last updated date -6: Data Id | |
SortDesc | If true sort the result descending. | |
UserName | Filters the result by username. This value can be a either a partial or full username (etc. "sj" will return all rows submitted by "sje"). | |
VersionId |