Skip to main content

Named queries

You can add peprared statements configurations and make paramterized class to them

  • lookupNamedQuery(query,value)

The query must be stored under the name: "NamedQueryLookup" + query

The value will be inserted into the ? parameter an escaped properly

 SELECT CVR FROM data_company WHERE NAME = ?

If call is made from an entity the Query will be stored in either

  • Entity configuration
  • System configuration

Example

In the following example we want to look up a phone number from an email value in the entity 'company'.

Client code

Somewhere in a Javascript the following code is found

var email = getValue("EMAIL");
setValue("PHONE",
    lookupNamedQuery("FindPhoneFromEmail", email)
);

Server code

In the configuration NamedQueryLookup.FindPhoneFromEmail the following SQL is stored

SELECT COMPANYPHONE FROM data_company WHERE COMPANYEMAIL = ?
Back to top