cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

List of items in Promotion request.

rnoah
8-Gravel

List of items in Promotion request.

All,


i have a commun request from the designers to export the list of items in specific promotion request to excel/csv file.


3 REPLIES 3

Rami


You can use report builder to create a promotion report then import this as a live link into Excel.


You can then filter this in Excel or you can drive report parameters in the URL direcltly from excel. Eg take the value a cell containing the context name for example and use that to pull a report for promotion notices in that particular context.


Regards


Darren

MikeLockwood
22-Sapphire I
(To:rnoah)

Report template attached.

[cid:image001.png@01CF3CFE.F8BE6220]
cadjett
1-Newbie
(To:rnoah)

The qml is nice, but if you want starter code:

public static Vector getDrawings (PromotionNotice promotionNotice) throws Exception {
Vector<epmdocument> drawings = new Vector<epmdocument>();
QueryResult pnMembers = MaturityHelper.service.getBaselineItems(promotionNotice);
while (pnMembers.hasMoreElements()) {
Baselineable member = (Baselineable)pnMembers.nextElement();
if (member instanceof EPMDocument && ( ((EPMDocument)member).getDocType().toString()).equals("CADDRAWING")){
drawings.add((EPMDocument)member);
}
}
return drawings;
}

Basically:

QueryResult members = MaturityHelper.service.getBaselineItems(promotionNotice);

I dont know how old this is. Just found it in the scrap pile.

L Jett

Top Tags