

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