Cannot issue an IF after a FIND statement

ddumas

In the following rule, The FIND statement by itself works, but when an IF is issued, get a syntax error on the IF.

No IF statement will work after the FIND, even the one at the bottom. I have plenty of Business Rules with this kind of logic, so very confused as to why this does not compile.

Find Project where Project=ProjCapitalBudgetSpending.Project
IF (SUM ProjCapitalBudgetSpending.Amount WHERE (ProjCapitalBudgetSpending IN Project.ProjCapitalBudgetSpends)> Project.CapitalBudgetTotal) THEN
REPORT ERROR 'Sum of Transactions exceeds Total pre-allocatted for Project'

This does not even work - get the same error

FIND Project WHERE Project=ProjCapitalBudgetSpending.Project
IF (1>0) then report error 'xxx'

aware_support

You cannot use IF in actions of the rule. Each IF must be a separate rule. Therefore, if you want to use IF after FIND you need a process

ddumas

aware_support wrote
You cannot use IF in actions of the rule. Each IF must be a separate rule. Therefore, if you want to use IF after FIND you need a process

So just call a process right after the find, or call a process as the only statement in the rule?

ddumas

aware_support wrote
You cannot use IF in actions of the rule. Each IF must be a separate rule. Therefore, if you want to use IF after FIND you need a process

This should be really easy.

In Project I have an attribute BudgetTotal, type number, which sets an allocation total not to be exceeded by individual BudgetTransactions.
In Project I have an attribute BudgetTransactions, type BudgetTransaction

I have an object BudgetTransaction, owned by Project, with an amount attribute, a description, and a Project attribute, type project.

When a new BudgetTransaction is entered I need a business rule to check that the sum of all pre-existing BudgetTransaction instances + this new transaction do not exceed Project.BudgetTotal. If it does, report error.

Logically, the business rule needs to be on BudgetTransaction. In a business rule (If BudgetTransaction IS NEW), I have tried calling a process which takes BudgetTransaction and SystemUser as input. In the process, I find the project, sum the pre-existing transactions. I then store the sum to SystemUser.TempNumber1. I then check if Project.BudgetTotal is exceded by (SystemUser.TempNumber1 + BudgetTransaction.amount). If so, I REPORT ERROR.

I keep getting operation error, or internal error using this design.

I have also tried adding the REPORT ERROR inside BudgetTransaction, instead of the process.

This seems like a really simple thing to do. What I am I doing wrong?

ddumas

Got this to work.

I was referencing SystemUser.xxxx instead of LoggedInSystemUser.xxx.

That was causing the operation error and internal error.

So, in summary, since I needed to maintain a rule order, I called a single process in the business rule, and the process did everything, including REPORT ERROR

hpl123

ddumas wrote
Got this to work.

I was referencing SystemUser.xxxx instead of LoggedInSystemUser.xxx.

That was causing the operation error and internal error.

So, in summary, since I needed to maintain a rule order, I called a single process in the business rule, and the process did everything, including REPORT ERROR

Thanks for sharing your results, how you actually get things working.