# Passing Date into a Graph File

**URL:** https://forum.cloverdx.com/t/passing-date-into-a-graph-file/1145
**Category:** CloverDX Platform
**Created:** [December 11, 2012, 12:00am UTC](https://forum.cloverdx.com/t/passing-date-into-a-graph-file/1145 "2012-12-11T00:00:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![nrmvijay1990](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/nrmvijay1990/32/109_2.png) [@nrmvijay1990](https://forum.cloverdx.com/u/nrmvijay1990)
#### Post date: [December 11, 2012, 12:00am UTC](https://forum.cloverdx.com/t/passing-date-into-a-graph-file/1145/1 "2012-12-11T00:00:00Z")

</div>

Hi,

This is Vijay and I am new to Graph file coding. So it would be gr8 if you could help me on this.

I have a graph file which uses SQL query to connect to DB and generate a data file. I wish to pass a parameter date to the graph file accordingly from which date, details can be extracted.

I have attached my graph file here. It would be gr8 if you could suggest me in this regard…

\<?xml version="1.0" encoding="UTF-8"?\> 

Thanks and regards,

Vijay Murali

---

<div class="post-metadata">

### Author: ![slechtaj](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@slechtaj](https://forum.cloverdx.com/u/slechtaj)
#### Post date: [December 12, 2012, 12:48pm UTC](https://forum.cloverdx.com/t/passing-date-into-a-graph-file/1145/2 "2012-12-12T12:48:47Z")

</div>

Hi Vijay,

The functionality you are looking for is a part of commercial version of CloverETL. The component designed for such purposes is DBJoin (receives data from incoming edge, use them to join with data in a database). However, there is a workaround you might take into consideration. You can prepare the query in another component and send the whole query over the edge into DBInput.

---

<div class="post-metadata">

### Author: ![slechtaj](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@slechtaj](https://forum.cloverdx.com/u/slechtaj)
#### Post date: [December 12, 2012, 1:04pm UTC](https://forum.cloverdx.com/t/passing-date-into-a-graph-file/1145/3 "2012-12-12T13:04:43Z")

</div>

Above suggested workaround could be done as follows:

- Prepare the whole query in preceding component and assign it to output record.

- In DBOutputTable enter the following:

```auto
port:$0.<QueryFiledName>:discrete 

```

For more information about DBOutputTable please refer to: [http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/index.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/index.html)