Click or drag to resize

SearchFilter Properties

To get started, call one of the following methods:
  • Anysense.API.Client.V1.ApiClient.Create
  • Anysense.API.Client.V1.ApiClient.CreateAsync
  • Anysense.API.Client.V1.ApiClient.CreateWithToken
  • Anysense.API.Client.V1.ApiClient.CreateWithTokenAsync
See Anysense.API.Client.Shared.BaseClient<T> for documentation on these methods.

The SearchFilter type exposes the following members.

Properties
 NameDescription
Public propertyAdditionalSearchFilters List of additional searchfilters which doesn't bind on one particular element. With multiple additional searchfilters, they will be wrapped in parantheses and applition the AdditionalSearchFilterOperator
Public propertyAdditionalSearchFiltersOperator Specified operator to use in SQL statement betweeen each AdditionalSearchFilter.
Public propertyClientIds 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, FilterValues and AddtionalSearchFilters will be ignored.
Public propertyDateEnd Maximum date to return data for.
This parameter will only be used if DateStart is also provided.
This should be null if not specified.
Public propertyDateStart Minimum date to return data for.
This parameter will only be used if DateEnd is also provided.
Public propertyExcludeSubmittedIds 
Public propertyFilters 
Public propertyFilterValues A list of filter values.



Depending on the corresponding form element type various filter formats should be assigned to each list item.

TextBoxNumeric element can be filtered either by providing a specific number (231 or 823.12 etc.), a range ([3;10] etc.) or a create/less than value (>5 or <100 etc.).
There can also be performed an equals filtering on multiple values by submitting a List of integers.

CheckBox and ToggleSwitch elements should be filtered by a bool value (true/false).

DatePicker and DateTimePicker elements should be filtered by using a json encoded object with the following format:
{ "start" : startDateTimeObject, "end" : endDateTimeObject } example: { "start" : "2013-01-10T00:00:00.000Z", "end" : "2013-01-11T00:00:00.000Z" }

TimePicker elements should be filtered similar to DatePicker and DateTimePicker but the start and end properties should only contain the time.
example: { "start" : "10:58:03", "end" : "12:58:05" }

TextBoxText can be filtered by a single value (performs a LIKE search) or multiple values by making an array (performing a EQUALS search).

SubForms can be filtered by json serializing a SearchFilter object

All other form element types will be filtered similar to how username is filtered (that is - "like string").
Public propertyGlobalFilter A filter that will be applied to all text, date, datetime, time and number columns aswell as UserName and ClientSubmittedDate.
Public propertyIds 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, FilterValues and AddtionalSearchFilters will be ignored.
Public propertyOperator Specified operator to use in SQL statement. (AND or OR)
Public propertyUsername 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").
Top
See Also