Skip to main content
Solved

Creatign a GI with Union

  • October 6, 2025
  • 3 replies
  • 60 views
W
Jr Varsity II
Forum|alt.badge.img

Hello 


Is it possible to create a GI with a union on 2025 R2, given that it now permits the following.

 

Best answer by Tony Lanzer

Hi ​@wilson71. You can perform unions as of 24R2 using BQL and mapping.  Reference: Union in BQL. You can do this using Projections and include the unioned result in a GI.  You can also now reference a GI within another GI to handle subqueries as of 24R1. Reference: Full Release Notes.

3 replies

Tony Lanzer
Pro III
Forum|alt.badge.img+2
  • Tony Lanzer
  • Pro III
  • 123 replies
  • Answer
  • October 6, 2025

Hi ​@wilson71. You can perform unions as of 24R2 using BQL and mapping.  Reference: Union in BQL. You can do this using Projections and include the unioned result in a GI.  You can also now reference a GI within another GI to handle subqueries as of 24R1. Reference: Full Release Notes.

L
Semi-Pro II
Forum|alt.badge.img+1
  • larryly
  • Semi-Pro II
  • 95 replies
  • October 9, 2025

​@wilson71 I’m curious why your GI screen looks so different with mine. That’s awesome your can use query in GI. My system version is 2025 R1.

 

 

D
Captain II
Forum|alt.badge.img+7
  • Django
  • Captain II
  • 677 replies
  • October 9, 2025

​@larryly - Wilson’s screenshot is from 25R2.


Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved