Hello! I've constructed dashboard with table showing some results. Lets say it has 4 columns: time, host, eventdescription, details I also added one Text input field, which I want to use to narrowing my number of returned rows (when I write XXYY in that field, I want to only show rows having XXYY characters in 'details' column) So Im trying to add that fields name (using its token name) into Where clause. Unfortunatelly I don't know how to do it correctly, The very ending part of my query is: | eval details=DeviceName.", EventID=".EventID | sort host, -time, -details | where details LIKE $text_kYVQjHrH$ | table time, host, DeviceName, details When I put in my TextField: "%XXYY%" then everything is OK, I see only rows with XXYY in column 'details'. When I put in my TextField: "%%" then everything is OK, I see every row, no filtering then. But I want to make it more userfriendly, so to get rid of "% and %" from my Input Field. So for example I tried: | where details LIKE "%.$text_kYVQjHrH$.%" (concatenation with dots dont work) or other versions like: | where details LIKE ""%".$text_kYVQjHrH$."%"" or with some escaping characters before " and nothing is working for me 😞 I also tried to | eval that whole concatenated string earlier, also problems. Can you help? Best regards!
... View more