Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Using SQL to create a VAR - How to get the physical name ?

More
19 Aug 2019 16:44 #1 by Virginie_Samson
Using SQL to create a VAR - How to get the physical name ? was created by Virginie_Samson
Hello
I tried different syntaxes to variabalise the catalogue name on a SQL Query.

stambia.org/doc/87-development-hints-and...able-s-refresh-query
In this example, i don't understand what Ref mean ? Where does it comes from ?
select CASE WHEN CURRENT_DATE NOT IN
(select DATE_AFFRAN from
{Ref:schema()/tech:physicalName()}..EDIT_SYDES_STATISTIQUES )
THEN TRUE ELSE FALSE END

I also tried the metho we use in a Process:
select CASE WHEN CURRENT_DATE NOT IN
(select DATE_AFFRAN from
%x{$EDIT_SYDES_STATISTIQUES/tech:physicalPath()}x% )
THEN TRUE ELSE FALSE END

Both case are used in a Variable, type Boolean, and RefreshValue, call in a Process with a Variable Manager.
Thanks for your help

Virginie
More
28 Aug 2019 11:03 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Using SQL to create a VAR - How to get the physical name ?
Important : ref:schema() should be in lowercase, because Xpath is case sensitive.
So Ref:schema() will not work ;)

"ref" is just a prefix, indicating that the schema() function will return a reference (a pointer) to the object.
In this case, it will be a Reference to the schema specified in the Refresh Connection of the Variable metadata.