BobSwift run-now replacing of template variable

[Iris Abramovitz]

hello,

I have tried to replace a query parameter from a template variable without success. I tried setting a metadata variable and that seemed to work as long as the metadata defined was static.

I want to be able to do the following

{run-now} {include:$ProjectName} {sql:datasource=Report_DataMart} select '$first', key FROM [dbo].[strategy]   where key like '$first%' {sql} {run-now}

where $first is a template parameter.

I have also tried this {run:replace=first:$first} {sql:datasource=Report_DataMart} select * FROM [dbo].[strategy]   where key like '$first%' {sql} {run}

with out any success. only thing I got working is select '%metadata_example1%' however metadata plugin does not support getting it's value from a template parameter.

Thanks in advance,

Iris

[Bob Swift]

I don't know how you can get a template variable to work in this scenario .

[Carrie Moley]

Our company just upgraded from 3.5.9 to 6.8.1 (I know...we got behind). 

In 3.5.9, we were able to wrap template variables in the metadata-list macro. This was great, because it let us define list values for our users to fill out in a form and then create custom reports from the result:

{metadata-list}
|| Date | @Date|textarea(1,40)@ |
|| Requester | @Requester|textarea(1,40)@ |
|| Type | @Type|list(Select,Maintenance,Incident,Defect,Complaint,Query)@ ||
{metadata-list}

I am trying to figure out how to do this with 6.8.1, but it seems that I can either have variables that are not metadata, or static metadata that people have to fill in manually rather than choose from a list.

Is anyone able to help me with a great suggestion here?

Thanks,
Carrie