Aware IM User Forums

Here is a list of Business objects with attributes that are related to each other as an example. This is not all information I need, but a good start to give you an idea of what information is where. Distributor att: Clients --Type: Client Client att: System --Type: R_System att: Trial --Type: y/n a...

Please can you point me in the right direction... I am trying to create a document that lists information from different business objects, but all related to a particular business object. I can now relate all my information through 'matching attributes' but would like to know a better way ... as in ...

Thank You VERY much for all your help!
It has explained alot and made new queries seem easier.
Works like a charm )

Is there specific documentation for explaining how to use queries?

1) Client - System a Client is related to one System, a System may have multiple clients -- A Client may have multiple Systems, and System has one client. 2) System - Server a System is related to multiple Servers, a Server is related to only one System -- Correct 3) Server - Lic Server is related t...

It's just occured to me I have given you slightly the wrong Business Objects. It should be: Client att: System --Type: R_System att: Trial --Type: y/n R_System att: R_Servers --Type: R_Server R_Server att: Lic --Type: R_Lic R_Lic att: Finish_Date --Type: Date att: Created --Type: Date Where the Busi...

That's great for showing Clients with Finish Dates.
But how do I also show the Finish Date for each client?

Ta.

Okay my Business Objects are as follows: Client att: System --Type: R_System R_System att: Properties --Type: Property Property att: IPUs --Type: IPU IPU att: Lic --Type: IPU_L IPU_L att: Finish_Date --Type: Date I want a query to run that lists all Clients that the Finish_Date of IPU_L is defined. ...

Does this only work for one to one relationships? As I am getting the error: 'Error analysis path Client.......Finish_Date Reference lists in the middle of the identifier are not allowed' What I wanted to find, was the name of the Client, and the Finish_Date from table E in one nice row returned. No...

Hi, I have created Business Objects that are linked to each other and would like to know how to get the information from the bottom Object in the chain to show up at the same time as information from the top Object in the chain. So .. Object A - attribute objectbs Object B - attribute objectcs .. an...