Project and Portfolio Management Practitioners Forum
cancel

Rule can't work depending on project health

SOLVED
Go to solution
Highlighted
yangqingtao
Valued Contributor.

Rule can't work depending on project health

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

 

PS - Gloabal delivery Center - China
8 REPLIES
dlinetsk
Super Contributor.

Re: Rule can't work depending on project health

Hi there,

 

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

 

when the rule is triggered you should've get a JavaScript alert that your rule is wrong.

 

 

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.

 

Thanks,

Dmitry

yangqingtao
Valued Contributor.

Re: Rule can't work depending on project health

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

PS - Gloabal delivery Center - China
dlinetsk
Super Contributor.

Re: Rule can't work depending on project health

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)

 

 

 

 

dlinetsk
Super Contributor.

Re: Rule can't work depending on project health

Hi there, was the issue resolved?

yangqingtao
Valued Contributor.

Re: Rule can't work depending on project health

 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 

PS - Gloabal delivery Center - China
dlinetsk
Super Contributor.

Re: Rule can't work depending on project health

So, you do not get any JavaScript alerts at all?

 

Can you check if JavaScript is enabled in your browser?

 

Also, please post your rule once more (screenshot).

 

Thanks,

Dmitry

yangqingtao
Valued Contributor.

Re: Rule can't work depending on project health

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"  

(see attachement:Override.png)

 

if you change the project health by "Override" button, you wiil see what happened to me

 

 

PS - Gloabal delivery Center - China
yangqingtao
Valued Contributor.
Solution

Re: Rule can't work depending on project health

It look like I can close this topic

 

we should change this rule happens when "page load" to meet this reuirement

PS - Gloabal delivery Center - China