06-26-2009 01:24 AM
While looking at one DataSource, I could see the following where clause -
"AND KRHD.PARAMETER10 IN ([VP.SCHEDULED_RELEASE.TO_STRING]"
Here, what does VP. stand for?
Sorry, I am new to PPM/QC with little knowledge on SQL.
Thanks in advance.
06-26-2009 01:35 AM
You can see two types of naming.
User_data & Visible_user_data (For user Tables)
Parameter & Visible_Parameter.(for other Tables)
Mostly the custom field values are stored in 2 values 'ID' in Parameter and 'Name' in Visible_Parameter.
06-26-2009 02:10 AM
If I need to add new filter to this DataSource, its asking me to add where clause.
Please see image attached (marked red circle). What value I should provide in this case? and how?
06-26-2009 02:18 AM
The DS Where clause should begin with 'And'
and P.Test_Field = '[VP.Test_User_Field]'
From my portlet
and P.Prj_project_manager_username like '%[VP.PROJECT_MANAGER]%'
06-29-2009 01:44 AM
If I want to run a below Query as a Portlet.
Select * from KNTA_USERS where Full_name ='Mahendran Muthu'
When the Value 'Mahendran Muthu' can be changed to any value like below.
Select * from KNTA_USERS where Full_name ='Sam Greg'
Select * from KNTA_USERS where Full_name ='XYZ'
For this Purpose we create a filter. For that filter we have the Token Name called 'TEST_FIELD'.
In the 'When this filter Field has value, append to where clause'
I will write as below
Please note, I am not prefixing 'and' before the clause (Full_name ='[VP.TEST_FIELD]') because it is the first and only 'where' value.
Hope I confused you more :-))