Good morning. Does anyone know of a way to query the database for the alias of a variable?
Good morning. Does anyone know of a way to query the database for the alias of a variable?
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.
Julie
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.
hi julie，
The cardlist value and its alias are all stored in CardListValues, you can query this table.
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.