Query with parameters from another Object

ACDC · Post by **ACDC** » Sat Aug 23, 2008 7:34 pm

Hi

I am trying to set up a query that gets its parameters from another OBJECT when in context.

I want to change this query:
"FIND Appointment WHERE Appointment.Type='Meeting'"

to something like:
"FIND Appointment WHERE Appointment.Type=Report.Type"

In the Report Object, the attribute "Type" has an option 'Meeting'

Is this possible ? as I cannot seem to come up with the right rule syntax

Thank You

tford · Post by **tford** » Sun Aug 24, 2008 1:55 am

ACDC,

Yes, this should be possible.

Perhaps you can explain more about how you are trying to do it. Is this Find.... syntax in a query? How/where is the context formed?

Tom

ACDC · Post by **ACDC** » Sun Aug 24, 2008 1:01 pm

Tom

Yes, the Find.. is in a query that is part of a rule in a process that is in an Object and accessed from the program bar when in edit view

When the user is in edit view of a record there is an option on the program bar "Generate List" that runs the query and inserts the result of the query in the reference attribute 'Appointment" of the current object in edit

The parameters of this query are obtained from the contents of the attributes in the record being edited.

tford · Post by **tford** » Sun Aug 24, 2008 7:42 pm

ACDC,

Assuming you have a reference attribute Report.Appointments, you should be able to have the form that Edits a Report instance call a process.

That process would have Report as a process input and have a rule as follows:

FIND Appointment WHERE Appointment .Type=Report.Type
INSERT Appointment IN Report.Appointments

You do not need a query. The FIND action will be part of a process.

Does that help?

Tom

ACDC · Post by **ACDC** » Mon Aug 25, 2008 8:03 am

Tom

Yeah , thanks I got it working