perform process on BO_B Based on Query Results of BO_A

KnightWare

Can I process each record of a BO, based on the records found in a query of another BO? SO the process would be to Run a query of BO_A and filter down to the records you want. Each of these records contain a key field. Now based the this query results, find records in a second BO_B where BO_B. Key_field = BO_A.Key_field and set another field in BO B.

BO_A.Key_Field
BO_A.Description
BO_A.System
BO_A.Account

BO_A.Key_Field
BO_B.Category

Query BO_A and filter down to the records you want by Description, System, Account ect. Now using the results find each record in BO_B wher the Key Fields match and set the Category in BO_B to some value.

I've managed to pass the filtered BO_A to a process. FInd BO_B based on the key field and update the category. but only for the first record. Not all the records in the passed query results.

PointsWell

Your example is very abstract, so it's difficult to understand what's going on.

Are you trying to achieve all of this in a single process? If so then the behaviour that you've described is as expected.

If you have a set of found records and then want to process those against another set of records you need to create a second process with an input of the results of the first query

Example

ProcessFindBOA

Find BOA where BOA.System='XYZ'
ProcessUpdateBOB

ProcessUpdateBOB input BOA

Find BOB where BOB.Key=BOA.System
BOB.Attribute ='123'

KnightWare

On the right track, I did separate the processes. But the first step is actually running a query and letting the user filter it down to the records they want. So I have the query results on the screen with a button in the tool bar to start the process. I do input the BOA of the query.

PointsWell

A better example or the actual code would be helpful as it's not clear what you are doing.

KnightWare

I'll try to draw it up, but basically - you run a query and

You run a query against BOA. The user uses that query to filter down to the group of records they want.
You want to set a field in another Business Object (BOB) based on this group using the OBJECT_ID (Key field) that is in both BO's.

How I have it setup.

Run BOA Query and continue to filter to the desired group. this will be the Objects Identifiers you want to update in the second BO.
In the tool bar select "RECLASS" button that starts process "Reclass" with input BOA.

Reclass Process (input BOA).
Rule 1. Open form to store the Category value you want to set in the LoggedInRegularUser.CATEGORY attribute.

Rule 2 action 1. FIND BOB WHERE BOB.OBJ_ID=BOA.OBJ_ID
Step 2 action 2. BOB.CATEGORY=LoggedInRegularUser.CATEGORY

This works, but only for the first record of BOA.

Jaymer

this is the typical issue...

either add "IN BATCHES OF 1" to the FIND BOB (slower)
OR call a subprocess with input BOB to receive the pointers of the found BOBs, and apply the update there

BobK

Looks like a bug to me.

I believe the following is similar to what KnightWare describes

I have a query that finds some A records.
This query has a "Panel Operation" that Starts Process "CountKeys" and "Applicable to multiple items" is selected.

I run the query and filter the results to get the desired A records.
After selecting 2 records I execute the "Panel Operation" that starts the process "CountKeys"

Here is the code for the CountKeys Process (which has A as input):

FIND B WHERE B.KeyID=A.KeyID
INCREASE B.CountKeys BY 1

Here is the logs from executing the CountKeys process:

-20 Executing process CountKeys with parameters: A:3A:4
-29 Started evaluation of rules
-22 Evaluating rule 'FindB' FIND B WHERE B.KeyID=A.KeyID
-2 Adding action FIND B WHERE B.KeyID=A.KeyID to the agenda
-16 Finished rule evaluation
-16 Finished evaluation of rules
-15 Executing action FIND B WHERE B.KeyID=A.KeyID
-33 Found 1 objects
-16 Finished executing action FIND B WHERE B.KeyID=A.KeyID
-25 Started evaluation of rules after data has been changed by the actions
-6 Checking rule FindB
-16 Finished evaluation of rules after data has been changed by the actions
-29 Started evaluation of rules
-22 Evaluating rule 'IncreaseCount' INCREASE B.CountKeys BY 1
-2 Adding action INCREASE B.CountKeys BY 1 to the agenda
-16 Finished rule evaluation
-16 Finished evaluation of rules
-15 Executing action INCREASE B.CountKeys BY 1
-4 CountKeys=1
-30 Starting execution of rules when updating business object B 6
-29 Started evaluation of rules
-22 Evaluating rule 'Initial value for B.CountKeys' If B.CountKeys IS UNDEFINED Then B.CountKeys=0
-6 Evaluating condition B.CountKeys IS UNDEFINED
-7 Condition evaluated to false: 1
-16 Finished rule evaluation
-16 Finished evaluation of rules
-16 Finished execution of rules when updating business object B 6
-16 Finished executing action INCREASE B.CountKeys BY 1
-25 Started evaluation of rules after data has been changed by the actions
-6 Checking rule IncreaseCount
-16 Finished evaluation of rules after data has been changed by the actions
-16 Finished executing process CountKeys

Notice that two A records are passed into the process, but only one is processed.

BobK

I still think it is a bug, but here is a work around.

I assume you have a ReClass operation on you query. If so, remove it because it is no longer needed.

