RESTHandler / RestRequestParser has problem with date-criteria

Isomorphic replied

1 Dec 2016, 15:04
This didn't answer our questions:

Can you show the RestDataSource involved and the inbound request (presumably it's XML),

We still don't have the inbound XML request.

Also, does this happen only through the HttpProxy, or does it also happen if you go direct?

We are asking whether contacting the server with a RestDataSource without going through the HttpProxy is working. You seem to have instead answered about what happens if you contact your server but do not use RestDataSource at all.
Leave a comment:

Blama replied

1 Dec 2016, 14:38

Hi Isomorphic,

this only happens via REST, not inside my application.

This is the RestDataSource:

Code:

package com.lmscompany.connector.client.datasources;

import com.lmscompany.connector.shared.type.RestDatasourceEnum;
import com.lmscompany.connector.shared.type.RestDatasourceFieldEnum;
import com.smartgwt.client.data.DSRequest;
import com.smartgwt.client.data.OperationBinding;
import com.smartgwt.client.data.fields.DataSourceDateField;
import com.smartgwt.client.data.fields.DataSourceIntegerField;
import com.smartgwt.client.data.fields.DataSourceTextField;
import com.smartgwt.client.types.DSOperationType;

public class CampaignDS extends LMSRestDataSource {
    private static CampaignDS instance = new CampaignDS();

    public static CampaignDS getInstance() {
        return instance;
    }

    private CampaignDS() {
        super();
        setID(RestDatasourceEnum.T_CAMPAIGN.getValue());

        DataSourceIntegerField id = new DataSourceIntegerField(RestDatasourceFieldEnum.T_CAMPAIGN__ID.getValue());
        id.setPrimaryKey(true);
        id.setCanEdit(false);

        DataSourceTextField shortname = new DataSourceTextField(RestDatasourceFieldEnum.T_CAMPAIGN__SHORTNAME.getValue());
        DataSourceTextField name = new DataSourceTextField(RestDatasourceFieldEnum.T_CAMPAIGN__NAME.getValue());
        DataSourceTextField description = new DataSourceTextField(RestDatasourceFieldEnum.T_CAMPAIGN__DESCRIPTION.getValue());
        DataSourceDateField startdate = new DataSourceDateField(RestDatasourceFieldEnum.T_CAMPAIGN__STARTDATE.getValue());
        DataSourceDateField enddate = new DataSourceDateField(RestDatasourceFieldEnum.T_CAMPAIGN__ENDDATE.getValue());
        DataSourceIntegerField cost = new DataSourceIntegerField(RestDatasourceFieldEnum.T_CAMPAIGN__COST.getValue());

        setFields(id, shortname, name, description, startdate, enddate, cost);

        OperationBinding fetchREST = new OperationBinding();
        fetchREST.setOperationType(DSOperationType.FETCH);
        fetchREST.setOperationId("fetchREST");
        DSRequest dsr = new DSRequest();
        dsr.setOperationId("fetchREST");
        fetchREST.setRequestProperties(dsr);
        setOperationBindings(fetchREST);
    }
}

This is the remote DataSource:

Code:

<DataSource xmlns="lmscompany/ds" xmlns:fmt="lmscompany/fmt" dbName="Oracle" tableName="T_CAMPAIGN" ID="T_CAMPAIGN" serverType="sql"
    serverConstructor="com.lmscompany.lms.server.LMSSQLDataSource">
    <fmt:bundle basename="com.lmscompany.lms.server.i18n.DSXMLResources-utf8" encoding="utf-8" />
    <fields>
        <field primaryKey="true" hidden="true" name="ID" type="sequence" />
        <field hidden="true" name="TENANT_ID" type="integer" canEdit="false" />
        <field foreignKey="V_USER_CREATED_BY.ID" relatedTableAlias="USER_CREATED_BY" name="CREATED_BY" type="creator">
            <title><fmt:message key="createdBy" /></title>
        </field>
        <field name="CREATED_AT" type="creatorTimestamp">
            <title><fmt:message key="createdAt" /></title>
        </field>
        <field foreignKey="V_USER_MODIFIED_BY.ID" relatedTableAlias="USER_MODIFIED_BY" name="MODIFIED_BY" type="modifier">
            <title><fmt:message key="modifiedBy" /></title>
        </field>
        <field name="MODIFIED_AT" type="modifierTimestamp">
            <title><fmt:message key="modifiedAt" /></title>
        </field>
        <field name="CREATED_BY_COMPANY_ID" includeFrom="V_USER_CREATED_BY.BELONGSTO_COMPANY_ID" hidden="true" />
        <field name="CREATED_BY_DISTRIBUTOR_ID" includeFrom="V_USER_CREATED_BY.BELONGSTO_DISTRIBUTOR_ID" hidden="true" />
        <field name="CREATED_BY_RESELLER_ID" includeFrom="V_USER_CREATED_BY.BELONGSTO_RESELLER_ID" hidden="true" />
        <field name="SHORTNAME" length="50" type="text" escapeHTML="true" required="true">
            <title><fmt:message key="shortname" /></title>
            <validators>
                <validator type="isUnique" serverOnly="true">
                    <errorMessage><fmt:message key="validatorShortNameInUse" /></errorMessage>
                </validator>
            </validators>
        </field>
        <field name="NAME" length="60" type="text" escapeHTML="true" required="true">
            <title><fmt:message key="name" /></title>
            <validators>
                <validator type="isUnique" serverOnly="true">
                    <errorMessage><fmt:message key="validatorNameInUse" /></errorMessage>
                </validator>
            </validators>
        </field>
        <field name="DESCRIPTION" length="1000" type="text" escapeHTML="true">
            <title><fmt:message key="description" /></title>
        </field>
        <field name="CAMPAIGN_COMMENT" length="1000" type="text" escapeHTML="true">
            <title><fmt:message key="defaultLeadComment" /></title>
        </field>
        <field name="STARTDATE" type="date" required="true">
            <title><fmt:message key="startDate" /></title>
            <validators>
                <validator type="serverCustom" serverOnly="true">
                    <serverCondition><![CDATA[
                      #if(         "$!record.ENDDATE" != "" )
                        #set( $gb = $!record.ENDDATE.getTime() )
                      ##elseif(     "$!dataSource.fetchById($record.ID).ENDDATE" != "" )
                        ##set( $gb = $!dataSource.fetchById($record.ID).ENDDATE.getTime() )
                      #else
                        #set( $gb = -1 )
                      #end
                      
                      $value.getTime() <= $gb || $gb == -1]]></serverCondition>
                    <errorMessage><fmt:message key="validatorStartDateBeforeEndDate2" /></errorMessage>
                </validator>
            </validators>
        </field>
        <field name="ENDDATE" type="date">
            <title><fmt:message key="endDate" /></title>
            <validators>
                <!-- Erkl�rung unter http://forums.smartclient.com/showthread.php?p=108718#post108718 -->
                <validator type="serverCustom" serverOnly="true">
                    <serverCondition><![CDATA[
                      #if(         "$!value" != "" )
                        #set( $gb = $!value.getTime() )
                      #else
                        #set( $gb = -1 )
                      #end

                      #if( "$!record.STARTDATE" != "" )
                        #set( $gv = $!record.STARTDATE.getTime() )
                      #else
                        #set( $gv = $!dataSource.fetchById($record.ID).STARTDATE.getTime() )
                      #end
                      $gv <= $gb || $gb == -1]]></serverCondition>
                    <errorMessage><fmt:message key="validatorStartDateBeforeEndDate2" /></errorMessage>
                </validator>
            </validators>
        </field>
        <field name="COST" type="integer">
            <title><fmt:message key="campaignCost" /></title>
        </field>
        
        <!-- TENANT_IDs for WHERE-clause generation -->
        <field name="CREATED_BY_TENANT_ID" includeFrom="V_USER_CREATED_BY.TENANT_ID" hidden="true" />
        <field name="MODIFIED_BY_TENANT_ID" includeFrom="V_USER_MODIFIED_BY.TENANT_ID" hidden="true" />
    </fields>
    <serverObject lookupStyle="new" className="com.lmscompany.lms.server.worker.T_CAMPAIGN" />
    <operationBindings>
        <!-- Should be changed to editCampaign -->
        <operationBinding operationType="add" requiresRole="editSetting" />
        <operationBinding operationType="update" requiresRole="editSetting" />
        <operationBinding operationType="validate" requiresRole="editSetting" />
        <operationBinding operationType="remove" requiresRole="editSetting" />
        <operationBinding operationType="fetch" />
        <operationBinding operationType="fetch" operationId="fetchREST" requiresAuthentication="false" outputs="ID, NAME, STARTDATE" />
    </operationBindings>
</DataSource>

I do think that I included the HttpProxyServlet at the top of the server log - if you need more please let me know what logging categories to activate.

Also FYI: I'm running my "local" connector application and my existing, now REST-enabled "remote" existing application on the same tomcat, so it might be difficult to tell apart which is what in the server log - but in this case this should be clear by the targeted URLs:

Code:

/connector/*: new connector app
/lms/*: existing app

Best regards
Blama