Named Query Parameter Value

Ignition
,
1

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

2

i got it
image

image
image1617×223 21.6 KB

3

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.

4

i see it now, thanks.

you dont know until you know, lol