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[/color][/size]
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.
