Cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Search for "precise" assemblies in Tc

Gears Phenom Gears Phenom
Gears Phenom

Using Teamcenter 11.2.3, with NX 11, I would like to search the database and see which assemblies have been saved as "precise".  Is this possible, and if so, what search should I use?

-Dave
NX 11 | Teamcenter 11 | Windows 8.1
4 REPLIES

Re: Search for "precise" assemblies in Tc

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

You can try this one from GTAC (use at your own risk):

<?xml version="1.0" encoding="utf-8"?>
<!-- GENERATED BY: PLM XML SDK 7.0.4.418 -->
<plmxml_bus:PLMXMLBusinessTypes xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema" xmlns:plmxml_bus="http://www.plmxml.org/Schemas/PLMXMLBusinessSchema" language="en-us" time="14:12:16" schemaVersion="6" author="Teamcenter V11000.2.3.30_20161205.00 - gtacdba@IMC--1958943558(-1958943558)" date="2017-04-21" languages="en-us fr-fr de-de it-it es-es pt-br">
   <plmxml_bus:SavedQueryDef id="id1" name="New_Precise_BVR" nameRef="#id2" descriptionTextRef="#id3" queryFlag="0" queryClass="PSBOMViewRevision">
      <Description>Find StructureMap Revision(s)</Description>
      <ApplicationRef application="Teamcenter" label="hIShP2pq4OsTrC" version="hIShP2pq4OsTrC"></ApplicationRef>
      <plmxml_bus:QueryClause id="id4" stringValue="SELECT qid FROM PSBOMViewRevision WHERE &quot;is_precise&quot; = &quot;${is_precise = }&quot; AND &quot;object_name&quot; = &quot;${object_name = }&quot; AND &quot;object_type&quot; = &quot;${object_type = }&quot;"></plmxml_bus:QueryClause>
   </plmxml_bus:SavedQueryDef>
   <plmxml_bus:Text id="id2" primary="en-us"></plmxml_bus:Text>
   <plmxml_bus:Text id="id3" primary="en-us"></plmxml_bus:Text>
</plmxml_bus:PLMXMLBusinessTypes>

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Search for "precise" assemblies in Tc

Gears Phenom Gears Phenom
Gears Phenom

Thanks @RandyEllsworth

 

Never having imported a search, where would i start?

-Dave
NX 11 | Teamcenter 11 | Windows 8.1

Re: Search for "precise" assemblies in Tc

Gears Phenom Gears Phenom
Gears Phenom
Actually found the help files, and a guy that had Tc training, we got it imported.

Thanks again!!
-Dave
NX 11 | Teamcenter 11 | Windows 8.1

Re: Search for "precise" assemblies in Tc

Solution Partner Experimenter Solution Partner Experimenter
Solution Partner Experimenter

import a query on TC commandline:

 

plmxml_import.exe -u=infodba -p=***** -g=dba -xml_file=query.xml -import_mode=overwrite