QueryElements Test
Reporting/QueryElements?groupIds={groupIds}&activeOnly={activeOnly}
Get a list of query elements optionally filtered by one or more GroupIds or if they're active only.
Http Verb GET
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/Reporting/QueryElements?groupIds={groupIds}&activeOnly={activeOnly}

URI Parameters

Parameter Name Data Type Required Notes
groupIds string N
activeOnly string N

Request Body

None.
No request body.

Response object type : Collection of QueryElement

Response object type Collection of QueryElement has the following properties.
Property Name Data Type Length Required Readonly Notes
ControlGroup ControlGroup N
FK: TR_CONTROL_GROUP.id   Resource: ControlGroups
CreatedBy string N
CreatedDateTime date N
CreateLocation string N
DataSelect string N
Description string N
Group QueryElementGroupSummary N
FK: TR_QUERY_ELEMENT_GROUP.id   Resource: QueryElementGroups
Id integer N
Inactive boolean N
IsSingleRow boolean N
KeywordId integer N
PrimaryGroupDefault boolean N
UpdatedBy string N
UpdatedDateTime date N 
[
  {
    "Group": {
      "Id": 1,
      "Description": "sample string 1",
      "Category": 2,
      "IsVirtual": true,
      "NumberOfParameters": 4
    },
    "CreatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
    "CreateLocation": "sample string 1",
    "CreatedBy": "sample string 2",
    "DataSelect": "sample string 3",
    "KeywordId": 1,
    "Description": "sample string 4",
    "Id": 1,
    "Inactive": true,
    "UpdatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
    "UpdatedBy": "sample string 6",
    "PrimaryGroupDefault": true,
    "IsSingleRow": true,
    "ControlGroup": {
      "CreatedBy": "sample string 1",
      "CreatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
      "Description": "sample string 2",
      "Id": 1,
      "Inactive": true,
      "Permission": 0,
      "UpdatedBy": "sample string 3",
      "UpdatedDateTime": "2025-04-24T09:17:36.2936683-07:00"
    }
  },
  {
    "Group": {
      "Id": 1,
      "Description": "sample string 1",
      "Category": 2,
      "IsVirtual": true,
      "NumberOfParameters": 4
    },
    "CreatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
    "CreateLocation": "sample string 1",
    "CreatedBy": "sample string 2",
    "DataSelect": "sample string 3",
    "KeywordId": 1,
    "Description": "sample string 4",
    "Id": 1,
    "Inactive": true,
    "UpdatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
    "UpdatedBy": "sample string 6",
    "PrimaryGroupDefault": true,
    "IsSingleRow": true,
    "ControlGroup": {
      "CreatedBy": "sample string 1",
      "CreatedDateTime": "2025-04-24T09:17:36.2936683-07:00",
      "Description": "sample string 2",
      "Id": 1,
      "Inactive": true,
      "Permission": 0,
      "UpdatedBy": "sample string 3",
      "UpdatedDateTime": "2025-04-24T09:17:36.2936683-07:00"
    }
  }
]
<QueryElements xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <QueryElement>
    <ControlGroup>
      <CreatedBy>sample string 1</CreatedBy>
      <CreatedDateTime>2025-04-24T09:17:36.2936683-07:00</CreatedDateTime>
      <Description>sample string 2</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <Permission>Read</Permission>
      <UpdatedBy>sample string 3</UpdatedBy>
      <UpdatedDateTime>2025-04-24T09:17:36.2936683-07:00</UpdatedDateTime>
    </ControlGroup>
    <CreateLocation>sample string 1</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T09:17:36.2936683-07:00</CreatedDateTime>
    <DataSelect>sample string 3</DataSelect>
    <Description>sample string 4</Description>
    <Group>
      <Category>2</Category>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <IsVirtual>true</IsVirtual>
      <NumberOfParameters>4</NumberOfParameters>
    </Group>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsSingleRow>true</IsSingleRow>
    <KeywordId>1</KeywordId>
    <PrimaryGroupDefault>true</PrimaryGroupDefault>
    <UpdatedBy>sample string 6</UpdatedBy>
    <UpdatedDateTime>2025-04-24T09:17:36.2936683-07:00</UpdatedDateTime>
  </QueryElement>
  <QueryElement>
    <ControlGroup>
      <CreatedBy>sample string 1</CreatedBy>
      <CreatedDateTime>2025-04-24T09:17:36.2936683-07:00</CreatedDateTime>
      <Description>sample string 2</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <Permission>Read</Permission>
      <UpdatedBy>sample string 3</UpdatedBy>
      <UpdatedDateTime>2025-04-24T09:17:36.2936683-07:00</UpdatedDateTime>
    </ControlGroup>
    <CreateLocation>sample string 1</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T09:17:36.2936683-07:00</CreatedDateTime>
    <DataSelect>sample string 3</DataSelect>
    <Description>sample string 4</Description>
    <Group>
      <Category>2</Category>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <IsVirtual>true</IsVirtual>
      <NumberOfParameters>4</NumberOfParameters>
    </Group>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsSingleRow>true</IsSingleRow>
    <KeywordId>1</KeywordId>
    <PrimaryGroupDefault>true</PrimaryGroupDefault>
    <UpdatedBy>sample string 6</UpdatedBy>
    <UpdatedDateTime>2025-04-24T09:17:36.2936683-07:00</UpdatedDateTime>
  </QueryElement>
</QueryElements>
Change Version Description Contract Old New
Parameter Added 15.0.0 New parameter added activeOnly activeOnly