Hope you're fine!
So here is a stupid question (but questions never are stupids, only some answers may be... :-))
In a PI-AF Hierarchy, I've to reach a value for sub attributes in a SQL query. When I need to recover values from parents and grand parents it's ok using the famous ..\..\ syntax!
But here the question is : how to access a sub-attribute located at same level?
Let me describe it:
I've an attribute called A with a sub attribute called S_A, and I've another attribute called B (at same level than A) with a sub attribute called S_B.
S_B value is a TableLookup with a SQL Clause where I need to use the S_A value as a trigger.
So I've tried things like:
SELECT Column FROM Table WHERE MyColumn=@[.\A|S_A]
SELECT Column FROM Table WHERE MyColumn=@[..\A|S_A]
SELECT Column FROM Table WHERE MyColumn=@[..\|A|S_A]
SELECT Column FROM Table WHERE MyColumn=@[..|A|S_A]
Of course none of this one is OK, so any help to achieve this please? (Latest version of PI-AF 2017)
Just to add something, if I go to an other branch hierarchy, I can access the values using the MyColumn=@[.\|D]
Knowing D is an attribute with the same level than the parent of A and B...
And optionnally, because I was thinking that SQL commands were misinterpreting dots, may I use a dot as an attribute separator (meaning S.A instead of S_A)
Thanks a lot in advance!
Ok sorry guys, this one is for me ... in fact the solution is that you have to navigate to the root of your local hierarchy and then go down to the branch you need to access...
So the solution was MyColumn=@[.\|AParent|A|S_A]
Sorry for the disturbance, may I need some holidays ...