Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Can Table Component field value be referenced from WF using Token ?

Highlighted
Raj Ghimire
Occasional Visitor

Can Table Component field value be referenced from WF using Token ?

Hi,
I am trying to create a conditional step in WF which checks for values in a Table Component field. It checks whether the default value of the dropdown field which is "No Access Required" has been chaged to any other values.
I am trying to use this TOKEN [REQD.T.REQ_ACCESS_DETAILS.TE="1".VP.LOAD] but doesn't look like WF step recognizes the value. Here,TOKEN for TC field is "REQ_ACCESS_DETAILS" and token for TC field is "LOAD" .
Can someone please suggest me if it is possible to Reference Table Component field value of a request from its Workflow.
2 REPLIES
Raj Ghimire
Occasional Visitor

Re: Can Table Component field value be referenced from WF using Token ?

I used a SQL Query to pull the data from kcrt_table_entries table. That seems to have solved my issue. Thanks.
Raj Ghimire
Occasional Visitor

Re: Can Table Component field value be referenced from WF using Token ?

Queried kcrt_table_entries table parameter values.
select te.parameter5
from kcrt_table_entries te, knta_parameter_set_fields psf
where request_id = [REQ.REQUEST_ID]
and te.parameter_set_field_id = psf.parameter_set_field_id
and psf.parameter_token = 'TC_TOKEN'
//Add this to "OnDomLoad" event