POST 17.0/database/reportmacrofilters/list

Description

Retrieve a list of Report Macro Filters

URI Parameters

None.

ListOptions
Name Description Type Additional information
Fields

Collection of string

None.
Filters

Collection of DatabaseFilter

None.
Order

string

None.

application/json, text/json
Sample: 
{
  "fields": [
    "sample string 1",
    "sample string 2"
  ],
  "filters": [
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    },
    {
      "fieldName": "sample string 1",
      "value": "sample string 2",
      "operator": "sample string 3",
      "valueType": "sample string 4"
    }
  ],
  "order": "sample string 1"
}

application/xml, text/xml
Sample: 
<ListOptions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Fields>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </Fields>
  <Filters>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
    <DatabaseFilter>
      <FieldName>sample string 1</FieldName>
      <Value>sample string 2</Value>
      <Operator>sample string 3</Operator>
      <ValueType>sample string 4</ValueType>
    </DatabaseFilter>
  </Filters>
  <Order>sample string 1</Order>
</ListOptions>

application/x-www-form-urlencoded
Sample:

Sample not available.

Collection of ReportMacroFiltersUpdate
Name Description Type Additional information
ReportMacroID

integer

None.
ItemID

integer

None.
FilterID

string

String length: inclusive between 0 and 100
Include

byte

None.
Value1

string

String length: inclusive between 0 and 255
Value2

string

String length: inclusive between 0 and 255
DateRange

byte

None.

application/json, text/json
Sample: 
[
  {
    "reportMacroID": 1,
    "itemID": 1,
    "filterID": "sample string 1",
    "include": 64,
    "value1": "sample string 2",
    "value2": "sample string 3",
    "dateRange": 64
  },
  {
    "reportMacroID": 1,
    "itemID": 1,
    "filterID": "sample string 1",
    "include": 64,
    "value1": "sample string 2",
    "value2": "sample string 3",
    "dateRange": 64
  }
]

application/xml, text/xml
Sample: 
<ArrayOfReportMacroFiltersUpdate xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <ReportMacroFiltersUpdate>
    <ReportMacroID>1</ReportMacroID>
    <ItemID>1</ItemID>
    <FilterID>sample string 1</FilterID>
    <Include>64</Include>
    <Value1>sample string 2</Value1>
    <Value2>sample string 3</Value2>
    <DateRange>64</DateRange>
  </ReportMacroFiltersUpdate>
  <ReportMacroFiltersUpdate>
    <ReportMacroID>1</ReportMacroID>
    <ItemID>1</ItemID>
    <FilterID>sample string 1</FilterID>
    <Include>64</Include>
    <Value1>sample string 2</Value1>
    <Value2>sample string 3</Value2>
    <DateRange>64</DateRange>
  </ReportMacroFiltersUpdate>
</ArrayOfReportMacroFiltersUpdate>