I have a User Input Variable that shows a list of snapshots for a volume based off of a SQL query. I also have defined a Constant that contains the name of the volume we need a list of snapshots for. I am using a Constant because the end user should not be able to select another volume. How can i reference the constant in the SQL Query? I can reference a User Input Variable using the following, but how to I reference the constant?
SELECT snapshot.name
FROM storage.snapshot, storage.volume
WHERE
volume_id = volume.id
AND volume.name = ${source_volume}
I want to put a contant in place for ${source_volume}. I know i could just do 'myVolumeName' but I'd rather reference my already defined constant
Thanks
Sean