# Ignition Perspective Radio buttons

**URL:** <https://forum.inductiveautomation.com/t/ignition-perspective-radio-buttons/89290>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 23, 2024, 2:24pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-radio-buttons/89290 "2024-04-23T14:24:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 23, 2024, 2:24pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-radio-buttons/89290/1 "2024-04-23T14:24:40Z")

</div>

Hello!

in my ignition perspective proyect i have a table tblWorkRequest that get the data from a named query:

```python
SELECT WQ.WORKREQUEST A
...
...
...
WQ.REQUESTER = 'PRL' AND 
WQ.COMPANY = 'APPLE' 

```

i have a radio button group with 2 items, one selected wich value is APPLE and one not selected wich value is TIENDAS, when i click on the non selected radio button i want the WQ.COMPANY = 'APPLE' change to WQ.COMPANY = 'BANANA'

---

<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:** [April 23, 2024, 2:42pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-radio-buttons/89290/2 "2024-04-23T14:42:43Z")

</div>

- Edit your named query. Add parameter

- Edit your query to use the `:company` parameter. The `:` is important.

```python
SELECT WQ.WORKREQUEST A
...
FROM TableName
WHERE
    WQ.REQUESTER = 'PRL' AND 
    WQ.COMPANY = :company

```

- When you use the named query, use the _ **fx** _ button to bind the `company` parameter Value to the Radio Group component `props.value`.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 23, 2024, 2:57pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-radio-buttons/89290/3 "2024-04-23T14:57:03Z")

</div>

Works amazing, I was focus on a much more difficult solution.

Thanks for your solution Transistor.