I have a dashboard that I’m trying to filter based on the first 2 letters of a job number. In the View option, under BAQ options,how do I setup the where clause to only look at the first 2 letters when filtering? I’ve tried Like, I’ve tried = SP%, but nothing seems to work. I’m on Kinetic 2023.2.12 on premises.
I tend to use classic and not browser based, but I assume it’s the same on the BAQ.
for your example, I would change = to LIKE and SP% to CONCAT(‘SP’,‘%’)
Hannah’s is better. Use that one.
LIKE works as well.
2 Likes
Thank you all! Using LIKE worked for me. Appreciate the help:-)
1 Like
Why is “F” the first letter you chose?? 
1 Like
That is a firm job. One might even say stiff.
F
3 Likes