# Flex repeater with parameterized named query cannot bind

**URL:** <https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059>\
**Category:** Ignition\
**Created:** [February 12, 2022, 7:25am UTC](https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059 "2022-02-12T07:25:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [February 12, 2022, 7:25am UTC](https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059/1 "2022-02-12T07:25:05Z")

</div>

I have a named query with a fixed table name, and it executes properly to list all row in the MySQL table:

 ![ig_flexrepeat_namedquery_fixed_2022-02-12 at 1.12.40 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7b483539454b1784f9b79590666b60670bddcc54.jpeg)

I then parameterize the same query so that the table name is dynamic, and it also works:

 ![ig_flexrepeat_namedquery_param_2022-02-12 at 1.12.16 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/6/c6f5f26c10081f4092c3c2f8fb69e52b669a55b2.jpeg)

When I use the named query in a flex repeater, the query with the fixed table name works:

 ![ig_flexrepeat_namedquery_fixed_2022-02-12 at 1.15.29 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a0924aaaee7b28adc4f3fae8b1493d2ef998111.jpeg)

When I use the parameterized name query, the binding fails:

 ![ig_flexrepeat_param_2022-02-12 at 1.19.20 AM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a8ba5621a62349c24ba343b1f09002fd4b02661.jpeg)

Can anyone explain how to make a parameterized table name in a named query work with a flex repeater?

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [February 12, 2022, 9:19am UTC](https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059/2 "2022-02-12T09:19:20Z")

</div>

It’s unlikely that you can concatenate a string and the QueryString like that.

Try passing in the complete table name in the OpenBallotTable query variable.

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [February 12, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059/3 "2022-02-12T16:03:30Z")

</div>

Thanks for the reply. Passing in the full table name does not fix it. The binding does not work.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [February 12, 2022, 4:38pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-with-parameterized-named-query-cannot-bind/56059/4 "2022-02-12T16:38:33Z")

</div>

You were right. I was wrong. You can do a partial table-name QueryString.

![Named query QueryString](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/1/510eab12a208e2b17fea070c4f2f14cf0281c338.png)

_Figure 1. (1) I’m accessing the **config** table. (2) Enclose the QueryString in single quotes. (3) It works!_

If you used the _ **fx** _ to use an expression or property Ignition will sort it out for you. I think you just need it for directly entered strings. It’s a bit confusing when the Named Queries Testing function doesn’t require them.