Dynamically populate data on rendered dropdown view in perspective table column

Hello,

I am trying to bind named query to a dropdown options props which is rendered in a table column.
I have used this dropdown view in many columns so I want to achieve dynamic options to it based on the rowData conditions. When I use expression binding to the view params (manually created for testing) it takes only values from first row of table data.

I am thinking of another way that is to dynamically binding multiple named queries to dropdown view itself based on column rendered but it doesn't look great way to me.

My question is how to get rowData values for a particular row in column's rendered view params.
or
Any other better way how can I achieve this?

Dropdown view params

View rendered in column

Expression binding on view params

Named query binding to Options params

I'm lost. Can you post a screenshot or mockup of what you're trying to do?

I have rendered the same view in multiple columns as shown in screenshot. I want to have dynamic options to dropdown based on previous dropdown value selected of same row.
Note: When any value is selected from dropdown it is getting stored in database also.

For example:
When F1 is selected from FACTORY column dropdown, then corresponding STATION values (S1,S2,S3) should populate on STATION column dropdown options

I am thinking of another way that is to dynamically binding multiple named queries to dropdown view itself based on column rendered but it doesn't look great way to me.

It might be the simplest way, but maybe not very efficient for a long table:

  • Create four named queries:
    • qryFactory (Parameters: none). This generates the options for FACTORY dropdown.
    • qryStation (Parameters: Factory) This generates all the options for the STATION dropdown.
    • qryZone (Parameters: Factory, Station) This generates all the options for the ZONE dropdown.
    • qryPY (Parameters: Factory, Station, Zone) This generates all the options for the PY1/PY dropdown.
  • Pass the query name as a parameter to the subview.
1 Like

Yeah. For now I can see this only option.
Anyway. Thank you :slight_smile: