SC_SNAPSHOT-2011-07-05/PowerEdition
In the sample below, if you click to sort on 'NOME' column header, the 'Direzioni Utente Caricamento' column header also displays the sorting arrow (but it is not being sorted on it, as you can in the MultiSortDialog in the attached image).
The latter is a foreign key which has also name NOME.
Is it a bug, or am I doing something wrong?
INVITI_SAMPLE.ds.xml:
DIREZIONI.ds.xml:
sample.jsp:
In the sample below, if you click to sort on 'NOME' column header, the 'Direzioni Utente Caricamento' column header also displays the sorting arrow (but it is not being sorted on it, as you can in the MultiSortDialog in the attached image).
The latter is a foreign key which has also name NOME.
Is it a bug, or am I doing something wrong?
INVITI_SAMPLE.ds.xml:
Code:
<DataSource ID="INVITI_SAMPLE" dataFormat="iscServer" serverType="sql" dbName="dbInviti" tableName="INVITI" validateRelatedRecords="true"> <fields> <field name="ID_INVITO" type="sequence" hidden="true" primaryKey="true"> <sequenceName>SEQUENCE_INVITI</sequenceName> <sqlType>decimal</sqlType> </field> <field name="DIREZIONE" type="text" length="255" title="Direzione Utente Caricamento" width="200" foreignKey="DIREZIONI.NOME"> <optionDataSource>DIREZIONI</optionDataSource> <displayField>NOME</displayField> <valueField>NOME</valueField> <sqlLength>255</sqlLength> <sqlType>varchar</sqlType> <uploadFieldName>Direzione</uploadFieldName> </field> <field name="COGNOME" type="text" length="255" width="120"> <sqlLength>255</sqlLength> <sqlType>varchar</sqlType> <uploadFieldName>Cognome</uploadFieldName> </field> <field name="NOME" type="text" length="255" width="120"> <sqlLength>255</sqlLength> <sqlType>varchar</sqlType> <uploadFieldName>Nome</uploadFieldName> </field> </fields> </DataSource>
Code:
<DataSource dbName="dbInviti" tableName="DIREZIONI" ID="DIREZIONI_SAMPLE" serverType="sql"> <fields> <field sqlType="varchar" sqlLength="255" name="NOME" length="255" type="text" required="true" primaryKey="true"></field> <field sqlType="varchar" sqlLength="256" name="DESCRIZIONE" length="256" type="text"></field> </fields> </DataSource>
Code:
<script type="text/javascript" charset="UTF-8"> <isomorphic:loadDS ID="INVITI_SAMPLE"/> <isomorphic:loadDS ID="DIREZIONI_SAMPLE"/> isc.ListGrid.create({ dataSource: INVITI_SAMPLE, autoDraw: true, autoFetchData: true, width: "100%", height: "100%" }); </script>
Comment