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.
Queries
-
- Posts: 595
- Joined: Sun Apr 24, 2005 2:22 am
- Contact:
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
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