List of Part Description Maps (SQL)

Q: Is there a way to get an export of the Part Description Maps.

A: There is not currently a report built into AceMapper, but in some cases you can use a SQL Query to get a list of the maps. If you haven’t included Positions, Attributes or Comments in the maps, you can use this procedure:

1. Find the DocumentID using this query

SELECT [DocumentTitle], [DocumentID] FROM [Document]

2. Change the ?? below to the DocumentID found in step 1.

SELECT distinct pd.PartDescriptionNm, pt.AAIAPartTypeID, pt.AAIAPartTypeNm, pdm.MfrLabel  
  from PartDescription pd   
  join dbo.AAIAPartDescrMap pdm on pdm.PartDescriptionID = pd.PARTDESCRIPTIONID  
  join AAIAPartType pt on pt.AAIAPartTypeID = pdm.AAIAPartTypeID  
  where DocumentID = ??  
  order by PartDescriptionNm