Query to generate a subset, varNameXX, of the XML file.
Please consider adding a method to get a subset, varNameXX, of the XML file to reduce database queries.
We have reviewed this idea internally, but declined it for current development. The ForEach tag which loops over multiple rows returned by a data connection will serve with visiting each row in the result set. Some use cases that have come up with storing this data in a query tag is to improve performance by reducing calls to the database. For this case we have determined that the increase in performance will not be sufficient for the effort, and our recommendation is to re-query the data. Please share if you do have a different use case we are overlooking and we can consider this, otherwise this ticket will be closed. Thank you for your suggestion, and please submit any other ideas you have to improve our products.
Received a request from Ed Barlow asking to clarify his request.
Ed would like added the ability for the Query Tag to hold multiple rows, “subset”, of the XML instead of just one row/node.