Skip to main content
A
Anonymous
November 4, 2015
Question

Download Latest version/iteration of EPM document

  • November 4, 2015
  • 4 replies
  • 3211 views

Hi Windchillers,

Iam trying to download the latest copy of EPM document by using the following code; but the content downloaded is non latest. What could be the issue :

package com.phoenix.listen;

import wt.content.ApplicationData;

import wt.content.ContentHelper;

import wt.content.ContentItem;

import wt.content.ContentServerHelper;

import wt.content.FormatContentHolder;

import wt.epm.EPMDocument;

import wt.fc.PersistenceHelper;

import wt.fc.QueryResult;

import wt.query.QuerySpec;

import wt.query.SearchCondition;

import wt.util.WTException;

public class EPM_Doc_Pass {

  public static boolean downloadFile(EPMDocument epmDoc, String downloadDirectory) {

    boolean result=false;

  ContentItem primaryContent=null;

  String wtTemp = System.getProperty("wt.temp");

  String fullName = wtTemp + "//" + downloadDirectory + "//" + epmDoc.getCADName();

  String Docname = epmDoc.getName();

  try {

  // EPMDocument

  if ( !epmDoc.isGeneric() ) {

  QuerySpec qs = new QuerySpec (EPMDocument.class);

  

   qs.appendWhere(new SearchCondition(EPMDocument.class,EPMDocument.NAME,SearchCondition.LIKE,Docname));

   qs.appendAnd();

   qs.appendSearchCondition (new SearchCondition (EPMDocument.class, "iterationInfo.latest", SearchCondition.IS_TRUE));

 

   QueryResult qr = PersistenceHelper.manager.find(qs);

                              

     while (qr.hasMoreElements()) {

               EPMDocument epmDoc1= (EPMDocument)qr.nextElement();

               System.out.println(epmDoc1.getCADName()+ epmDoc1.getVersionDisplayIdentifier()+epmDoc1.getIterationDisplayIdentifier());

               epmDoc1 = (EPMDocument) ContentHelper.service.getContents( epmDoc1 );

               primaryContent = ContentHelper.getPrimary((FormatContentHolder)epmDoc1);

               if ( primaryContent!=null )

               {

               System.out.println("downloadFile >>> EPMDocument, writeContentStream : " + fullName );

               ContentServerHelper.service.writeContentStream( (ApplicationData)primaryContent, fullName );

               result=true;           

  

}

              

                 

    }

  }

  }

  catch (Exception _e) {

  _e.printStackTrace();

  return false;

  }

  System.out.println("downloadFile >>> OUT...");

  return(result);

  }

}

4 replies

K
kpritchard1-Visitor
1-Visitor
November 4, 2015

My thinking is that your query is getting the latest iteration of each version.  If it's me I'm probably querying for EPMDocumentMaster and getting the ordered list of versions (allVersionsOf()) from there

C
CaitlinWheeless1-Visitor
1-Visitor
November 4, 2015

Just looking at other download samples, should this:

   qs.appendWhere(new SearchCondition(EPMDocument.class,EPMDocument.NAME,SearchCondition.LIKE,Docname));

   qs.appendAnd();

   qs.appendSearchCondition (new SearchCondition (EPMDocument.class, "iterationInfo.latest", SearchCondition.IS_TRUE));

Be this:

qs.appendWhere(new SearchCondition(EPMDocument.class,EPMDocument.NAME,SearchCondition.LIKE, Docname));

qs.appendAnd();

qs.appendWhere(new SearchCondition(EPMDocument.class, "iterationInfo.latest", "TRUE"));

Y
ybagul1-Visitor
1-Visitor
November 4, 2015

Can you replace downloadFile method with following method and try? I have not tested this code, but it should work. I guess this is what Keir Pritchard suggested.

public static boolean downloadFile(EPMDocument epmDoc, String downloadDirectory) {

  boolean result=false;

  ContentItem primaryContent=null;

  String wtTemp = System.getProperty("wt.temp");

  String fullName = wtTemp + "//" + downloadDirectory + "//" + epmDoc.getCADName();

  String Docname = epmDoc.getName();

  try {

  // EPMDocument

  if ( !epmDoc.isGeneric() ) {

  QueryResult epmQueryResult = VersionControlHelper.service.allVersionsOf(epmDoc.getMaster());

  EPMDocument epmDoc1 = null;

  while(epmQueryResult.hasMoreElements()){

  epmDoc1 = (EPMDocument) epmQueryResult.nextElement();

  break;

  }

  System.out.println(epmDoc1.getCADName()+ epmDoc1.getVersionDisplayIdentifier()+epmDoc1.getIterationDisplayIdentifier());

  epmDoc1 = (EPMDocument) ContentHelper.service.getContents( epmDoc1 );

  primaryContent = ContentHelper.getPrimary((FormatContentHolder)epmDoc1);

  if(primaryContent!=null){

  System.out.println("downloadFile >>> EPMDocument, writeContentStream : " + fullName );

  ContentServerHelper.service.writeContentStream((ApplicationData)primaryContent, fullName);

  result=true;

  }

  }

  } catch (Exception _e) {

  _e.printStackTrace();

  return false;

  }

  System.out.println("downloadFile >>> OUT...");

  return(result);

  }

R
rmk1-Visitor
1-Visitor
November 12, 2015

Hi

Please Try the following code,

package ext.test;

import wt.epm.EPMDocument;

import wt.epm.EPMDocumentMaster;

import wt.fc.PersistenceHelper;

import wt.fc.QueryResult;

import wt.pds.StatementSpec;

import wt.query.QuerySpec;

import wt.util.WTException;

public class EPMLatest {

  public static void main(String[] args) throws WTException {

  // **************************************************************

  // Retrieve List of EPMDocumentMasters

  // **************************************************************

  QuerySpec qs = new QuerySpec(EPMDocumentMaster.class);

  EPMDocumentMaster master = null;

  QueryResult qr = PersistenceHelper.manager.find((StatementSpec) qs);

  System.out.println("Number of EPM Document Masters: " + qr.size() + "\n\n");

  while (qr.hasMoreElements()) {

  master = (EPMDocumentMaster) qr.nextElement();

  System.out.println("***** Name ->"+ master.getName());

  EPMDocument latest = (EPMDocument)wt.vc.VersionControlHelper.service.allVersionsOf(master).nextElement();

  String versionLatest = wt.vc.VersionControlHelper.getVersionIdentifier(latest).getValue();

  System.out.println("******** Identity -> "+ latest.getIdentity());

  System.out.println("******** Latest Version -> "+ versionLatest);

  System.out.println("******** Latest Iteration -> "+ latest.getIterationDisplayIdentifier());

  System.out.println("******** State of latest version of latest iteration -> "+latest.getState());

  // Use Here to download the Content

  primaryContent = ContentHelper.getPrimary((FormatContentHolder)latest);

               if ( primaryContent!=null )

               {

               System.out.println("downloadFile >>> EPMDocument, writeContentStream : " + fullName );

               ContentServerHelper.service.writeContentStream( (ApplicationData)primaryContent, FileFullName(C:/abc.prt) );

  }

  }

}

BR

MKR

    Terms & ConditionsAccessibility statement