SQL Form Query between Business Objects

denisv

I need to be able to create an SQL query joining tables to select the attributes I want to display. Is this not possible ? If you use TSQL against a SQL database, the following query runs fine:

SELECT CALLMANAGER_CALLRECORD.MTCN, CALLMANAGER_PAIDINERROR.NotificationDate, CALLMANAGER_CLIENT.ClientID,
CALLMANAGER_CLIENT.Name
FROM CALLMANAGER_CALLRECORD INNER JOIN
CALLMANAGER_PAIDINERROR ON CALLMANAGER_CALLRECORD.ID = CALLMANAGER_PAIDINERROR.CallRecord_RID INNER JOIN
CALLMANAGER_CLIENT ON CALLMANAGER_PAIDINERROR.Client_RID = CALLMANAGER_CLIENT.ID

What changes have to be made in the SQL Form Tab in Aware to get this query to work. When I try to use the SQL Form Tab in rejects queries stating 'The Query must contain table identifier'

denisv

Hi,

I am assuming that displaying a result set from two Business Objects needs an SQL query to be used instead of Simple or Rule Form queries. Can anyone give me an example of a simple query between two BO's that then will return the result set in a query grid the user can work with ?

aware_support

Try using SELECT * FROM ... Make sure FROM is surrounded by space symbols on a single line. Selecting particular columns is meaningless anyway as Aware IM will use its own.

denisv

Thanks, using * gets around the error but how to I get attriutes from both Business Objects to appear together. How do I get the joing syntax in the query ?

I need 'x' attributes from BO 1 and 'y' attributes from BO2 wher BO1 and BO2 are related by database table via BO2_RID in BO1

aware_support

If all you need is to display attributes of both objects in the query, you don't need the SQL query. Just make sure that the two objects are related and define shortcuts to those attributes of the related objects that you want to see as part of the query on the first object. Then define a query that will include shortcuts in the list of displayed attributes.