If function in mysql query

Ignition
, , , ,
1

Hey guys! Can someone help me out?
I have a problem with if function in mysql query (I want to create something like a switch)

MicrosoftTeams-image (1)
MicrosoftTeams-image (1)1579×718 70.6 KB

SELECT concat(COUNT(*)) FROM {Root Container.NumberOfNumber 1.Table}
if ({Root Container.Tab Strip.selectedTab}==‘Ethernet’ then concat(where ({Root Container.NumberOfNumber 1.Where} LIKE ‘%{Root Container.NumberOfNumber 1.Like}%’))
else
concat(where ({Root Container.NumberOfNumber 1.Where} LIKE ‘%{Root Container.NumberOfNumber 1.Like}%’)
AND ({Root Container.NumberOfNumber 1.TimeTable} Between ‘{Root Container.NumberOfNumber 1.StartTime}’ AND ‘{Root Container.NumberOfNumber 1.EndTime}’)))
end

3

The expression language if() is not available in the SQL Query form. You can only reference tags and property bindings. Try creating a custom property on your component called queryString and use the expression language if() to return your different query strings. Then in your SQL Query you can just reference
{Root Container.NumberOfNumber 1.queryString}

5

?how we can do it?

6

maybe we can use case function?

7

Sure. You can use a case or nested if. Whatever makes sense for you.

Here’s a if example

image
image1042×598 71.4 KB

Demo:

1 Like
8

Thank u so much!!! Works perfectly!

9

Thanks a lot! I understood what you meant 20-30 minutes after your answer. This is brilliant! Thank you again!