How to query db table to get value and use that value as input parameter in one of the jobs in workflow


I have scenario like i need to query a sql server table for example and use that particular column value as circleci parameter to set as parameter for my workflow. Is that possible. Is there any example snippet where I can achieve this

Parameters are something that can only be set at the time a yml script is executed, so to dynamically pass a value you have currently 2 options.

One of the ongoing complications is that parameters and environment variables are very separate things in the scripting language - so you can not use environment variables to provide a value to commands that will accept parameters.