Project and Portfolio Management Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Creating a SQL to check a field in a Request

SOLVED
Go to Solution
Advisor

Creating a SQL to check a field in a Request

Ok here's the problem:

I have two fields in a Request called "Overall Total". and "Strategic Alignment"

The Validation for "Overall Total" is a Text Field with a Currency Data Mask.

The Validation for "Strategic Alignment" is Component Type "Auto Complete List" validated by "SQL - Custom"

 

I added a step (or two) to the workflow NOT to execute a "Create Request" step if the value of "Strategic Alignment" field not equal to Mandatory/Regulatory or when Overall TOTAL sizing estimate is less than $ 250,000.00

 How do i get the background SQL in the workflow step to check for these values only in the Request it is currently executing?

 

1 REPLY
Honored Contributor

Re: Creating a SQL to check a field in a Request

Hi,

 

check the following post, this might contain what you are looking for:

 

http://h30499.www3.hp.com/t5/Project-Portfolio-Management/Workflow-transition-dependent-on-two-field-values/m-p/5383983#M1582

 

cheers

alex


--remember to kudos people who helped solve your problem