Process results of query

kklosson

I have a form-driven query and what I would like to do is process all of the records in the query result but I don't see an apparent way to accomplish it. Within a process, is there some way to address the query result, or duplicate it so that just the returned records can be processed? Since it's form-driven, I see no way to do it.

tford

What does your process look like & what are you trying to do with the result?

kklosson

Haven't designed it yet. But my needs are simple. So maybe I just want to set a value in each result object like:

FIND [Query]
Object.Attribute=[Value]

But the [query] would return the query as originally formed, not as reduced via the form, I presume. So how do I process the reduced result?

tford

Is this your situation:

1) Find all in Query
2) Set a value in all records from query in #1
3) Use a form to show certain instances of Query

kklosson

No, I don't think you get me.

I want to process the records of a query as reduced. Really it's the same as if I present a query and then the user reduces the result using the reducer tool. Then I want to process just the records in the reduced query.

Ideally I'd like to put an action button on the query result that processes the result records. I can this for example for a Create Document action - user selects all or some records and prints a report. But this is not an option for a Start Process action. A process has no context to the query.

tford

How many fields are you looking to filter by in the "reducer" form?

kklosson

between 5 and 10 at this point. I have a couple of different objects that I would like to do this with.

tford

My preferred way is to display the criteria on a form in on panel & show the query results in a panel below it.

In the screen shot below, the top panel has 5 criteria that are stored in the LoggedInRegularUser, then used in the query in the panel below it:

With this approach, the criteria stored in the LoggedInRegularUser are available for us in any other processes that are performed.

Note that the form makes use of Auto Refresh upon changes in the RegularUser BO and various RegularUser attributes make use of "include undefined text in selection" and "save form when selection changes".

The query makes use of Auto Refresh on changes to RegularUser as well.

tford

The FIND statement used in the Query shown in the bottom panel is:

FIND Movement WHERE (Movement.Movement.Description=LoggedInSystemUser.Selected_Movement.Description OR LoggedInSystemUser.Selected_Movement IS UNDEFINED) AND Movement.WhenCompleted>=LoggedInSystemUser.Selected_Date_From AND Movement.WhenCompleted<=LoggedInSystemUser.Selected_Date_To AND (Movement.Movement.Group_List CONTAINS LoggedInSystemUser.Selected_Movement_Group.Grouping OR LoggedInSystemUser.Selected_Movement_Group IS UNDEFINED) AND (Movement.Timing.Timing=LoggedInSystemUser.Selected_Movement_Timing.Timing OR LoggedInSystemUser.Selected_Movement_Timing IS UNDEFINED) ORDER BY Movement.WhenCompleted,Movement.TimingNbrSC,Movement.ID

kklosson

Tom,
I think in your example, the user is querying his/her own object. In my case, it's just an object, so I don't see how I make your scheme work.

tford

It's just the selection criteria that are stored in your own object (RegularUser). The object you are querying (Movement in my example above) is the other part of the FIND action.

kklosson

Okay, I can try that. But when you are driving the query from a form, how/where do you save the search criteria to the RegularUser object? Where do you put that rule?

tford

The form and query are presented in a VP with vertical layout with two content panels:

1) The first content panel is driven by a Command ... a process which has only 1 rule:

VIEW LoggedInSystemUser USING Select_Team_and_Assign_User

2) The second content panel is driven by a Query