Good morning. Does anyone know of a way to query the database for the alias of a variable?
I'm not sure what exactly you mean by the alias of a variable but you can easily query the Variable table to get a list of all of the PDM variables:
select * from variable
The values of the data card contents are in the VariableValue table if that helps.
Can you describe more of what you're after and I know there are several good SQL writers who can answer.
Thanks for replying, Steve. I know how to obtain variables and variable values. I wondered how to get the aliases associated with the variable values that we set up in the data card selection pull-downs. Its one of the list options.
I can't remember the table off the top of my head but can find it in the morning when I get back to work. I'd guess it would be ListAlias or something like that.
Hope this helps!
Get PDM answers now using our Live Chat!
The cardlist value and its alias are all stored in CardListValues, you can query this table.
Retrieving data ...