# Named Query Parameter Value

**URL:** <https://forum.inductiveautomation.com/t/named-query-parameter-value/52741>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [November 4, 2021, 6:28pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-value/52741 "2021-11-04T18:28:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [November 4, 2021, 6:28pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-value/52741/1 "2021-11-04T18:28:43Z")

</div>

Good day all, I am needing some help, I have this query here:  
SELECT TOP 6  
– \*  
TSFO\_MachineNumber AS ‘Twister’  
,TSFO\_DonLocation AS ‘Pot\_or\_Creel’  
,TSFO\_DeliveryByDateTime AS ‘DeliverBy’  
,TSFO\_BuggyNumber AS ‘Buggy’  
,TSFO\_DelayReason AS ‘Delay’  
FROM  
SHAW\_TwistingOrders  
WHERE  
– TSFO\_DeliveryByDateTime \< ‘2021-11-04 08:00:00’  
TSFO\_MachineNumber like ‘V028%’  
AND TSFO\_DeliveryByDateTime \> getdate()  
– AND TSFO\_MissionStatus != ‘OK’  
ORDER BY TSFO\_DeliveryByDateTime ASC

The line that has TSFO\_Machinenumber like ‘V028%’ i want to make the 28 a varible parameter that i can input any number there and call up any machine. I.E., 22 or 33.

Any help is great Thanks

---

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [November 4, 2021, 6:42pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-value/52741/2 "2021-11-04T18:42:41Z")

</div>

i got it  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/e/0e23cebd09307ea190a39beef9cedfaeaee7da5a.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/5/4594b2cb148ac680e2477244aab7fbc2c249546a.png)

---

<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:** [November 4, 2021, 6:53pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-value/52741/3 "2021-11-04T18:53:14Z")

</div>

Tip: there’s a **"** code formatting button on the editor toolbar that will preserve indentation and line breaks. It means we can copy the code into our answers or consoles and edit it.

---

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [November 4, 2021, 6:57pm UTC](https://forum.inductiveautomation.com/t/named-query-parameter-value/52741/4 "2021-11-04T18:57:05Z")

</div>

i see it now, thanks.

you dont know until you know, lol

```auto

```