# Module SDK & DBQuery

**URL:** <https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117>\
**Category:** Ignition\
**Created:** [March 7, 2012, 8:19pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117 "2012-03-07T20:19:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\
**Post date:** [March 7, 2012, 8:19pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117/1 "2012-03-07T20:19:52Z")

</div>

I just started tinkering with this now, haven’t fully grasped how to use it yet so correct me if this is already possible …

I think it’d be pretty nifty to, instead of using …

```auto
query.addTable("Table");
query.addColumn("Column1");
query.addColumn("Column2");
// etc
```

… be able to use …

```auto
query.addTable("Table").addColumn("Column1").addColumn("Column2");
```

… kind of like a fluent API type deal.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 8, 2012, 12:21am UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117/2 "2012-03-08T00:21:40Z")

</div>

Yeah, I like this pattern as well. I don’t really see any reason it wouldn’t work on DBQuery other than that the author didn’t write it that way 😛

---

<div class="post-metadata">

**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\
**Post date:** [March 8, 2012, 6:08pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117/3 "2012-03-08T18:08:30Z")

</div>

🙂 … no worries, it was just on my mind while I was messing with it, figured I’d just put it out there. I like the idea of being able to break down a query programatically, pretty nifty.

Thanks!

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 8, 2012, 6:28pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117/4 "2012-03-08T18:28:23Z")

</div>

I modified the add\* methods to return ‘this’ so you can chain the calls together. You’ll see it in the 7.4 final release.

---

<div class="post-metadata">

**Author:** ![bryan\_cook](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\
**Post date:** [March 8, 2012, 6:38pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117/5 "2012-03-08T18:38:32Z")

</div>

[quote=“Kevin.Herron”]I modified the add\* methods to return ‘this’ so you can chain the calls together. You’ll see it in the 7.4 final release.[/quote]Sweet! I can scrap the DBQueryBuilder class I’ve got now 😃

Thanks!
