Create Query

User Guide > Create Query

This request adds a query to the database.

Resource

POST /queries

Parameters

Common Create Parameters

Payload

QBQuery

Response

Object Response < QBQuery >

The created object.

Context

Authorization

Administrator

Errors

Common Errors

Example

Request
POST https://xelion.nl/api/v1/master/queries
Payload
{
    "objectType": "QBQuery",
    "commonName": "test3",
    "metaClassName": "XCCPhoneLine",
    "selectMembers": [
        {
            "objectType": "QBSelectMember",
            "defaultName": "test",
            "sequenceNumber": 1,
            "showColumn": true,
            "ascDesc": "ASCENDING",
            "sortOrder": 1,
            "memberPath": "commonName"
        }
    ],
    "filterGroups": [
        {
            "objectType": "QBFilterGroup",
            "groupName": "test",
            "sequenceNumber": 2,
            "isActive": true,
            "andOr": "or",
            "filterLines": [
                {
                    "objectType": "QBFilterLine",
                    "filterName": "nameOfTheFilter",
                    "sequenceNumber": 1,
                    "andOr": "or",
                    "memberPath": "commonName",
                    "comparisonOperator": "COP_CONTAINS",
                    "comparisonValue": "test",
                    "ignoreCase": true,
                    "localized": true,
                    "isActive": true
                }
            ]
        }
    ]
}
Response
{
    "object": {
        "metaClassName": "XCCPhoneLine",
        "selectMembers": [
            {
                "defaultName": "commonName",
                "sequenceNumber": 1,
                "showColumn": true,
                "ascDesc": "ASCENDING",
                "sortOrder": 1,
                "memberPath": "commonName",
                "oid": "2121676",
                "objectType": "QBSelectMember"
            }
        ],
        "filterGroups": [
            {
                "groupName": "test",
                "sequenceNumber": 2,
                "isActive": true,
                "andOr": "or",
                "filterLines": [
                    {
                        "filterName": "nameOfTheFilter",
                        "sequenceNumber": 1,
                        "andOr": "or",
                        "memberPath": "commonName",
                        "comparisonOperator": "COP_CONTAINS",
                        "comparisonValue": "test",
                        "ignoreCase": true,
                        "localized": true,
                        "isActive": true,
                        "oid": "2121678",
                        "objectType": "QBFilterLine"
                    }
                ],
                "oid": "2121677",
                "objectType": "QBFilterGroup"
            }
        ],
        "permissions": "ReadWriteRemove",
        "commonName": "test2",
        "oid": "2121674",
        "objectType": "QBQuery"
    },
    "links": [
        {
            "rel": "self",
            "method": "GET"
        }
    ]
}