Hello Haulmont,
I’ve got a composition table that needs a custom query, and it doesn’t seem possible to create a data loader for a composition table. It needs to pull the last n records that have been marked as completed, as well as all future records in order. I have accomplished this in a sense, by setting a container subscription, which then queries the database for the results in two data sets and combines them. The obvious problem with this is that upon making a change in the composition table, it hasn’t yet been committed to the database, which means that the query is useless except for the initial edit screen load.
What I’m looking for is the composition table will react to the query specifics, but not need to query the database for the information. It hasn’t been committed to the database. How do I interact with the uncommitted changes, but still extract the records?
Let me know if you need anything more specific. Thanks!
Adam