I'm trying to duplicate the html_grid1_multi_bom for another purpose, but it's brings back no results. Here is a snippet of my code.
var this_item = document.thisItem;
var dd_parm0 = this_item.getProperty("_contact", "");
var sql1 = "<Item type='Part' action='get'><id condition='in'>(SELECT innovator.PART.ID FROM innovator.MIN_PORTAL_CONTACT INNER JOIN innovator.MIN_CONTACT ON innovator.MIN_PORTAL_CONTACT._CONTACT = innovator.MIN_CONTACT.id INNER JOIN innovator.MIN_SOFTWARE_CATALOG ON innovator.MIN_CONTACT.PROGRAM = innovator.MIN_SOFTWARE_CATALOG.PROGRAM AND innovator.MIN_CONTACT.PRODUCT = innovator.MIN_SOFTWARE_CATALOG.PRODUCT AND innovator.MIN_CONTACT.MODEL = innovator.MIN_SOFTWARE_CATALOG.MODEL INNER JOIN innovator.PART ON innovator.MIN_SOFTWARE_CATALOG.PART_NUMBER = innovator.PART.ID WHERE (innovator.MIN_SOFTWARE_CATALOG.SOFTWARE_TYPE = N'MST') AND (innovator.MIN_SOFTWARE_CATALOG.IS_CURRENT = '1') AND (innovator.PART.IS_CURRENT = '1') AND (innovator.MIN_PORTAL_CONTACT._CONTACT = " + dd_parm0 + "))</id></Item>"
var updateReturn = innovator.applySQL(sql1);
var resItem = innovator.newItem("Part", "PE_GetMultilBom");
resItem.setID(updateReturn);
resItem = resItem.apply();
