Historical Event Query

Current I am doing a historical event page which needed to do query to get the final result. So inside I have queried until area but inside have many different type of tags but I just want to query out tags that consist of ".ACTUAL_SPD". I have tried to use the operator "LIKE" but does not work.

Any recommended solution to overcome this issue?

Eg:

Total I can found 3 tags under an Area:

FFU_G01_01.ACTUAL_HRS, FFU_G01_01.ACTUAL_SPD, FFU_G01_03.FEEDBACK

Final Result I just to have tag with "ACTUAL_SPD" which is FFU_G01_01.ACTUAL_SPD

Top Replies

Richard Köhlerstrand 3 months ago +1

Hi! Could you post some more context in what you are doing? In general the LIKE operator should work but since you experience issues with it it might be good to get your full query, or at least what…

0 Kristian Dahle 3 months ago

You can try the following query:

Name like %.ACTUAL_SPD
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kar Hei Lau 3 months ago in reply to Kristian Dahle

Hi Kristian,
Tried this but unfortunately not working. I getting the result by using:
Name Like '_%.ACTUAL_SPD' but the font colour will be white instead of following the configured colour in event setting.

Appreciate if someone know why need to use '_%.ACTUAL_SPD' instead of '%.ACTUAL_SPD'
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Richard Köhlerstrand 3 months ago

Hi!

Could you post some more context in what you are doing?

In general the LIKE operator should work but since you experience issues with it it might be good to get your full query, or at least what tables or views you are working with, I have experienced some strange behavior when using an OPENQUERY.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel