Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Plain Functions in Where
 
Plain Functions in Where
Plain functions can be used in any RAQL query clause. You may use any MashZone NextGen built-in plain function (see Built-In RAQL Functions for a list) or user-defined plain functions that you or other MashZone NextGen developers have added.
You can find a simple example of using plain functions in a Where clause in Use Plain Functions to Update, Select or Sort Rows. See also Comparing Dates or Numbers for an example of using casting functions in Where clauses.
This example query uses nested functions to select manufacturing plants that are in the southern hemisphere, by comparing the latitude in the data:

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release