Using 6.6.2, I have a form that receives a token via a link from another form. The initial form has a grand total field called Total. When the user clicks on that value, I want the resulting form to translate Total to * so that it can be used in a search. Here's one of the many ways I have tried to accomplish this:
<init> <eval token="form.Region">replace($form.Region$,"Total","*")</eval> </init>
No matter how I format the eval statement (like, match, etc), it doesn't execute. I have even tried placing the eval statement in the initial form after the drilldown and before the link, and I still can't modify the token value.
This is much trickier than I thought.
Apparently it is not working to use form tokens in the init section.
I got it working by putting the eval token section in the search of the drilldown dashboard:
<panel> <table> <title>...</title> <search> <query>...$form.Region$...</query> <progress> <eval token="form.Region">replace($form.Region$,"Total","*")</eval> </progress> </search>
Alternatively, which might be the better solution: Use a done section in the initial search to set a token which you use to populate the drilldown:
<panel> <table> <search> <query>...</query> <done> <eval token="Region">replace($click.value$,"Total","*")</eval> </done> </search> <option name="count">10</option> <drilldown> <link target="_blank">...form.Region=$Region$</link> </drilldown>
This is the drill down section from the initial form:
<drilldown> <link target="_blank">/app/coo/by_bu?form.Region=$click.value$&form.BU=$bu_dropdown$&form.VM_DXC=$VM_DXC$</link> </drilldown>