Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Scout/Concepts/Sql Lookup Service
The Scout documentation has been moved to https://eclipsescout.github.io/.
A SQL lookup Service is a specific type of The Scout documentation has been moved to https://eclipsescout.github.io/. that works with a database.
- implements: The Scout documentation has been moved to https://eclipsescout.github.io/.
- extends: The Scout documentation has been moved to https://eclipsescout.github.io/.
Contents
Description
A SQL lookup Service provide a way to implement a The Scout documentation has been moved to https://eclipsescout.github.io/. that is very efficient to configured, if the The Scout documentation has been moved to https://eclipsescout.github.io/. is resolved with a database.
Instead of implementing the 4 methods (getDataByKey(LookupCall call)
, getDataByText(LookupCall call)
, getDataByAll(LookupCall call)
, getDataByRec(LookupCall call)
), it is possible to defined the behavior of the lookup service with some configuration properties and events.
Properties
Defined with The Scout documentation has been moved to https://eclipsescout.github.io/. methods.
The Scout documentation has been moved to https://eclipsescout.github.io/.
It is possible to add some special tags, that define SQL code that is kept, depending on the getDataBy***(LookupCall call)
method called on the Lookup Service:
-
<key>
and</key>
-
<text>
and</text>
-
<all>
and</all>
-
<rec>
and</rec>
The call
is attached to the SQL query as binding. Therefore all getters on the call, are available in the query. (:key
for call.getKey()
, :text
for call.getText()
, :master
for call.getMaster()
...)
Here an example of a such SQL query:
SELECT language_id, name, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1 FROM LANGUAGE <key>WHERE language_id = :key</key> <text>WHERE UPPER(name) LIKE UPPER('%'||:text||'%')</text>
The Scout documentation has been moved to https://eclipsescout.github.io/.
Events
Defined with The Scout documentation has been moved to https://eclipsescout.github.io/. methods.
The Scout documentation has been moved to https://eclipsescout.github.io/.
See Also
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.