You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In every stage of a Select Dynamic Cascade, just one single value from previous field in the cascade can be used for the query ([parent]), while the query sometimes needs also previous parents.
Example:
select a type of product from a product_types table
select a brand that sells the type of products selected in stage1 (parent = type of product) from a product_brands table where each row is a brand and holds an array with types of products made by that brand
select a product of the brand selected in stage 2 (parent = brand) AND of the type of products selected in stage 1 from a product tables with columns {id, name, product_type, brand}. PROBLEM: selected product type from step 1 is not accessible in the query since it is two steps before.
Proposal: transform [parent] from a single value to an array and in each step of the cascade current field adds its parent to the array. In this way in any step/field of the cascade it is possible to access selected choice in every other step.
The text was updated successfully, but these errors were encountered:
In every stage of a Select Dynamic Cascade, just one single value from previous field in the cascade can be used for the query ([parent]), while the query sometimes needs also previous parents.
Example:
Proposal: transform [parent] from a single value to an array and in each step of the cascade current field adds its parent to the array. In this way in any step/field of the cascade it is possible to access selected choice in every other step.
The text was updated successfully, but these errors were encountered: