Date: Fri, 29 Mar 2024 12:02:22 +0100 (CET) Message-ID: <1169476643.159.1711710142740@vmisdata19.uni-oldenburg.de> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_158_1371193049.1711710142740" ------=_Part_158_1371193049.1711710142740 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Odysseus provides a wide range of functions and operators to be used for= data transformation and filtering in your query statements. In Odysseus-St= udio there is a view MEP Functions View, that lists all current available o= perators and functions.
Attentation: For most numeric operators the result is a floating value. = This will be fixed in future versions.
Mathematical Operators; +,-,/,*, % (modulo), ^ (power)
Logical Operators: && (and), || (or), !(not), xor
Compare Operators: !=3D, =3D or =3D=3D, <=3D, >=3D
If you prefer CQL you can use these functions and operators in your Sele= ct clause for data transformation or in the Where clause for filtering:
SELECT t= an(x) FROM stream WHERE sqrt(y)>3
If you prefer PQL you can use these functions and operators in the MAP, = JOIN, and SELECT operator. In addition, functions and operators can be used= in other operators that are not part of the set of relational operators.= p>
output = =3D MAP({expressions =3D ['tan(x)']}, SELECT({predicate =3D RelationalPredi= cate('sqrt(y)>3')}, stream))
Some of the functions and operators are part of the Odysseus Core and so= me are available in additional features. On the following child pages you find all curre= ntly available functions and operators with their description and examples.=