2

Hi @andrew.prshkv !

If I understand your setup correctly, why not try making a second query to fetch the name_of_product for the selected id in Dropdown #1?
Here’s how the query would look:

SELECT name_of_product
FROM your_table
WHERE parent_id IN (:list_of_ids);

Example

If your list of parent_ids is [1, 2, 3], the query would become:

SELECT name_of_product
FROM your_table
WHERE parent_id IN (1, 2, 3);