I am wanting to pull a specific text from an array that was created from an connector

Developer
, ,
1

image
image1124Ă—596 33.3 KB

I am wanting to pull VZL2172-0001_X from this array. Eventually for all the components for this build. I would like to be like pull MAT_SEQ 1 which would give me VZL2127-0001_X. Then continue for 2,3,4,5,6.

Any suggestions or tips would help.

Thanks.

2

There may be a newer/better way to do this but in LTS 8.2 I am doing the following to pull from an object list:

image
image432Ă—223 4.14 KB

image
image912Ă—131 4.41 KB

which gives me that object list “serialNumber” column in array form.
NOTE: I think this is case sensitive - for some reason the object list displays in all caps but the expression only works with little s, big N…and I’m sorry but I don’t recall how I figured that out.

From there you can use something like this to call up the row from the object list and save it as an object:

image
image964Ă—199 6.46 KB

And you can display that row or call upon its individual fields as variables however you like…

image
image488Ă—483 14.9 KB

Hope this helps!

1 Like
3

Thanks Jim for the great help here! Would say your approach here is a good one and solid. Another option, depending on the use case (ex. if you are using the full BOM or just that one item) you could do the filtering within the connector itself as well.