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

How to use Budget and Request token in 'Budget Line User Data'

Highlighted
Sandeep Kaur
Acclaimed Contributor

How to use Budget and Request token in 'Budget Line User Data'

Hi,

I have following query regarding usage of token in the validation of a field used in the 'Budget Line user data':

There is a field 'X' in the Budget Line user data. The validation of field X is throwing error when [BGT.BUDGET_ID] or [REQ.REQUEST_ID] is used in the validation query.
Can someone please tell as how we can used system or custom tokens in the User data.

Thanks,
Kaur Sandeep
7 REPLIES
Varun Singh
Regular Collector

Re: How to use Budget and Request token in 'Budget Line User Data'

Hi Sandeep,

Can you tell me what is the error and in which scenario ur trying to use.
and the query you have written.

-Varun
Arguing with a fool, proves there are two
Sandeep Kaur
Acclaimed Contributor

Re: How to use Budget and Request token in 'Budget Line User Data'

In the request type there is field 'Start Date' whenever the request is submitted, the budget gets created.
In the Budget Line user data, there is implementation date field. Whenever the user is trying to modify the budget line, he has to fill values in the implementation date field.
At this point we want the user to enter only those dates which which we have selected in the request type.

If we use budget id token in the implementation date field then it is throwing an error. The ERROR is due to unparseable token.

Please let me know if you need more clarification.
Varun Singh
Regular Collector

Re: How to use Budget and Request token in 'Budget Line User Data'

Can you please send me the token for start date, implementation date and the sql query you are trying to use in the validation for implementation date.

Arguing with a fool, proves there are two
Sandeep Kaur
Acclaimed Contributor

Re: How to use Budget and Request token in 'Budget Line User Data'

Please find the query as follow:

SELECT period_id, period_full_name
FROM knta_periods
WHERE period_type_id = 4
AND UPPER(period_full_name) like UPPER('?%')
AND (period_full_name like UPPER(substr('?', 1, 1)) || '%'
OR
period_full_name like LOWER(substr('?', 1, 1)) || '%')
ORDER BY start_date

I have to use period_id = '[KNTA_PLAN_START_DATE]' condition in the above specified query. Or if it is not possible can I use the budget id token in above query and after then i will fetch start date from the knta_budgets. I tried it but got an unparseable token error.

Thanks
Kaur
Varun Singh
Regular Collector

Re: How to use Budget and Request token in 'Budget Line User Data'

Use it this way:

period_id = '[REQ.P.KNTA_PLAN_START_DATE]'
or
period_id = '[REQ.VP.KNTA_PLAN_START_DATE]'

Try any one of this.. depending on the value of period id and value in plan start date..


Arguing with a fool, proves there are two
Sandeep Kaur
Acclaimed Contributor

Re: How to use Budget and Request token in 'Budget Line User Data'

I have also tried this but it is throwing same error. Although '[REQ.P.KNTA_PLAN_START_DATE]' token carry the period id value.
Cris Robin
Regular Collector

Re: How to use Budget and Request token in 'Budget Line User Data'

Hello Kaur Sandeep

I had the same problem when i was still used ver. 6.

If you add the name of the budget to the token it will be ok but because the resone we use token it is to use the current budget we clicked on this is not useable.

As for ver. 6, this is a bug I reported.
I do not know if the bug was fixed or not.

I tried to locate the bug number for you but I found it impossible because it was reported to mercury system and not to HP.

Hope you find it useful.

Sagi

//Add this to "OnDomLoad" event