Union query in Fibery

[Chr1sG]

Based on what you have said, I think the need for a union query comes from here:

@DiegoKamp

A solution is to bring the books and sites to the level of knowledge space, so we will have in addition to the databases already mentioned:
[computer science books]
in the {computer science} space
[law books]
in {law} space
etc.
That’s fine too, but I need to be able to create the [books] table and the [sites] table, with a union query.

It strikes me that having a unique book database for each subject is not the optimal solution, and the need for the union query is a workaround for the inability to solve the real issue.

I think the real problem that needs solving is

@DiegoKamp

by inserting a reference to a book, the list box shows all those present in the books table, the entire library (the books are thousands). There is no way to filter the records

You want to be able to select a book (from amongst thousands) based on the the context of the entity you are picking from, right?

This would seem to be related to this:

Dependent Dropdown Field Type

Hi Guys, Sorry if this is a detailed request, but I’ve seen a lot of times I could use a “Dependent Dropdown” capability with fields in Entities. What I mean is if I have one dropdown that I’m using, the options would lead to a 2nd related dropdown that would have dependent results based on the choice of the first: Let’s say we want to categorize a “Recipe” Entity type: First Dropdown: “Food” Choices: Meat Vegetable Fruit Values in 2nd Dropdown: Beef Pork Spinach Lettuce Broccoli Appl…

It is partly solved, by hierarchical relations, but this doesn’t work in your case, because that functionality is not supported for many-to-many relations.

At this point, I wonder if anyone in the community has any suggestions for how to help you (either with a better tool suggestion, or with a better Fibery data model).