Modeler: 8/RepositorySql

SQL Repository

This window enables you to write advanced queries on the repository using sql. It uses the SQLite syntax. You may read about it at [1].

The SQL is extended with two more functions:

• md5(value)
• macro(value)

md5

The md5 function generates a hash from the value passed as text.

 select 
 md5(otftname) as OTFT_HASH, OTFTName
 from otft;

macro

The macro function supports keywords also defined in the custom attribute keywords. An example query could be:

 select 
 macro("%PROJECTNAME%\%IGNAME%\v%IGVERSION%\"||otftname) as FULL_OTFT 
 from otft;