Geolus How to display Teamcenter attributes in NX Shape Search

2019-04-26T10:33:29Z
Geolus Install Geolus Data Management Geolus Indexer

Summary


Details

--------------- 
Tools ==> Shape Search... using Type Attribute 


displays the two default attributes: 
File Name 
Part Number


If you are running NX in managed mode you would like to also be able to use the defined Teamcenter attributes for filtering.

Solution

Change values for the T_ATTRIBUTE_PROPERTIES column NX_MAPPING that is used for NX Shape Search from None to your used attribute names.


To achieve this for all default T
Find below two examples for the different databases supported by Geolus to define the default Teamcenter attributes defined in extractData.config of the Geolus TeamcenterIndexer.

Using a DB, MySQL and Oracle database, you can create and run a SQL script with the following content.


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision UID' WHERE FIELD_NAME='ATTRIBUTE_NAME_00';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item ID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_01';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Name' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_02';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_03';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision Owner 
Username' WHERE FIELD_NAME='ATTRIBUTE_NAME_04';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Description' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_05';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision Last 
Modified' WHERE FIELD_NAME='ATTRIBUTE_NAME_06';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='JT Dataset UID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_07';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='NX Dataset UID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_08';


UPDATE GEOLUS.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Owning Site' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_09';


------------------------------------------------------------------------------ 
-- Uncomment COMMIT entry for oracle database usage 
------------------------------------------------------------------------------


-- COMMIT;


------------------------------------------------------------------------------ 
-- Uncomment TERMINATE entry for DB2 database usage 
------------------------------------------------------------------------------ 
-- TERMINATE;


For a MSSQL Geolus database create and run a script with the following content.


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision UID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_00';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item ID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_01';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Name' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_02';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_03';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision Owner 
Username' WHERE FIELD_NAME='ATTRIBUTE_NAME_04';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Description' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_05';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Item Revision Last Modified' 
WHERE FIELD_NAME='ATTRIBUTE_NAME_06';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='JT Dataset UID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_07';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='NX Dataset UID' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_08';


GO


UPDATE dbo.T_ATTRIBUTE_PROPERTIES SET NX_MAPPING='Owning Site' WHERE 
FIELD_NAME='ATTRIBUTE_NAME_09';


GO



Notes and References


Hardware/Software Configuration

Platform: all
OS: n/a
OS Version: n/a
Product: GEOLUS
Application: GEOLUS_INSTALL
Function: INSTALL&CONFIG
Product: NX
Application: KDA
Function: SHAPESEARCH

Ref: 001-1945296

KB Article ID# PL8009565

Contents

SummaryDetails

Associated Components

Installation and Configuration