http://forums.visokio.com/discussions/tagged/importing-sql/feed.rss Mon, 30 Oct 17 15:54:41 -0400 Tagged with importing-sql - Visokio Forums en-CA http://forums.visokio.com/discussion/2693/import-parametric-sql-where-clause-with-excels Tue, 19 Aug 2014 06:47:37 -0400 DominicChan 2693@/discussions I would like to read an Excel file, say containing a field with 300 IDs, and use these 300 IDs as the SQL's 'Where' clause in conjunction with {{Parameter}} (or other ways?)
Is this possible?
Thanks
Dom]]> http://forums.visokio.com/discussion/2823/import-sql-view-as-a-parameter-in-datamanagers Wed, 21 Jan 2015 07:04:24 -0500 carlosmartinmari 2823@/discussions
I'm trying to introduce a parameter, say "Sqlview" that is being used in the DataManager database source block to call a custom SQL view as follows:

select * from p = {{Sqlview}}

The problem we have is that when you give the variable type to the parameter and set it as text, in DM the variable is automatically written as:

select * from "my_table_name"

which returns an error because it should look like that:

select * from `my_table_name`

Introducing the correct symbols doesn't help (parameter enter as "`my_table_name`").

Is there any way to do that?

Thank you in advance,
Carlos]]>