# Using dictionary variable in the query

**URL:** <https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339>\
**Category:** CloverDX Platform\
**Created:** [February 3, 2014, 12:00am UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339 "2014-02-03T00:00:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergii.chukhno](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@sergii.chukhno](https://forum.cloverdx.com/u/sergii.chukhno)\
**Post date:** [February 3, 2014, 12:00am UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/1 "2014-02-03T00:00:00Z")

</div>

Hi all,

Could you please give me advice concerning to the using dictionary variable in the “where” clause of the query in DB Input Table component.

I don’t know which format is ?

Thanks a lot  
in advance

---

<div class="post-metadata">

**Author:** ![sergii.chukhno](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@sergii.chukhno](https://forum.cloverdx.com/u/sergii.chukhno)\
**Post date:** [February 5, 2014, 2:02pm UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/2 "2014-02-05T14:02:30Z")

</div>

> Hi all,
> 
> Could you please give me advice concerning to the using dictionary variable in the “where” clause of the query in DB Input Table component.
> 
> I don’t know which format is ?
> 
> Thanks a lot  
> in advance
> 
> “sergii.chukhno”

Please close this topic. I have resolved this problem.

Thanks.

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [February 5, 2014, 2:08pm UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/3 "2014-02-05T14:08:03Z")

</div>

Hi Sergii,

Unfortunately using dictionary in DbInputTable is not supported.

Instead please:  
\* prepend DataGenerator in front of DbInpuitTable and set it to produce exactly one record  
\* in transformation of DataGenerator generate your SQL query using [http://doc.cloveretl.com/documentation/ … -ctl2.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dictionary-entries-ctl2.html)  
\* connect DataGenerator and DbInputTable via edge using metadata containing at least single string field (containing SQL query)  
\* set DbInputTable to read data from input port; see input port section of [http://doc.cloveretl.com/documentation/ … table.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dbinputtable.html) for details

Please let me know if you have further questions.

---

<div class="post-metadata">

**Author:** ![sergii.chukhno](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@sergii.chukhno](https://forum.cloverdx.com/u/sergii.chukhno)\
**Post date:** [February 6, 2014, 11:29am UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/4 "2014-02-06T11:29:32Z")

</div>

Hi Kubosj,

I have resolved it by added ExtFilter after DbInputTable component and posted there condition with dictionary entry.

Thanks a lot.

---

<div class="post-metadata">

**Author:** ![paulhbartosik](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@paulhbartosik](https://forum.cloverdx.com/u/paulhbartosik)\
**Post date:** [December 6, 2017, 1:56pm UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/5 "2017-12-06T13:56:00Z")

</div>

Is this still true in the current version?

I have many graphs that I set up with parameters. Most of those use the parameters in the **where** clause of SQL queries. If I want to convert these to Launch Services on my CloverETL server, do I have to convert all of those parameters to dictionary entries, or is there another way?

Thanks for any suggestions.

-Paul

> Hi Sergii,
> 
> Unfortunately using dictionary in DbInputTable is not supported.
> 
> Instead please:  
> \* prepend DataGenerator in front of DbInpuitTable and set it to produce exactly one record  
> \* in transformation of DataGenerator generate your SQL query using [http://doc.cloveretl.com/documentation/ … -ctl2.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dictionary-entries-ctl2.html)  
> \* connect DataGenerator and DbInputTable via edge using metadata containing at least single string field (containing SQL query)  
> \* set DbInputTable to read data from input port; see input port section of [http://doc.cloveretl.com/documentation/ … table.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dbinputtable.html) for details
> 
> Please let me know if you have further questions.
> 
> “kubosj”

---

<div class="post-metadata">

**Author:** ![PedroVazquezRosario](https://avatars.discourse-cdn.com/v4/letter/p/ed8c4c/32.png) [@PedroVazquezRosario](https://forum.cloverdx.com/u/PedroVazquezRosario)\
**Post date:** [December 7, 2017, 3:49pm UTC](https://forum.cloverdx.com/t/using-dictionary-variable-in-the-query/1339/6 "2017-12-07T15:49:57Z")

</div>

Hi Paul,

This is still true in the current version of CloverETL, unfortunately, dictionaries are not supported in DBInputTable. On a side note, if you are using CloverETL 4.7 we introduced an improved version of Launch Services called Data Services. If you would like to know more I have added a few links that explain how it works.

[Data Service Documantation](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/data-services.html)

[Data Service Blog](https://blog.cloveretl.com/data-services-3-core-design-patterns)