API to get the product serial number effectivities associated with a WTPart

Hi Srinivas Morla

You may want to try this. I used this way back and sharing for your reference as it is. So you may need to modify and test it as per your business use case.

QueryResult qr2 = wt.effectivity.EffectivityHelper.service.getEffectivities(prt);    // Object of WTPart whose effectivity you want to delete...
while (qr2.hasMoreElements()) {
  Object obj = (Object) qr2.nextElement();
  System.out.println("Object-> " + obj.toString());
  if (obj.getClass().isAssignableFrom(wt.part.ProductSerialNumberEffectivity.class))
  {
       System.out.println( " Found Serial Numbered Effectivity" );
       wt.part.ProductSerialNumberEffectivity serial = (wt.part.ProductSerialNumberEffectivity)obj;
       String sRange=serial.getRange().getStart().toString().trim();
       System.out.println("Start Range is --->"+sRange);
       if (serial.getRange().getEnd().toString().trim() != null)
       {
            sRange += " - " + serial.getRange().getEnd().toString().trim();
       }
       else
       {
            sRange += " - " + "<open>"; 
       }
       // System.out.println(" Range: " + sRange); 
       // System.out.println(" Effectivity Type: " + serial.getEffContext());

       System.out.println("*** Trying to delete Serial Effectivity ***");
       PersistenceHelper.manager.delete(serial);     // be careful here. Your deleting something....
       System.out.println("*** SerialNumbered Effectivity for WTPart: "+prt.getNumber()+" is succesfully deleted ***");
 }
  else
  {
       System.out.println( "Effectivity other than Serial..." );
  }
}

I hope this helps you.

Regards,

Shirish