advoco-connect-education-network-logo-wh
How Training Works
Infor EAM Training Courses
Pricing
Sign Up
Member Login
To see this working, head to your live site.
  • Categories
  • All Posts
  • My Posts
normunds.sarsuns
May 12, 2020

Creating Flex Business Rule

in Ask the EAM Community

I am trying to create simple Flex Business rule. I am trying to force the usage of Closing Codes if user is trying to close "Breakdown" type of work. SQL querry (which does not work) is: SELECT NULL

FROM R5EVENTS

WHERE EVT_SQLIDENTITY =:ROWID

AND EVT_JOBTYPE = 'BRKD'

AND EVT_TYPE = 'JOB'

AND EVT_STATUS='C'

AND (EVT_REQM IS NULL

OR EVT_FAILURE IS NULL

OR EVT_CAUSE IS NULL

OR EVT_ACTION IS NULL) Thsi one triggers on any update of R5EVENTS table (WO insert/updates, new Positions etc.) What am I doing wrong? Can somebody pls advise me...

1 answer1 reply
0
1
jharrison
May 28, 2020

Try putting in a error condition


SELECT count(*) into some_field

FROM R5EVENTS

WHERE EVT_SQLIDENTITY =:ROWID

AND EVT_JOBTYPE = 'BRKD'

AND EVT_TYPE = 'JOB'

AND EVT_STATUS='C'