# runNamedQuery()

**URL:** <https://forum.inductiveautomation.com/t/runnamedquery/68073>\
**Category:** Ignition\
**Created:** [December 29, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/runnamedquery/68073 "2022-12-29T17:52:24Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [February 16, 2024, 6:33pm UTC](https://forum.inductiveautomation.com/t/runnamedquery/68073/12 "2024-02-16T18:33:38Z")

</div>

> [@Miguel\_Gomez](#):
>
> Sorry if these kind of very easy questions make the eyes of the Gods hurt

No need to apologize, it's much easier to help with proper details. Thanks for those.

Make sure you have configured the Named Query as scalar. Then what you need is:

```auto
reportValue = system.db.runNamedQuery("Select Report Number B", {})

```

> [@Miguel\_Gomez](#):
>
> the ignition page is down

No, its just in a different place now.

> **[system.db.runNamedQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runNamedQuery)**
>
> Runs a named query and returns the results.

See this post:

> [@Ignition User Manual updates](https://forum.inductiveautomation.com/t/ignition-user-manual-updates/85448):
>
> We’re launching a new look and feel for the Ignition User Manual next week, on February 15, 2024. This is a project that the IA Docs team has been working hard on for about a year now, and we’re looking forward to hearing your feedback! Here are a few of the features we’re most excited about: Better signposts to indicate the current version A more responsive layout that will adapt for mobile devices [2024-02-08\_10-38-28] Common resources more prominently featured in th…

---

_[View the full topic](https://forum.inductiveautomation.com/t/runnamedquery/68073)._