appreciate if anyone can help me with this.
I have a user table (say "UT"). I have additional fields in it too.
In any case I need to refer to one of the columns using the $ notation we can use on other grids such as Invoice line.
eg: $[$3.2.0] will get me the value on the column number 2, and $3 being the item id of the matrix.
However the columns on the user table don't have a number, they have a string id. I tried using
$[$3.ColumnName.0] but does not work. Even $[$3.2.0] did not give me column 2 value.
THIS SQL HERE FAILED.
SELECT 'a' WHERE $[$3.2.0] = 1027
could I be doing something wrong here ???