cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Standard Attributes

Ilan_Mor
11-Garnet

Standard Attributes

Hi

Where can I find the actual attribute names of the standard attributes (PTC_BLN..../STR... fields)?

Is there any table (in the Database) that contains the Standard attributes field name with the Part Type and attributes name

See attached picture

 

Thank you,

Ilan.M

1 REPLY 1

Hi @Ilan_Mor 

 

Basically name of standard attributes stored in LWCFlexAttDefinition database table. please refer below query which give name of standard attribute and related type.

Example:

Note: I have created query for specific attribute:

SELECT LWCFlexAttDefinition.IDA3A5,LWCFlexAttDefinition.NAME AS"lOCAL ATTRIBUTE",lwctypedefinition.IDA2A2,lwctypedefinition.NAME AS"Type NAME"
FROM LWCFlexAttDefinition,lwctypedefinition
WHERE LWCFlexAttDefinition.IDA3A5=lwctypedefinition.IDA2A2
AND LWCFlexAttDefinition.NAME LIKE 'Local_Tst'

 

Screenshot:

 

Screenshot-Ref.png

 

Hope this helps to you.

Thanks,

Pravin Shinde

Top Tags