-
Re: SQL to get Variable Alias
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.
-
Re: SQL to get Variable Alias
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
-
Re: SQL to get Variable Alias
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.
-
-
-
-
Re: SQL to get Variable Alias
hi julie，
The cardlist value and its alias are all stored in CardListValues, you can query this table.
