Hi Guys,

We have 2 tables for instance Properties & Tenants. A Property can have multiple Tenants And a tenant Can Be Linked To Multiple Properties. However I want to be able to display a Query that would show all the Tenants next to each one of the properties they are linked to.

We are able to write a nice SQL inner join that displays the correct results in MySQL CLI but when I try to use that query in in Aware it Says 'Cannot Find business Object property_ref'. We obviously need to use the Ref table to get what we want but since that is not an object in AwareIM I have no way to display that data set.

Is this a known Aware limitation? What is the point of having access to 'SQL Form' of the Query writer if you cannot display results of any SQL query that is not a direct Aware Object?

Here is the Query we run in the CLI which gives the exact result set we want to see:

SELECT bastestdomaincustomquerytest_tenant.TenantName AS Tenant, bastestdomaincustomquerytest_property.PropertyName AS Property FROM bastestdomaincustomquerytest_property_ref INNER JOIN bastestdomaincustomquerytest_tenant ON basdbtest.bastestdomaincustomquerytest_property_ref.RID=bastestdomaincustomquerytest_tenant.ID INNER JOIN bastestdomaincustomquerytest_property ON basdbtest.bastestdomaincustomquerytest_property_ref.ID=bastestdomaincustomquerytest_property.ID

If this is a known limitation... Then Support, is this something you would ever be able to address?

Thnx in advance for any input