QueryElementFilters Test
Reporting/QueryElementFilters?groupIds={groupIds}
Get available query element filters for one or more query element groups.
Http Verb GET
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/Reporting/QueryElementFilters?groupIds={groupIds}

URI Parameters

Parameter Name Data Type Required Notes
groupIds string N

Request Body

None.
No request body.

Response object type : Collection of QueryElementFilter

Response object type Collection of QueryElementFilter has the following properties.
Property Name Data Type Length Required Readonly Notes
CreatedBy string N
CreatedDateTime date N
CreateLocation string N
DataType integer N
Description string N
EndOfDay boolean N
FilterElement string N
Group QueryElementGroupSummary N
FK: TR_QUERY_ELEMENT_GROUP.id   Resource: QueryElementGroups
Id integer N
ReferenceDescriptionColumn string N
ReferenceIdColumn string N
ReferenceSort string N
ReferenceTable string N
ReferenceWhere string N
UpdatedBy string N
UpdatedDateTime date N 
[
  {
    "CreatedDateTime": "2025-04-24T04:36:43.374151-07:00",
    "CreateLocation": "sample string 1",
    "CreatedBy": "sample string 2",
    "DataType": 3,
    "Description": "sample string 4",
    "EndOfDay": true,
    "FilterElement": "sample string 6",
    "Id": 1,
    "UpdatedDateTime": "2025-04-24T04:36:43.374151-07:00",
    "UpdatedBy": "sample string 7",
    "ReferenceDescriptionColumn": "sample string 8",
    "ReferenceIdColumn": "sample string 9",
    "ReferenceSort": "sample string 10",
    "ReferenceTable": "sample string 11",
    "ReferenceWhere": "sample string 12",
    "Group": {
      "Id": 1,
      "Description": "sample string 1",
      "Category": 2,
      "IsVirtual": true,
      "NumberOfParameters": 4
    }
  },
  {
    "CreatedDateTime": "2025-04-24T04:36:43.374151-07:00",
    "CreateLocation": "sample string 1",
    "CreatedBy": "sample string 2",
    "DataType": 3,
    "Description": "sample string 4",
    "EndOfDay": true,
    "FilterElement": "sample string 6",
    "Id": 1,
    "UpdatedDateTime": "2025-04-24T04:36:43.374151-07:00",
    "UpdatedBy": "sample string 7",
    "ReferenceDescriptionColumn": "sample string 8",
    "ReferenceIdColumn": "sample string 9",
    "ReferenceSort": "sample string 10",
    "ReferenceTable": "sample string 11",
    "ReferenceWhere": "sample string 12",
    "Group": {
      "Id": 1,
      "Description": "sample string 1",
      "Category": 2,
      "IsVirtual": true,
      "NumberOfParameters": 4
    }
  }
]
<QueryElementFilters xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <QueryElementFilter>
    <CreateLocation>sample string 1</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T04:36:43.374151-07:00</CreatedDateTime>
    <DataType>3</DataType>
    <Description>sample string 4</Description>
    <EndOfDay>true</EndOfDay>
    <FilterElement>sample string 6</FilterElement>
    <Group>
      <Category>2</Category>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <IsVirtual>true</IsVirtual>
      <NumberOfParameters>4</NumberOfParameters>
    </Group>
    <Id>1</Id>
    <ReferenceDescriptionColumn>sample string 8</ReferenceDescriptionColumn>
    <ReferenceIdColumn>sample string 9</ReferenceIdColumn>
    <ReferenceSort>sample string 10</ReferenceSort>
    <ReferenceTable>sample string 11</ReferenceTable>
    <ReferenceWhere>sample string 12</ReferenceWhere>
    <UpdatedBy>sample string 7</UpdatedBy>
    <UpdatedDateTime>2025-04-24T04:36:43.374151-07:00</UpdatedDateTime>
  </QueryElementFilter>
  <QueryElementFilter>
    <CreateLocation>sample string 1</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T04:36:43.374151-07:00</CreatedDateTime>
    <DataType>3</DataType>
    <Description>sample string 4</Description>
    <EndOfDay>true</EndOfDay>
    <FilterElement>sample string 6</FilterElement>
    <Group>
      <Category>2</Category>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <IsVirtual>true</IsVirtual>
      <NumberOfParameters>4</NumberOfParameters>
    </Group>
    <Id>1</Id>
    <ReferenceDescriptionColumn>sample string 8</ReferenceDescriptionColumn>
    <ReferenceIdColumn>sample string 9</ReferenceIdColumn>
    <ReferenceSort>sample string 10</ReferenceSort>
    <ReferenceTable>sample string 11</ReferenceTable>
    <ReferenceWhere>sample string 12</ReferenceWhere>
    <UpdatedBy>sample string 7</UpdatedBy>
    <UpdatedDateTime>2025-04-24T04:36:43.374151-07:00</UpdatedDateTime>
  </QueryElementFilter>
</QueryElementFilters>

No entries in change log for this operation.