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 | Mashables and Mashups | Mashables | Types of Mashable Information Sources | Database Mashables | Arbitrary SQL Queries for Database Mashables | Custom Queries
 
Custom Queries
You can also define custom finders for specific queries when you register database mashables. Custom finders:
*Accept a parameter with the SQL code for a WHERE clause. This can include one or more dynamic parameters which you define and map to mashable column names.
For example: "DEPT_NO = :deptNo AND HIRED_DATE < :hiredDate"
*Dynamic parameters for the WHERE clause must be simple types with corresponding Java and JDBC types.
*Use prepared statements and thus have no risk of SQL injection attacks.
*Return all columns defined for the mashable.
*Can sort results by one or more columns that you specify.

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