Queries on Business Object Groups no longer works in B1365

[chris29]

Queries on Business Object Groups no longer works in build 1365 I have tested on build 1360 and it works with the same bsv and test data.

It appears that the SQL is malformed:

eg from Build 1365

SELECT Company.IsActive,Company.ExemptFromGst,Company.Reference,Company.Email,Company.Description,
Company.Mnemonic,Company.UpdatedOn,Company.BASVERSION,Company.CanDisclose,Company.RegisterStatusID_REN,
Company.RegisterStatusID_RID,Company.RegisterStatusID_RMA,Company.CreatedOn,Company.StatusSetOn,
Company.ExemptFromInterest,Company.BASTIMESTAMP,Company.ID,Company.Balance,'Company' AS BAS_ENTITY
FROM BASTESTDOMAINHZ_COMPANY AS Company
INNER JOIN BASTESTDOMAINHZ_REGISTERSTATUS AS Entry_RegisterStatusID ON Entry.RegisterStatusID_RID=Entry_RegisterStatusID.ID
INNER JOIN BASTESTDOMAINHZ_REGISTERSTATUS AS Entry_RegisterStatusID ON Entry.RegisterStatusID_RID=Entry_RegisterStatusID.ID
INNER JOIN BASTESTDOMAINHZ_REGISTERSTATUS AS Entry_RegisterStatusID ON Entry.RegisterStatusID_RID=Entry_RegisterStatusID.ID
INNER JOIN BASTESTDOMAINHZ_REGISTER AS Entry_RegisterStatusID_RegisterID ON Entry_RegisterStatusID.RegisterID_RID=Entry_RegisterStatusID_RegisterID.ID

UNION ALL SELECT Person.IsActive,Person.ExemptFromGst,Person.Reference,Person.Email,Person.Description,Person.Mnemonic,Person.UpdatedOn,
Person.BASVERSION,Person.CanDisclose,Person.RegisterStatusID_REN,Person.RegisterStatusID_RID,Person.RegisterStatusID_RMA,
Person.CreatedOn,Person.StatusSetOn,Person.ExemptFromInterest,Person.BASTIMESTAMP,Person.ID,Person.Balance,'Person' AS BAS_ENTITY
FROM BASTESTDOMAINHZ_PERSON AS Person
UNION ALL SELECT Street.IsActive,Street.ExemptFromGst,Street.Reference,Street.Email,Street.Description,Street.Mnemonic,Street.UpdatedOn,
Street.BASVERSION,Street.CanDisclose,Street.RegisterStatusID_REN,Street.RegisterStatusID_RID,Street.RegisterStatusID_RMA,
Street.CreatedOn,Street.StatusSetOn,Street.ExemptFromInterest,Street.BASTIMESTAMP,Street.ID,Street.Balance,'Street' AS BAS_ENTITY
FROM BASTESTDOMAINHZ_STREET AS Street
ORDER BY Name,Description


As you can see the INNER JOINS are all in the first select and refer to and Alias of Entry which is not mentioned in the SQL.

[aware_support]

There were no changes whatsoever in this area. Are you sure???

[chris29]

I'll email the bsv's as I have replicated the issue.

It appears to when you customise the Display results of a Query on a Business Object.

As soon as this is done the SQL fails as above.

[aware_support]

The problem has nothing with the build. There is a bug that manifests itself in the following circumstances:

1) The query is for a group of objects
2) The query uses sorting
3) The sorting list includes a shortcut attribute

Do not use shortcuts in sorting lists for group queries for the time being.

[technopak]

Hi,

Does this issue only apply to build 1365 or does it affect all previous builds also ?

Peter

[aware_support]

It affects all previous builds and has nothing to do with the latest build

[PEFS]

Is this something that will ever be fixed?

[PEFS]

My apologies to Aware...seems that if the shortcut is not selected in the reference grid then the grouping does not work. if it is selected then all is good.