Using personal, fixed #Branch# Keyword for SQL Queries

[amacara1]

Hi!

But what if GUID is a field already returned during SQL query - then, how could I use #Branch=#?

For example, this does not work (assuming Keywords field of 'SpecialName' element holds a GUID):
select Obj.Name from (t_object Obj inner join t_object MetaElem on MetaElem.Name = 'SpecialName')
where Obj.Package_ID in (#Branch=MetaElem.Keywords#)

If I write the GUID directly in #Branch=#, it works fine.

[Geert Bellekens]

The reason it doesn't work is because of the order of evaluation.

What happens if you let EA execute such an SQL query, is that it first evaluates all macros such as #Branch# and only after replacing the macro's it will execute the query.

MetaElem.Keywords is is not known before executing the query. It is taken as a literal text.

Geert

[amacara1]

That makes perfect sense! Thank you.