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

Table Component In a request

SOLVED
Go to solution
Highlighted
Fergal Kavanagh
Occasional Advisor

Table Component In a request

Hi ,

I have a table compoent on a demand request that I want to display the total of a column on the main request page. I took the following passage from the Tokens and Commands PDF on the site but when I transfer my details in, the token can be parsed.

The passage mentions the table component token as being [EMPLOYEE] but when i look at my table component there is no token as such only a meta layer view. I use the token (listed below) in a rule to set a radio button field if the value is > 200 but I have also tried it as a Custom SQL in an autocomplete list to no avail.

I have tried many options with reagrd to the construction of the token(too many to list here) but the same error is recieved. I think myself it is down to the Token name that the PDF calls [EMPLOYEE]

Any help is appreciated.

####################################
From the Tokens and Commands Manual
####################################

In these examples, the following example will be used. A table component
named Employee with 4 columns:
􀀀 Name of Employee
􀀀 Years of Service of the Employee
􀀀 Department where the Employee belongs to
􀀀 Salary of the Employee.
These columns are defined as shown:
Table Component “Employee Table” with [EMPLOYEE] as the Token.
Column 1 - Name of Employee; Token = [NAME]
Column 2 - Years of Service; Token = [YEARS_OF_SERVICE]
Column 3 - Department of Employee; Token = [DEPARTMENT]
Column 4 - Salary of Employee; Token = [SALARY]
Table Row
Table Cell


To access the Salary Column Total value from a Request context
[REQD.T.EMPLOYEE.TC.VP.SALARY.TOTAL]
WHERE: EMPLOYEE is the Token given to a table component type and
SALARY is the Token name given the table's first column.

###########################################
The SQL I am using in my Rule
###########################################

select 'Y','Y' from dual
where [REQD.T.IRL_PR_DETAILS_TABLE.TC.VP.TOTAL_RPICE.TOTAL] > 200

The mis-spell is ok.

The field the table componetn in is called DETAILS.
##########################################

Again Thanks
3 REPLIES
B Swanson
Regular Collector
Solution

Re: Table Component In a request

Here is a rule I use to take the totals from a table column and put it in the request:

Select '[REQD.T.CR_TASKS.TC.P.ACT_HOURS.TOTAL]', '[REQD.T.CR_TASKS.TC.VP.ACT_HOURS.TOTAL]' from DUal

Where 'CR_TASKS'is the token of the table field in the request, and 'ACT_HOURS' is the token name of the specific field I want totalled in the table component.

Did you try with quotes around the token name?

Hope that helps,
Brian
Fergal Kavanagh
Occasional Advisor

Re: Table Component In a request

Brian,

Thank you so much. It was a mixture of the wrong field token (I was using the Meta_Layer name of the table component) and the inverted commas also.

It works a treat now.

Fergal
Andy McMahon_1
Collector

Re: Table Component In a request

The quotes helped me!  Thanks so much. 

//Add this to "OnDomLoad" event