Quick question. I have an array of 5 assets [‘Pump 1’, ‘Pump 2’, ‘Pump 3’, ‘Pump 4’, ‘Pump 5’] which are part of the variable ${asset}. What I’d like to be able to do is access each of the selected assets individually.
In the database I’d use something like;
SELECT ARRAY[${asset}])[1]
Which gives me the first asset, and if were to try and get asset 6 (which doesn’t exist) then I’d get a null back (and would need to handle that in the dashboard metric).
Is it possible to access the elements directly without having to bounce them off the database?