Queries

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
denisv
Posts: 253
Joined: Thu Jan 19, 2006 4:36 pm
Location: Ireland
Contact:

Queries

Post by denisv »

a) I have an attribute on a business object holeding the value of the user who created the record (this uses LoggedInSystemUser at creation stage by rule). How can I have a query that returns all records that I have created ? (So it is generic to any l0gged in user).

b) In the same object (titled CallRecord) I have an attribut titled CallerDetails which relates to a Business Group covering three business objects for different Caller Types. I would like to put a query on the CallRecord form which searches for all records related to the caller in callerdetail attribute. So I need to pass the clientid from callrecord.callerdetails.clientid into the query.
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

a) The query would look like this:
FIND ALL CallRecord WHERE CallRecord.CreatedBy = LoggedInSystemUser

b) Assuming the group's name is Caller you can add the following query as an operation on CallRecord form:
FIND ALL CallRecord WHERE CallRecord.CallerDetails = ThisCallRecord.CallerDetails
Aware IM Support Team
Post Reply