Search in a dynamic table by column value

Use case:

I need to search for data in a dynamic table based on a value in a column.

An example is demonstrated on:

  • Template: Order issued
  • Dynamic table: 001-suppliers
  • Variable of type text (with prompt): supplier (CZ: Dodavatel)

We are searching for the entire row in the dynamic table 001-suppliers where the value in column 8 is equal to the selected text variable Supplier .

The dynamic table 001-suppliers looks like this:

  1. First, the entire table row is searched, which is returned as an array of objects:
const supplierDtRow = dt.from('001-suppliers').whereCol('8', vars['supplier'].getValue(), '=').get();

The calculation returns the following array of objects to supplierDtRow :

[{"DTV_INDEX":"109","DTV_ORDER_INDEX":1,"COL_1":"Neit Consulting sro","COL_2":"CZ27369871","COL_3":"27369871","COL_4":"Washingtonova 2","COL_5":"Praha","COL_6":null,"COL_7":"CZ","COL_8":"Neit Consulting sro|27369871","COL_9":"neit@emailaddress.com","DLV_INDEX":"109"}]

  1. Subsequently, any value can be obtained from the object using the following notation:
let companyCity = supplierDtRow[0]['COL_5']; //Praha
let companyStreet = supplierDtRow[0]['COL_4']; // Washingtonova
atd.

Frantisek Brych Updated by Frantisek Brych

Filtering in a dynamic sheet using a URL parameter (static)

Filtering in a dynamic sheet using dynamic conditions

Contact

Syca (opens in a new tab)

Powered by HelpDocs (opens in a new tab)