cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

ERQL - String functions?

Highlighted
Contributor

ERQL - String functions?

Is there a possibility to use standard SQL-like string functions in ERQL-queries? For instance

SELECT [Application] WHERE [Name] LIKE CONCAT(&Prefix, "#", &Suffix)

 

(I have tried all standard functions known to me for this: CONCAT(), +, ||. Each work on different SQL database servers but every server provides at least one such operator.

1 Reply
MEGA

Re: ERQL - String functions?

Hello alros

 

ERQL language is not SQL language

The words 'CONCAT', '+', '||' cannot be used in the code of an ERQL query.

 

ERQL query syntax is the same for MEGA 2009 SP5/HOPEX V1R1/HOPEX V1R2.

This article documents the query syntax (section query syntax):

http://community.mega.com/mega/attachments/mega/740/9/33/MEGA%20Publisher%20EN.pdf

 

Or course, if you are in a context (ex: macro, application) where you can use a language (ex: VB script), you can build the ERQL Select clause using the operators of this language

For example in VB script:

sSELECT = "SELECT" & "[Org-Unit]"

Set cOu = GetRoot.GetSelection(sSelect)

Jerome