How to get values in XSLT sheet in Reports using method
Hi community,
I'm working on one report generation where I need to use the 'where used' feature . So I created a method which in which I use SQL query to get my result But with the following code I can get XML containing my desired output only.
I'm stucked how to access that (source_id) value in sheet now other part_no and name I can get in report.
Here is my code:
var aras = new top.Innovator();
var ItemId = this.getID();
var qryItem = new Item(" Part","get");
qryItem.setProperty("id",ItemId);
//qryItem.setAttribute("select","part_number,revision,name");
var BPItem = qryItem.apply();
if (BPItem.isError()) return top.aras.getResource("Baxter Part", "pr_methods.save_item_first");
var baxter_part_number = BPItem.getProperty("part_number");
projectItem2 = BPItem.node.appendChild(BPItem.node.ownerDocument.createElement("Relationships"));
var sql = " SELECT pb.SOURCE_ID,pb.related_id from innovator.[PART_BOM] pb INNER join innovator.[PART] smp on smp.ID=pb.RELATED_ID where smp.ID ='"+ItemId+"'" ;
var tmpDom = aras.newXMLDocument();
var res = aras.applySQL(sql);
tmpDom.loadXML(res);
var allAct = tmpDom.selectNodes("//Item/source_id");
for (var i=0;i<allAct.length;i++)
{
var curAct = allAct[i];
var source_id = curAct.appendChild(curAct.ownerDocument.createElement("source_id"));
source_id.setAttribute("select","source_id");
}
var report = aras.getItemByKeyedName("Report"," Where Used");
var style = report.getProperty("xsl_stylesheet");
var html = BPItem.applyStylesheet(style,"text");
return html;