Create a new process with the first rule as
PICK ONE OR MORE FROM <the name of your existing query>
The next rule would be
ReClass

When you run this new process, your existing query will run and you can do any filtering that is needed.
Select the required records in the query and press the "continue" button.
The ReClass process will be executed for each selected records.

BobK

KnightWare wrote
I'll try to draw it up, but basically - you run a query and

You run a query against BOA. The user uses that query to filter down to the group of records they want.

You want to set a field in another Business Object (BOB) based on this group using the OBJECT_ID (Key field) that is in both BO's.

How I have it setup.

Run BOA Query and continue to filter to the desired group. this will be the Objects Identifiers you want to update in the second BO.
In the tool bar select "RECLASS" button that starts process "Reclass" with input BOA.

Reclass Process (input BOA).
Rule 1. Open form to store the Category value you want to set in the LoggedInRegularUser.CATEGORY attribute.

Rule 2 action 1. FIND BOB WHERE BOB.OBJ_ID=BOA.OBJ_ID
Step 2 action 2. BOB.CATEGORY=LoggedInRegularUser.CATEGORY

This works, but only for the first record of BOA.

I just reread this.

Is the user really doing a EDIT or VIEW to look at the BOA data?
If Yes, my work around does not work. I am not even sure it can be done.
Why are you looking at it? Are there multiple Categories and the user has to pick 1??

KnightWare

The PICK ONE OR MORE... Displays the query, but just a close button, no Continue.

BobK

KnightWare wrote
The PICK ONE OR MORE... Displays the query, but just a close button, no Continue.

No Continue hmmm.

I don't know.

rocketman

KnightWare wrote
I'll try to draw it up, but basically - you run a query and

You run a query against BOA. The user uses that query to filter down to the group of records they want.

You want to set a field in another Business Object (BOB) based on this group using the OBJECT_ID (Key field) that is in both BO's.

How I have it setup.

Run BOA Query and continue to filter to the desired group. this will be the Objects Identifiers you want to update in the second BO.
In the tool bar select "RECLASS" button that starts process "Reclass" with input BOA.

Reclass Process (input BOA).
Rule 1. Open form to store the Category value you want to set in the LoggedInRegularUser.CATEGORY attribute.

Rule 2 action 1. FIND BOB WHERE BOB.OBJ_ID=BOA.OBJ_ID
Step 2 action 2. BOB.CATEGORY=LoggedInRegularUser.CATEGORY

This works, but only for the first record of BOA.

If the category is the same for all the selected group of BOA'a then try this (you don't need a reclass button)

Process 1
Enter new [Non Persistent Business Object] (allows user to enter a Category in an NPBO attribute of the correct type)
PICK ONE OR MORE FROM [Some Query]
Process 2

Process 2 (input NPBO, BOA)
FIND BOB WHERE BOB.OBJ_ID=BOA.OBJ_ID
BOB.CATEGORY=NPBO.[Attribute containing the category]

KnightWare

Rocketman - pretty much exactly how I have it set. I am storing the value in an attribute of LoggedInRegularUser.Category. I did not pass that along because I thought it was persistant, so always available. Let me check this out.

KnightWare

When using the "PICK ONE OR MORE FROM Query", the query is all screwed up. Columns all out of order and some missing. You have to check every row as there is not a select all. And then that doesn't work, check a second box and the first one disappears and so on. You can only select one at a time.

rocketman

Are you using a previously created query?

Create a query let’s say we call it queryboa

Set the displayed columns, groups, filters etc as you normally would.

Then the line is:
Pick One or more from queryboa

If this doesn’t work, there’s a bug or corruptionin the version you are using - try a re-install

Jaymer

KnightWare wrote
...You have to check every row as there is not a select all. And then that doesn't work, check a second box and the first one disappears and so on. You can only select one at a time.

Thats how a PICK FROM Query works... not how a PICK ONE OR MORE should work. Odd.

KnightWare

Yes calling a previous formatted query. Version 8.6, build 2918. I found one issue and corrected it. But now the Query does not allow filtering. The drop down is in the column header, but will not expand. If I use text box filter, is there a symbol for contains? like "Description Like '5443%'?

KnightWare

Well, I have this working, but not as nice as I would like it. The call to the "PICK FROM" now displays the query correctly and you can filter it down to the records. Note - The Column Header filter/Column drop downs do not work on PICK FROM results. So I removed them, leaving only top row "Contains" filters. After the user narrows down the records, they must assign what they want to reclass those records as. This means popping up the User record to store the value (May change this to a system value). This next step in the process makes the Pick From results disappear, so that's a bit odd. User select the class and saves. The next process reclasses all those records. Works, but the results disappearing prior to assignment is odd.

So I thought I would try a separate tab, Left side content panel the PICK FROM, right side the User form to change the reclass value. Yeah, that doesn't work at all. Staring at two empty panels. Both process (PICK FROM for the Left, FIND USER/EDIT USER for the right) open up in their own popup windows and not in the content panels. You see the PICK one flash and disappear and the FIND USER remains open in a pop up in the middle. Both content panels (NESTED RESPONSIVE GRID Container) are set to empty, not pop-up.