First of all, thank you so much for all your comments those really helped me with this process.
Here’s an update about what I have.
I ended up using a named query for the table, I have a screen where I added a table on it displaying a named query, I used a dropdown list as well.
Here’s how looks my table on the named query.
SELECT Company_AL.area,
conveyor_info.date,
conveyor_info.fault_des,
Company_AL.Area,
conveyor_info.summary,
conveyor_info.cnvy_name
FROM Company_AL
INNER JOIN conveyor_info ON Company_AL.ID = Conveyor_info.ID
where area = :area;
on my main screen, I have the table plus the dropdown list with the area names, when I sort by area name I can see the conveyors affected on that area.
; therefore I added a label_1 that shows me the row selected " expression (try({Root Container.Table.data}[{Root Container.Table.selectedRow}, “cnvy_name”], 0) ".
The conveyor’s squares are templates where we have parameters one of the parameters is the conveyor name, we are doing this comparison to change the color to red.
Expression: IF({Root Container.Label 1.text} = {[AL]Conveyor 101/Parameters.Conveyor_name},“255,0,0”,“255,255,255,0”)
Obviously, this is only working when the row is selected and the name is the same as parameter conveyor_number, I’m still looking for a way to do this automatically by searching in the column cnvy_name and doing the functionality in the conveyor square.