The request for UNION was already raised in this idea https://experience.dynamics.com/ideas/idea/?ideaid=972a4dde-fc90-e911-80e7-0003ff68e84c, but was asking for much more and was rejected and this also the request for UNION.
Comments
a union is essential or at least an "or" option for filters.
Category: Development
Apparently this has been requested more than once, by people who know a) what they are doing, and b) why the lack of this feature in BC is a serious lacuna. For clarification, I am posting to this thread only because the error that I receive when trying to add multiple data items at the same level below a parent data item refers to "union":
You cannot combine two DataItems at the same level because unions are not supported.ALAL0342
I would add my voice to those suggesting that this is a very basic data manipulation in SQL, and would make possible quite easily many page-related and search-related activities that are currently impossible in BC. It does not seem like a major lift.
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team