Status: March 2019 ©2019 Ploetz + Zeller GmbH

Symbio API Filter

Filters can be part of the Uri and cause the server to return a filtered amount of data. For example, you can query all elements with a specific name specified in the filter.

Syntax

The filters are part of the Uri.

https://Server/Collection/Database/_api/rest/facets/processes/views/tree/elements/Origin Key of Category?$filter=name Equal 'mainProcess'

Arten von Filtern/ Operatoren

Binary Operators

Name Syntax Type Description Example
Equal Equal string The Boolean equality operator. ?$filter=name Equal string
Like Like string Determines whether a specific character string matches a specified pattern or not. ?$filter=name Like '%string' or 'string%' or '%string%'

Function Operators

Name Syntax Type Description Example
Contains Contains(string to be searched, substring to search) string Determines if one string occurs within another string. ?$filter=contains(attributes, 'test')
EndsWith EndsWith(string to be searched, substring to search at the end of the first string) string Determines if the end of one string matches another string. ?$filter=EndsWith(attributes, 'test')
StartsWith StartsWith(string to be searched, substring to search at the beginning of the first string) string Determines if the beginning of one string matches another string. ?$filter=StartsWith(attributes, 'test')
IsNull IsNull(key to check for null) string Compares the first operand with the null value. Compares if value null, empty or whitespace. ?$filter=IsNull(attributes)

Operator Error

If you use an invalid filter operant, you get either a code 404 for an invalid uri or a hint that this operator is not implemented.

{
    "data": [
        {
            "error": "The operator Custom is currently not supported"
        }
    ],
    "message": "An error occurred.",
    "output": "Volatile",
    "type": "Error"
}

Queries

It is possible to create a query in which filters are used in combination. An example in which the value'mainprocess' in the name attribute is filtered and the value in the sate1 attribute does not correspond to'in progress'.

Name Syntax Type Description Example
And AND string Groups operands with logical AND ?$filter=name Equal string AND state1 Equal string
Or OR string Groups operands with logical OR. ?$filter=name Equal string OR state1 Equal string

Query example

https://Server/Collection/Database/_api/rest/facets/processes/views/tree/elements/Origin Key of Category?$filter=name Equal 'mainProcess' AND state1 Equal 'in progress'

Other combinations are also possible.

FAQ's

More information about the correct construction of the uri's can be found here: API References

Impressum

publisher

Ploetz + Zeller GmbH

Einsteinring 41-43

85609 München

Tel.: +49 89 890635 – 0

Fax: +49 89 890635 – 55

E-Mail: info@p-und-z.de

| IMPRESSUM | |---| | Ploetz + Zeller GmbH accepts no liability for the correctness and completeness of the presentation/image in the document. The described and possible functionalities of the software refer to the respective version status. Customer-specific adaptations are not included. The information in this document is subject to change at any time. Ploetz + Zeller GmbH is not obliged to inform about the updates of the document.

This documentation as well as all contributions, representations and illustrations contained therein are protected by copyright. Any use not expressly permitted by copyright law requires the prior consent of Ploetz + Zeller GmbH. This applies in particular to reproductions, adaptations, translations, microfilming as well as storage and processing in electronic systems.

Ploetz + Zeller GmbH regards the information, knowledge and illustrations contained in this documentation as its sole property. The documentation or the information, knowledge and illustrations contained therein may not be made available, published or otherwise disseminated to third parties, either in whole or in part, directly or indirectly, without the prior written consent of Ploetz + Zeller GmbH. Ploetz + Zeller GmbH reserves the right to assert all relevant rights, in particular in the event of patents being granted. The handing over of the documentation does not create any claim to a license or use.

Subject to technical modifications. Product names used are trademarks or registered trademarks of their respective owners.

Symbio® is a registered trademark of PLOETZ + ZELLER GmbH, Munich. |

| Ploetz + Zeller GmbH

Einsteinring 41-43

85609 München | | Phone: +49 89 890635 – 0

Fax: +49 89 890635 – 55

E-Mail: info@p-und-z.de

©2018 Ploetz + Zeller GmbH |