This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a process I'm building out right now that is going to accept user input. This user input will be a drop-down with data derived from a SQL query. However, the query to get that data uses an "ID" field as a filter, and I am also in the process of migrating to a new "ID". Is there any way to configure this so that it will be dynamic inside of these interface tools, or will I have to update this query manually once this transition has occurred?
I have tried using a User Constant and it seems that since these are evaluated at runtime, it won't function for a drop down, but I wasn't sure if anyone in the Community had any more luck.