In a QueryView, you can link another QueryView which will create dropdowns on the rows of your QueryViews to display additional details. When expanded, the selected child QueryViews runs. The Child QueryView inputs can reference either values from the row or the inputs of the parent QueryView.
The setting 'Allow Multiple Child Row Expansions at Once' allows the child QueryView to be shown on multiple rows at the same time. If this setting is unselected, then if the expand button for a child QueryView is clicked on a row, the open row will collapse, and the new row will expand.
Add a Child QueryView
To add a child QueryView, click the
Children icon in the Edit View, then click
Add New. Select the QueryView you want to be the child, then click
Select Resource at the bottom of the modal. When Executing the parent QueryView, there will now be a plus button on each row. Clicking it will show the child QueryView.
Using Parent Values
Values from the Parent QueryView can be used as inputs in the child QueryView. This can be used so the QueryView access information from another table using a value/id from the Parent QueryView.
First, set the
Parent Override in the child QueryView Inputs.
- Only override with parent data row values: If a column in the parent QueryView matches the
Display Nameof this input, the input value will be the value of the parent column in that row
- Allow parent input values to override: If the parent and child QueryViews both have inputs with the same
Display Name, then the child QueryView input value will be the input of the parent QueryView. However, a column name in the parent QueryView takes priority over an input Display Name if they are the same.