How to add Regex to a TextBox Variable and use it inside a Query to visualize data from Elasticsearch

[yosiasz]

Continuing this thread. So @roleyroley did you try the above approach and did it not work for you? if you do not want to use the above recommendation or it did not work for you, from your Serial Number what part of it do you want to extract and concatenate

Using Regex/Substring of a Template Variable and adding it to a Query Elasticsearch db

Grafana Version - Grafana v10.0.2 (b2bbe10fbc) Operating System - Windows 11 What are you trying to achieve - I want to use Regex / Substring operation on a Template Variable called $SerialID How are you trying to achieve it - 1. I created a TextBox Template variable with the name SerialID which takes a 16 character user input. 2. The database source is Elasticsearch logs. 3. I need to extract substring from index 5-12 of the 16 character $SerialID value, and then use it to query a field …