# QueryTag Query is failing

**URL:** <https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884>\
**Category:** Ignition\
**Created:** [January 21, 2014, 11:39pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884 "2014-01-21T23:39:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [January 21, 2014, 11:39pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/1 "2014-01-21T23:39:06Z")

</div>

I have a query that works fine in MSSQL, when i put it into a QueryTag using tags or with hard coded values it fails. I didnt see anything in the docs so I was hoping someone could shed some light, thanks!

This fails in a Query Tag

`SELECT ur.rollID
FROM upe_rolls AS ur
INNER JOIN upe_lot_numbers AS uln ON uln.lotNumID = ur.lotNumID
WHERE uln.lotNumber = 'LOTTEST3' AND ur.rollNum = 1`

This fails in a Query Tag

`SELECT ur.rollID
FROM upe_rolls AS ur
INNER JOIN upe_lot_numbers AS uln ON uln.lotNumID = ur.lotNumID
WHERE uln.lotNumber = '{[.]E1_LotNum_1}' AND ur.rollNum = {[.]E1_RollNum_1}`

but it works fine in MSSQL, any ideas? Thanks

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [January 22, 2014, 5:14pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/2 "2014-01-22T17:14:14Z")

</div>

Right-click on the Tag and check out its Tag Diagnostics:

![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c1c3e0f33eccc1244ee9dc2693b63df8123df33e.jpeg)

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [January 22, 2014, 6:38pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/3 "2014-01-22T18:38:04Z")

</div>

Thanks! I don’t know how I missed that option!

It said I did not have a default database selected. But… Default was selected and that is what the rest of the app is using, either way. I made the change and its working now, thanks!

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [January 23, 2014, 5:52am UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/4 "2014-01-23T05:52:08Z")

</div>

Tags cannot have a default database connection because they are shared by projects. Client tags are an exception.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [January 23, 2014, 12:54pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/5 "2014-01-23T12:54:41Z")

</div>

Thanks for the clarification, now it makes sense!

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [January 27, 2014, 7:02pm UTC](https://forum.inductiveautomation.com/t/querytag-query-is-failing/7884/6 "2014-01-27T19:02:32Z")

</div>

Hi,

That answer is half correct. They’re not in a project, so they don’t share the project’s default. However, it is possible to set a “default” connection if you log into the gateway, and go to SQLTags\>Realtime, and edit the provider.

Anyhow, glad you got it working.

Regards,