Question: Nested query builders

[sowka1995]

Is it possible to create nested query builders?

I mean situations where we have level 1 fields, but when we select an XYZ field, it has subfields below it.

Example User has the following fields: Id, Name, Email, CreatedBy. If we select CreatedBy, I would like to load the fields available for CreatedBy and display a query builder nested with the fields available for CreatedBy (which is, for example, the User entity).

Maybe something like this can be achieved without nested builders? I tried to create a builder with an empty array of fields and CustomFieldSelector, which has the entire field selection logic, and after selecting it, I tried to dynamically add definitions of such a field to the fields queryBuilder, but unfortunately it doesn't work.

[jakeboone02]

Take a look at these (if you haven't already) and let me know if you have any more thoughts. Keep in mind that a query builder is really just a standalone rule group, so in a sense, each subgroup of a query is itself a "nested" query builder. I think the sandbox demonstrates that concept fairly well.

• Investigate use cases for nested query builders #515
• Support cross-builder drag and drop #707
• CodeSandbox example discussed in 707

[sowka1995]

The example from discussion 707 is quite nice, but how to add a group with dynamic fields?

What I mean is how to add a different set of fields for "metric" (I want to retrieve them and create them dynamically)

[sowka1995]

I think that all I need is to dynamically update the main query builder fields property.
I have a Custom FieldSelector, which is an advanced column selector, and before selecting the values ​​I would like to somehow dynamically insert the field definitions into the query builder.

[jakeboone02]

I'm not sure exactly what you mean by "dynamically insert the field definitions". The fields prop doesn't have to be static, so you can manage it outside the component and just send a different version in when it changes. Maybe I misunderstood.

[sowka1995]

I'm trying to do something like this.
Fields is empty by default. My custom field selector uses an API to retrieve dynamically available fields of various levels. Before calling handleOnChange, I add a new field definition so that QueryBuilder knows such a field and I tried to bypass it with setTimeout, but it doesn't work. It only works after the second click, as if the handleOnChange method was old and remembered the old "fields" state even despite setTImeout

[jakeboone02]

I think this feature, released in v8.8.0, might be what you're looking for: https://react-querybuilder.js.org/docs/tips/subqueries