My main table uses filtering by 12 fields. Filters for 9 fields work via select. All 9 selectors as a data source have the same table, but with different settings. At the moment I have to create 9 different requests to the server to provide each select with its own data. But it would be much more convenient and less resource-intensive for the system if you could use only one request to the server, and filter the data for each select. Is there a way to achieve this?
I will explain, for clarity. The request to the database is connected using the server connect on the client side. Filters are installed inside the server connection. Therefore, for several selec (in which different information is needed), you have to create several server connections. I’m looking for a way to use one server connection and configure its filtering inside each select.
Thanks in advance!