I am working to create a workflow that does a flexclone of a volume/snapshot. I need to be able to present the user a list of snapshots on a volume and then clone the volume based on the user selected snapshot. I tried creating a user input variable of type Query, and used the following simple query for a test:
SELECT name
FROM storage.snapshot
When i click on test, i do not get any results at all. How can i query for a list of snapshots on a volume?
You need to enable Snapshot caching. Open the WFA web page and go to Tools > WFA Configuration. Go the the 'Other' tab and remove the 'storage.snapshot' entry.
Ok, it took me a little to figure it out because I haven't looked since the upgrade. Go to the Dictionary page and look at the 'Acquisition Enabled' column (should be the fifth column). Filter on False to see the Dictionary items that are not cached. Right Click on the Dictionary that you want to enable and select 'Enable Acquisition'