Array Partial Text Search

Support, Troubleshooting, & Help
1

Hello,

We have an ERP system where we maintain our BOM structure for our products. We have a connector that will query and pull the BOM structure for the product based off a work order number. The result of that query is an Array with a component list (example photo below)

image
image430×342 12.3 KB

I have a use case where I want to pull a specific part out of this array by finding which index they component is at. This component is a wire diagram. Because we have multiple part numbers, and the wire diagram is not always structured in the same index location, I am trying to perform a map_to_text_list and search via the Item description.

image
image996×151 13.6 KB

All my wire diagrams start with the words “WIRE DIA” so I want to use that as my search criteria. It appears that when using this criteria, the match of the text has to be exact. The item descriptions have more text beyond the “WIRE DIA” so that is where I am getting stuck.

Is there a way to search a partial text string within the Map_to_text_list function? Or another way around this issue?

Thank You,

2

Hi there,

MAP_TO_TEXT_LIST requires exact matches, it can’t do partial text searches like “starts with WIRE DIA”.

Here are two simple solutions:

  1. Use an Interactive Table - Display your components array in an interactive table widget. The table’s built-in filter can handle partial text matches on the Item Description column.
  2. Modify your connector - Update your ERP query to only return wire diagram components (where description starts with “WIRE DIA”) instead of the full BOM.

The interactive table approach is probably easiest since you don’t need to change your connector.

Let me know if that clears it up.

3

Hi Nicolo,

The interactive table did exactly what I needed! It was so simple I can’t believe I did not think of it before.

Thanks for the help!!

4

Hi Nicolo,

One follow up question. Can I take that filter result in the interactive table and store it into a new variable automatically? Example: the component item (photo below) associated with that array value?

image

5

Yes, you can do this with the Interactive Table’s “On Row Selection” trigger.

Here’s how:

  1. Select your Interactive Table widget
  2. Scroll down to find the “On Row Selection” trigger
  3. Add a “Store Variable” action to capture the selected record
  4. The variable updates automatically when users click any row

This works with filtered data too, so you’ll capture exactly what the user selected from your wire diagram components.