Anonymous

XSQL
----
SELECT SUBSTR(vc_projectcertification.name, 0, 20) as name, vc_projectcertification.vc_projectcertification_id as id
FROM vc_projectcertification 
left join c_project on vc_projectcertification.c_project_id = c_project.c_project_id
left join vc_projectversion on c_project.c_project_id = vc_projectversion.c_project_id
where vc_projectversion.vc_projectversion_id = to_number(?)

JAVA
----
SeeDetailData[] datosUnCombo = SeeDetailData.selectCertification(this, strVersionId);
  
comboBMeasurement = new SeeDetailData[dataMeasurement.length][];

for (int i=0; i<dataMeasurement.length; i++) {
    comboBMeasurement[i] = datosUnCombo;
}

xmlDocument.setData("structureMeasurement", dataMeasurement);

xmlDocument.setDataArray("reportVC_Projectcertification_ID_B_Detail", "liststructure", comboBMeasurement);

XML
---
<FIELD id="reportVC_Projectcertification_ID_B" attribute="value" replaceCharacters="htmlPreformated">bm_cert_id</FIELD>
<SUBREPORT id="reportVC_Projectcertification_ID_B_Detail" name="reportVC_Projectcertification_ID_B_Detail" report="org/openbravo/erpCommon/reference/List">
  <ARGUMENT name="parameterListSelected" withId="id"/>
</SUBREPORT>

HTML
----
<select name="inpvcProjectcertificationIdxx" onfocus="inpBudgetId.value=xx;inpFoco.value=this.name;CambioFilaMedicionesBudget();" onchange="inpPosMBudget.value=xx" id="reportVC_Projectcertification_ID_B">
<option value=""></option>
<div id="reportVC_Projectcertification_ID_B_Detail"></div>
</select>