QueryElementFilters Test
Reporting/QueryElementFilters
Create a query element filter.
Http Verb POST
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/Reporting/QueryElementFilters

URI Parameters

This resource has no URI (Query) parameters.

Request Body

Request object type : QueryElementFilter

Request object type QueryElementFilter has the following properties.
Property Name Data Type Length Required Readonly Notes
CreatedBy string N Auto-assigned
CreatedDateTime date N Auto-assigned
CreateLocation string N Auto-assigned
DataType integer Y
Description string 60 N
EndOfDay boolean N
FilterElement string 255 N
Group QueryElementGroupSummary N
FK: TR_QUERY_ELEMENT_GROUP.id   Resource: QueryElementGroups
Id integer N Auto-assigned
ReferenceDescriptionColumn string 50 N
ReferenceIdColumn string 50 N
ReferenceSort string 255 N
ReferenceTable string 100 N
ReferenceWhere string 255 N
UpdatedBy string N Auto-assigned
UpdatedDateTime date N Auto-assigned 
{
  "CreatedDateTime": "2025-04-24T04:07:47.7208968-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:07:47.7208968-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
  }
}
<QueryElementFilter xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <CreateLocation>sample string 1</CreateLocation>
  <CreatedBy>sample string 2</CreatedBy>
  <CreatedDateTime>2025-04-24T04:07:47.7208968-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:07:47.7208968-07:00</UpdatedDateTime>
</QueryElementFilter>

Response object type : QueryElementFilter

Response object type QueryElementFilter has the following properties.
Property Name Data Type Length Required Readonly Notes
CreatedBy string N Auto-assigned
CreatedDateTime date N Auto-assigned
CreateLocation string N Auto-assigned
DataType integer Y
Description string 60 N
EndOfDay boolean N
FilterElement string 255 N
Group QueryElementGroupSummary N
FK: TR_QUERY_ELEMENT_GROUP.id   Resource: QueryElementGroups
Id integer N Auto-assigned
ReferenceDescriptionColumn string 50 N
ReferenceIdColumn string 50 N
ReferenceSort string 255 N
ReferenceTable string 100 N
ReferenceWhere string 255 N
UpdatedBy string N Auto-assigned
UpdatedDateTime date N Auto-assigned 
{
  "CreatedDateTime": "2025-04-24T04:07:47.7365187-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:07:47.7365187-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
  }
}
<QueryElementFilter xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <CreateLocation>sample string 1</CreateLocation>
  <CreatedBy>sample string 2</CreatedBy>
  <CreatedDateTime>2025-04-24T04:07:47.7365187-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:07:47.7365187-07:00</UpdatedDateTime>
</QueryElementFilter>

No entries in change log for this operation.