Announcement

**Isomorphic** · 8 Dec 2016, 02:03

Could you please post the DataSource? We want to see how this fetch is arising. You can email it to support@isomorphic.com if it has confidential content that you don't want to post on the public forums

**claudiobosticco** · 8 Dec 2016, 02:47

Here it is:

Code:

<DataSource xmlns:fmt="WEB-INF/" xmlns="http://www.smartclient.com/schema"
            ID="JTK_NOMI_TICKET"
            serverType="sql"
            dbName="dbJpcEP"
            schema="DBSALES"
            tableName="JTK_NOMI_TICKET"
            allowAdvancedCriteria="true"
            requiresAuthentication="true"
            dropExtraFields="false"
>
    <fmt:bundle basename="i18nMessages" encoding="utf-8"/>
    <fields>
        <field sqlType="decimal" primaryKey="true" name="ID_REC" type="sequence" hidden="true" sequenceName="SEQUENCE_ID_JTK"/>
        <field name="NOME" type="capitalizeFullyTrimText" required="true" length="100"/>
        <field name="COGNOME" type="capitalizeFullyTrimText" required="true" length="100"/>
        <field name="DATA_NASCITA" type="date" required="true"/>
        <field name="EMAIL" type="trimText" length="200"/>
        <field name="ID_NAZIONE_FK" type="integer" foreignKey="JPC_NAZIONI.ID_REC" joinType="outer" required="true" displayField="NAZIONE"/>
        <field name="NAZIONE" type="text" includeFrom="JPC_NAZIONI.NOME"/>
        <field name="ID_COMUNE_FK" type="integer" foreignKey="JPC_COMUNI.ID_REC" joinType="outer" displayField="COMUNE">
             <validators>
                 <validator type="required" stopIfFalse="true" dependentFields="ID_NAZIONE_FK">
                     <applyWhen operator="and">
                         <criteria>
                             <criterion fieldName="ID_NAZIONE_FK" operator="equals" value="118"/>
                         </criteria>
                     </applyWhen>
                 </validator>
             </validators>
        </field>
        <field name="COMUNE" type="text" includeFrom="JPC_COMUNI.NOME"/>
        <field name="LOCALITA" type="capitalizeFullyTrimText" length="100">
        </field>

        <field name="NOMINATIVO_IN_RUBRICA" type="boolean" sqlStorageStrategy="singleCharTF"
               customSelectExpression="decode(JTK_RUBRICA_TITOLARI.ID_REC, null, 'F', 'T')"/>

        <field name="CREATOR" type="creator" editRequires="false"/>
        <field name="CREATOR_TIMESTAMP" type="creatorTimestamp" editRequires="false"/>
        <field name="MODIFIER" type="modifier" editRequires="false"/>
        <field name="MODIFIER_TIMESTAMP" type="modifierTimestamp" editRequires="false"/>
    </fields>
    <operationBindings>
        <operationBinding operationType="fetch" requiresRole="">
            <tableClause>$defaultTableClause, JTK_RUBRICA_TITOLARI</tableClause>
            <whereClause>
                $defaultWhereClause
                and JTK_NOMI_TICKET.ID_REC = JTK_RUBRICA_TITOLARI.ID_NOME_RUBRICA_FK (+)
                and ($sessionAttributes.ID_TITOLARE_IMPERSONATO_FK = JTK_RUBRICA_TITOLARI.ID_TITOLARE_FK or JTK_RUBRICA_TITOLARI.ID_TITOLARE_FK is null)
            </whereClause>
        </operationBinding>
        <operationBinding operationType="fetch" operationId="fetchAll" requiresRole="ROLE_TICKETING"/>
        <operationBinding operationType="add" requiresRole="ROLE_TICKETING"/>
        <operationBinding operationType="update" requiresRole="ROLE_TICKETING"/>
        <operationBinding operationType="add" operationId="salvaNomeBigliettoPagamento" serverMethod="salvaNomeBigliettoPagamento" requiresRole="">
            <serverObject lookupStyle="new" className="com.juve.jtk.SalvaNomeBigliettoPagamento"/>
        </operationBinding>
        <operationBinding operationType="update" operationId="salvaNomeBigliettoPagamento" serverMethod="salvaNomeBigliettoPagamento" requiresRole="">
            <serverObject lookupStyle="new" className="com.juve.jtk.SalvaNomeBigliettoPagamento"/>
        </operationBinding>
        <operationBinding operationType="add" operationId="salvaNomeBigliettoOmaggio" serverMethod="salvaNomeBigliettoOmaggio" requiresRole="">
            <serverObject lookupStyle="new" className="com.juve.jtk.SalvaNomeBigliettoOmaggio"/>
        </operationBinding>
        <operationBinding operationType="update" operationId="salvaNomeBigliettoOmaggio" serverMethod="salvaNomeBigliettoOmaggio" requiresRole="">
            <serverObject lookupStyle="new" className="com.juve.jtk.SalvaNomeBigliettoOmaggio"/>
        </operationBinding>
        <operationBinding operationType="remove" requiresRole=""/>
    </operationBindings>
</DataSource>

please let me know if you need other details

**Isomorphic** · 14 Dec 2016, 01:21

We have enhanced the DataSource.fetchById() method to fix this problem. The correction should be in today's (Wednesday) 11.1 / 6.1 builds, please try it out and let us know if you still see a problem

**claudiobosticco** · 19 Dec 2016, 01:19

SmartClient Version: SNAPSHOT_v11.1d_2016-12-15/Enterprise Deployment (built 2016-12-15)

I can confirm it's fixed, thank you very much.

Announcement

applyWhen 'automatic' fetch and velocity context

Comment

Comment

Comment

Comment