Contents tagged with PXProjection
Imagine that you need to have implementation of several tables with possibility to update them all.
Also you want to implement by the Acumatica side rather than by the database.
You know that Joined tables in Acumatica are read-only and you cannot update fields there
Can we create/use SQL-like views in Acumatica?
How can I join grouped (statistical) view to the DAC?
So, yes we can do it. For this purpose Acumatica gives you PXprojection attribute.
PXProjection attribute binds the DAC to an arbitrary data set. The attribute thus defines a named view, but is implemented by the server side rather than by the database.
Think whats tables you … more