Ignition Perspective Radio buttons

Ignition
1

Hello!

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

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'

2

  • Edit your named query. Add parameter

    • Type: Value
    • Name: company
    • Data Type: String

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

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.
1 Like
3

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

Thanks for your solution Transistor.