acumatica
Modifiche API significative tra le versioni
Ricerca…
PXSelectGroupBy e Bit Values in Acumatica 5.1 e 5.2+
Il metodo di generazione SQL da BQL PXSelectGroupBy<>
visualizzazioni dati è stato modificato in Acumatica Framework 5.2.
Le sezioni seguenti illustrano le differenze utilizzando l'esempio di PXSelectGroupBy<FinYear, Aggregate<GroupBy<FinYear.finPeriods>>>.Select(graph)
:
Acumatica Framework 5.2 e successive
SELECT Max([finyear].[year]),
Max([finyear].[startdate]),
Max([finyear].[enddate]),
[finyear].[finperiods],
-- Attention!
CONVERT (BIT, Max([finyear].[customperiods] + 0)),
--
Max([finyear].[begfinyearhist]),
Max([finyear].[periodsstartdatehist]),
Max([finyear].[noteid]),
( NULL ),
( NULL ),
( NULL ),
Max([finyear].[tstamp]),
Max([finyear].[createdbyid]),
Max([finyear].[createdbyscreenid]),
Max([finyear].[createddatetime]),
Max([finyear].[lastmodifiedbyid]),
Max([finyear].[lastmodifiedbyscreenid]),
Max([finyear].[lastmodifieddatetime])
FROM finyear FinYear
WHERE ( finyear.companyid = 2 )
GROUP BY [finyear].[finperiods]
ORDER BY Max([finyear].[year])
Acumatica Framework 5.1 e precedenti
SELECT Max([finyear].[year]),
Max([finyear].[startdate]),
Max([finyear].[enddate]),
[finyear].[finperiods],
-- Attention!
( NULL ),
--
Max([finyear].[begfinyearhist]),
Max([finyear].[periodsstartdatehist]),
( NULL ),
( NULL ),
( NULL ),
Max([finyear].[tstamp]),
( NULL ),
Max([finyear].[createdbyscreenid]),
Max([finyear].[createddatetime]),
( NULL ),
Max([finyear].[lastmodifiedbyscreenid]),
Max([finyear].[lastmodifieddatetime])
FROM finyear FinYear
WHERE ( finyear.companyid = 2 )
GROUP BY [finyear].[finperiods]
ORDER BY Max([finyear].[year])
Spiegazione
Per impostazione predefinita, l'aggregazione Max()
viene applicata a tutti i campi non esplicitamente menzionati in un'istruzione BQL.
Tuttavia, in Acumatica 5.1 e precedenti, esclude i CreatedByID
, LastModifiedByID
e bool
. Se convertiti in SQL, questi campi saranno sempre null
meno che non vengano raggruppati in modo esplicito.
A partire dalla versione 5.2, anche Max()
verrà applicato per impostazione predefinita.
Modified text is an extract of the original Stack Overflow Documentation
Autorizzato sotto CC BY-SA 3.0
Non affiliato con Stack Overflow