Objects Found when performing a FIND in a process

rbross

Hello,

When you do a find in a process you can see in the log how many objects were found.
If Objects Found=0 is there a function to test for this or do you simply add an new "IF RULE" under the FIND Rule and see if an attribute in the FIND is not =blank or 0 etc.
For example:
I have 2 rules
Rule 1 FIND apinv_line where(..) IN BATACHES OF 1
Rule 2 calls a process called "Read apinv_hdr" passing apinv_line
in the called process I do a FIND apinv_hdr Where(...) TAKE BEST 1
This returns Objects Found=0, Now there could be something wrong with my where clause or there really is no hdr record to find, but that would be bad!

So if Objects Found=0 then I don't want to continue with my next Rule in this process, so will AIM stop this process and not continue to the next step and return back to get the next apinv_line record or will it continue to process the next rule.

If Objects Found=0 then I want it to stop.

Roger.....
PS. working with External Tables in AwareIM is not fun, you can't take advantage of the Relationships AIM offers!

BenHayat

You need to use SEARCH_COUNT to give you the returned count after FIND, like:

If SEARCH_COUNT=0 Then REPORT ERROR 'There are no orders for this Customer'

rbross

Looks like thats what I was looking for!

Thanks 🙂

tford

PS. working with External Tables in AwareIM is not fun, you can't take advantage of the Relationships AIM offers!

I used AwareIM to access and update record in a Kentico Content Management System. A key to that working effectively has been a process that runs periodically to build AwareIM x-ref records on a 1:1 basis for the records in the Kentico DB. References to the Kentico record help me easily access it when an update is needed. The AwareIM x-ref record allows us to fully utilize all of AwareIM's features and UI capabilities.

rbross

This is what I would like to do but some of their tables are changing constantly through out the day.
We would have to run this 1:1 scheduled process every few minutes, to keep everything in sync and run ti on multiple tables. Their table are very large with 100k+ rows. Do you read the entire table each time. How do you now what records have changed?

How often are you running the process to sync everything up?

Roger

tford

Do you read the entire table each time. How do you now what records have changed?

How often are you running the process to sync everything up?

Our application only needs to automatically run the sync one time / day at night. Periodically an admin starts the sync during the day as well.

Our application is not looking to monitor all the changes in the external table, but instead it references the external table and uses shortcuts to pull in certain values to the X-ref table. In our case, this makes it easier to show info in queries, etc.

Sounds like this might not apply to your scenario??

rbross

No, I thought about a nightly update like that but the MS-SQL tables I am reading are part of an accounting system so they are constantly being updated.

If there was a way for the MS-SQL DB to update the mysql tables when ever a record was changed then that might be something to look at but I don't think that is possible since they are using a packaged accounting system.

Having access external table with AIM really seems to take away from a lot of advantages AIM has to offer. At least when writing SQL you can do joins or Links to other tables AIM does not let you do that so you really have to read one table at a time to get the info you need then do the next Find to get any related records. In this case I have to do a FIND on the apinv_line table then do a FIND on the apinv_hdr table to get related records.

I can't wait to write an application using pure AIM BO's and relationships!!!

Roger