# Database parameter type not showing up (named query) **URL:** \ **Category:** Ignition\ **Tags:** namedqueries, database, ignition80\ **Created:** [April 7, 2021, 1:03pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339 "2021-04-07T13:03:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![sathianandan.dharmas](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Post date:** [April 7, 2021, 1:03pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/1 "2021-04-07T13:03:13Z")
Hi I’m trying to pass the ‘database name’ as a dynamic parameter when executing my named query but when I select the option on the Database Connection dropdown (Authoring page) I’m not seeing the database parameter type as explained in the manual. Has anyone had this same issue? I have multiple database connections configured on the gateway. Thanks a lot in advance! Sam ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [April 7, 2021, 4:42pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/2 "2021-04-07T16:42:04Z")
Make sure that you have saved your project after you set up the Named Query; named Query resources do not display changes to Perspective until after the Named Query resource has been saved. I verified that when I set up a Named Query with a parameterized database that the Named Query _binding dialog_ does supply the database as an expected parameter once the Named Query which expects the parameterized database is selected. My Named Query: ![Screen Shot 2021-04-07 at 9.37.32 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/2/7277858457eda13dc27e6aff718f518b5b803a11.png) Binding dialog after selecting `ExpectsDBAsParam`: ![Screen Shot 2021-04-07 at 9.38.00 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/7/a777c1c2f30cfdce515badfeb965edefbaef250c.png) ---
**Author:** ![sathianandan.dharmas](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Post date:** [April 8, 2021, 3:00pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/3 "2021-04-08T15:00:19Z")
Thank you @cmallonee, you have saved me once again. Not all heroes wear capes. In order to get the list of databases configured, I believe I can use the system.db.getConnections() ? Cheers Sam ---
**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\ **Post date:** [April 8, 2021, 3:08pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/4 "2021-04-08T15:08:36Z")
> [@sathianandan.dharmas](#): > > system.db.getConnections() Yes, that should get you a DataSet which contains information about the currently configured databases. ---
**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Post date:** [March 29, 2023, 1:19pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/5 "2023-03-29T13:19:13Z")
Have you seen Named Queries with the database parameter not binding? I split a project and now half my queries will not use the provided parameter. ---
**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\ **Post date:** [April 12, 2023, 4:53pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/6 "2023-04-12T16:53:00Z")
It seems that in the newer and newest versions if ANY parameter bound to a custom property is missing then the named query will complain that the database parameter is missing. This sends you on a tangent/wild goose chase. ---
**Author:** ![sathianandan.dharmas](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Post date:** [April 13, 2023, 3:42pm UTC](https://forum.inductiveautomation.com/t/database-parameter-type-not-showing-up-named-query/45339/7 "2023-04-13T15:42:41Z")
@jcaudle Thanks for that info, there has been multiple incidents of me diving into a rabbit hole with Ignition haha