Anonymous

XSQL
----
<SqlMethod name="selectCertification" type="preparedStatement" return="multiple" >
    <SqlMethodComment></SqlMethodComment>
    <Sql>
    <![CDATA[
	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(?)
    ]]>
    </Sql>
 <Parameter name="vcProjectversionId"></Parameter>
</SqlMethod>

<SqlMethod name="selectCertification2" type="preparedStatement" return="multiple" >
    <SqlMethodComment></SqlMethodComment>
    <Sql>
    <![CDATA[
	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(?)       
    ]]>
    </Sql>
 <Parameter name="vcProjectversionId"></Parameter>
</SqlMethod>

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

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

xmlDocument.setData("structureMeasurement", dataMeasurement);
xmlDocument.setData("structureCertification", dataCertification);

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

XML
---
<FIELD id="reportVC_Projectcertification_ID_B" attribute="value" replaceCharacters="htmlPreformated">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="bm_cert_id"/>
</SUBREPORT>

<FIELD id="VC_Projectcertification_ID_C" attribute="value" replaceCharacters="htmlPreformated">id</FIELD>
<SUBREPORT id="reportVC_Projectcertification_ID_C_Detail" name="reportVC_Projectcertification_ID_C_Detail" report="org/openbravo/erpCommon/reference/List">
  <ARGUMENT name="parameterListSelected" withId="cm_cert_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>

<select name="inpvcProjectcertificationIdCxx" id="VC_Projectcertification_ID_C"   onfocus="inpCertificationId.value=xx;inpFoco.value=this.name;CambioFilaMedicionesCertification();" onchange="inpPosMCertification.value=xx">
<option value=""></option>
<div id="reportVC_Projectcertification_ID_C_Detail"></div>
</select>