Passing query template name to BLS SQL action in the link editor

[Former Member]

I want to have one transaction that uses the SQL query action, but which query template it uses will be dependent on some user input. I am having trouble passing the query name. I'm using the full file path in xml format (i.e. "c://<folder1>//<folder2>//<folderN>//"&PassedFileName&".xml", but with backslashes instead of forward slashes). I got an error around the connector, so I set that too. Then I got an error around mode, so I set it to "FixedQuery". Now I'm getting, "The Query expression was not set with the Query parameter".

There are only 3-5 possible queries that will be used, so I'd rather build SQL queries and just pass the transaction the name of the query, as opposed to passing the full text of the query each time.

Thanks,

Carrie

Edited by: Carrie Schimizzi on May 9, 2008 6:38 PM

Edited by: Carrie Schimizzi on May 9, 2008 6:39 PM

Edited by: Carrie Schimizzi on May 9, 2008 6:40 PM

[jcgood25]

Carrie,

If you haven't already done so, configure your master BLS transaction with a proper representative runtime variation, which will make the whole process simpler to create and troubleshoot. Quite often when people try to use the dynamic capabilities of MII, they end up getting confused because of user over-complication. In your SQLQuery action block make sure you configure it to a valid template that would be one that the user would provide as an input (don't forget to allow the generation of sample results for making any subsequent trx efforts easier). Then look in the link editor and you should see this string value for the query template link if you hover over the corresponding blue T icon. This will show you the format you need to provide from your Transaction input property (which should also have a valid default value assigned so you can test the transaction by itself, without needing to initially rely on the Xacute Query template layer.

Regards,

Jeremy

[Former Member]

You don't need to pass the .xml for the Query template name.

Just the name should suffice (ofcourse with the relative path).

Assuming you are on 11.5 , for example if you have a QT QT_1 under <InstallDrive>:\Lighthammer\Illuminator\Templates\<Folder1>,

so you would be passing <Folder1>/QT_1 as the QueryTemplateName.

Hope this helps.

Edited by: Udayan Upreti on May 9, 2008 12:48 PM