I have a rule in request type to change field value(Text 200) accroding to project health change
I change the project health manually, but field value doesn't change at all
Here's my configure:
Dependencies: Project Health:
Logic: SQL Default
SELECT "test", "test"FROM DUAL
Go to Solution.
you are using the wrong SQL syntax for Oracle. Oracle does not accept double quotes for strings... try using single quotes.
SELECT 'test', 'test'FROM DUAL
Also, it is always a good practice to run your SQL query directely against DB using SQL Developer, Toad, or any other client development environment.
thank you ,that's my mistake
but it still doesn't work as my expectation
It looks like PPM can't capture the project health change event
are you talking about OOTB Project Health that is part of the PFM Project field groups?
I just set such a rule on my evnironment, the rule does fire on Project Health field change.
Are there any prior rules that have "Process subsequent rules" flag set to "No" that is triggered before your rule for Project Health? (see attached)
Hi there, was the issue resolved?
I have Process subsequent rules" flag set to "Yes" (leave it unchange when create)
I still get same result
as you said, I copy a new request type from PFM Project
create a new text field to test this rule.
I am not sure is there anything wrong with my operation
Also, please post your rule once more (screenshot).
may be I know why the rule can work in your environment
do you change the project health by select the value in dropdown list. see attachement:Project health change.png
but as you know, the field "Project Health:" is "display only" in OOB configure, user couldn't change it on page(attachment:project health no change.png)
it's value will be auto populated when user change the Project health status by clicking on the button "Override"
if you change the project health by "Override" button, you wiil see what happened to me
It look like I can close this topic
we should change this rule happens when "page load" to meet this reuirement