jsnider

Accessing element attribute Array values for input into Lookup Table

Discussion created by jsnider on Aug 22, 2013
Latest reply on Apr 2, 2015 by Roger Palmen

Not sure if this is in the right place, but Here is what I have and I am trying to do:

 

I have an element attribute [DNAconnections] that is a string array value type, and the string values are the result of a table lookup data reference.

 

The resulting values look like this:

 

CONNECTION_1

 

CONNECTION_2

 

 

 

I have another element attribute [1stConnection] that also has a table look up data reference. I'd like to use one of the values from the array above in my where clause for this look up..

 

Something like: "select name from table where name = @DNAconnections", but this returns nothing.

 

Is there a way to index into the array to get a specific value? something like @DNAconnections[0], or @DNAconnections[1], or something like that... ??

 

 

Outcomes