Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Bug Data source field includeFrom and includeVia

    Hi Isomorphic,

    I'm currently having an issue with Datasource configuration using multiple foreignkeys to the same datasource / table.

    Basically the generated SQL is not providing different aliases for the table even using relatedTableAlias.

    I have the following Datasources:

    sprgprojects:
    Code:
    <DataSource ID="sprgprojects" serverType="sql" tableName="sprgprojects"	>
    
    	<fields>
    		<field name="projectId" title="ID Proyecto" type="integer" canEdit="false" length="10" />
    		<field name="projectPk" customSelectExpression="CONCAT(sprgprojects.projectId, '.0')" primaryKey="true" hidden="true" />
    		<field name="projectType" title="Tipo Proyecto" type="integer" canEdit="false" length="5" hidden="true" />
    		<field name="projectName" title="Nombre Proyecto" type="text" length="50" />
    		<field name="projectDesc" title="Descripcion Proyecto" type="text" length="255" />
    		<field name="projectFlags" title="Flags" type="integer" hidden="true" length="10" />
    		<field name="projectObjSelType" type="integer" hidden="true" length="5" />
    		<field name="projectParamsId" type="integer" hidden="true" length="10" />
    		<field name="areaId" type="integer" hidden="true" length="10" />
    		<field foreignKey="sprlog.logId" name="createLogId" hidden="true" canEdit="false" />
    		<field foreignKey="sprlog.logId" name="saveLogId" hidden="true" canEdit="false" />
    		<field name="saveVersionId" type="integer" hidden="true" length="5" />
    		<field foreignKey="sprlog.logId" name="lockLogId" hidden="true" canEdit="false" />
    		<field name="lockVersionId" type="integer" hidden="true" length="5" />
    		<field foreignKey="sprlog.logId" name="closeLogId" hidden="true" />
    		<field foreignKey="sprlog.logId" name="cancelLogId" hidden="true" />
    		
    		<field name="createDate" includeFrom="sprlog.eventDate" includeVia="createLogId" />
    		<field name="saveDate" hidden="true" includeFrom="sprlog.eventDate" includeVia="saveLogId" />
    		<field name="lockDate" hidden="true" includeFrom="sprlog.eventDate" includeVia="lockLogId" />
    		<field name="closeDate" hidden="true" includeFrom="sprlog.eventDate" includeVia="closeLogId" />
    		<field name="cancellDate" hidden="true" includeFrom="sprlog.eventDate" includeVia="cancelLogId" />
    		
    		<field name="fsProjectCode" type="text" hidden="true" length="20" />
    		<field name="isFolder" type="boolean" hidden="true" required="true" customSQL="true" />
    		<field name="versionDesc" type="text" customSQL="true" />
    	</fields>
    
    	
    	<operationBindings>
    		<operationBinding operationType="fetch" >
    			<tableClause>sprgprojversions, $defaultTableClause</tableClause>
    			<whereClause>sprgprojects.projectId = sprgprojversions.projectId AND sprgprojversions.versionId = '0' AND $defaultWhereClause</whereClause>
    		</operationBinding>
    	</operationBindings>
    
    
    	<serverObject className="com.em.teco.server.ds.ProjectTreeDmi" methodName="getProjectVersions" />
    
    </DataSource>
    And sprlog
    Code:
    <DataSource ID="sprlog" serverType="sql" tableName="sprlog" >
    
    	<fields>
    		<field name="logId" title="ID Log" type="integer" canEdit="false" length="10" primaryKey="true" />
    		<field name="logDate" title="Fecha Log" type="date" canEdit="false" />
    		<field name="superLogId" title="Super Log ID" type="integer" canEdit="false" length="10" hidden="true" />
    		<field name="userId" title="ID Usuario" type="integer" canEdit="false" />
    		<field name="eventType" title="Tipo de Evento" type="integer" canEdit="false" length="10" />
    		<field name="eventDate" title="Fecha Evento" type="date" canEdit="false" />
    		<field name="eventStatus" title="Estado" type="integer" canEdit="false" length="10" />
    		<field name="eventData" title="Datos evento" type="text" canEdit="false" length="255" />
    	</fields> 
    
    </DataSource>

    Finally the generated SQL when performing a fetch for the first datasource is like this:

    Code:
    SELECT sprgprojects.areaId,
      sprgprojects.cancelLogId,
      sprgprojects.closeLogId,
      sprgprojects.createLogId,
      sprgprojects.fsProjectCode,
      sprgprojects.lockLogId,
      sprgprojects.lockVersionId,
      sprgprojects.projectDesc,
      sprgprojects.projectFlags,
      sprgprojects.projectId,
      sprgprojects.projectName,
      sprgprojects.projectObjSelType,
      sprgprojects.projectParamsId,
      CONCAT(sprgprojects.projectId, '.0') AS projectPk,
      sprgprojects.projectType,
      sprgprojects.saveLogId,
      sprgprojects.saveVersionId,
      sprlog.eventDate AS createDate,
      sprlog.eventDate AS saveDate,
      sprlog.eventDate AS lockDate,
      sprlog.eventDate AS closeDate,
      sprlog.eventDate AS cancellDate
    FROM sprgprojversions,
      sprlog,
      sprgprojects
    WHERE sprgprojects.projectId   = sprgprojversions.projectId
    AND sprgprojversions.versionId = '0'
    AND ('1'                       ='1')
    AND sprgprojects.createLogId   = sprlog.logId
    AND sprgprojects.saveLogId     = sprlog.logId
    AND sprgprojects.lockLogId     = sprlog.logId
    AND sprgprojects.closeLogId    = sprlog.logId
    AND sprgprojects.cancelLogId   = sprlog.logId

    Any help will be appreciated,


    Thanks



    SmartGWT version:
    SmartClient Version: v9.0p_2014-02-25/EVAL Deployment (expires 2014.04.26_08.14.58) Licensed to: Isomorphic Software (#ISC_EVAL_NIGHTLY)

    #2
    Can you show the complete server log for the request that leads to this SQL?

    Comment


      #3
      Hi, this is the complete log up to the point of fetching from the sprgprojects datasource, with the default log4j.isc.config.xml:

      Code:
      [INFO] ISC: Configuring log4j from: file:/C:/Users/pcarle/proyweb/target/proyweb-1.0.0/WEB-INF/classes/log4j.isc.config.xml
      [INFO] === 2014-02-26 09:46:14,535 [main] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework - Initializing
      [INFO] === 2014-02-26 09:46:14,560 [main] INFO  ConfigLoader - Attempting to load framework.properties from CLASSPATH
      [INFO] === 2014-02-26 09:46:14,635 [main] INFO  ConfigLoader - Successfully loaded framework.properties from CLASSPATH at location: jar:file:/C:/Users/pcarle/proyweb/target/proyweb-1.0.0/WEB-INF/lib/isomorphic-core-rpc-4.0-p20140225.jar!/framework.properties
      [INFO] === 2014-02-26 09:46:14,636 [main] INFO  ConfigLoader - Attempting to load project.properties from CLASSPATH
      [INFO] === 2014-02-26 09:46:14,637 [main] INFO  ConfigLoader - Unable to locate project.properties in CLASSPATH
      [INFO] === 2014-02-26 09:46:14,643 [main] INFO  ConfigLoader - Successfully loaded isc_interfaces.properties from CLASSPATH at location: jar:file:/C:/Users/pcarle/proyweb/target/proyweb-1.0.0/WEB-INF/lib/isomorphic-core-rpc-4.0-p20140225.jar!/isc_interfaces.properties
      [INFO] === 2014-02-26 09:46:14,643 [main] INFO  ConfigLoader - Attempting to load server.properties from CLASSPATH
      [INFO] === 2014-02-26 09:46:14,644 [main] INFO  ConfigLoader - Successfully loaded server.properties from CLASSPATH at location: file:/C:/Users/pcarle/proyweb/target/proyweb-1.0.0/WEB-INF/classes/server.properties
      [INFO] === 2014-02-26 09:46:14,729 [main] INFO  Logger - Logging system started.
      [INFO] === 2014-02-26 09:46:14,734 [main] INFO  ISCInit - Auto-detected webRoot - using: C:\Users\pcarle\proyweb\target\proyweb-1.0.0
      [INFO] === 2014-02-26 09:46:14,736 [main] INFO  ISCInit - Isomorphic SmartClient/SmartGWT Framework (v9.0p_2014-02-25/EVAL Deployment 2014-02-25) - Initialization Complete
      [INFO] === 2014-02-26 09:46:45,869 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\builtinTypes.xml: 8ms
      [INFO] === 2014-02-26 09:46:45,898 [l0-3] INFO  PoolManager - SmartClient pooling started for 'simpleTypes' objects
      [INFO] === 2014-02-26 09:46:46,023 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\ds\sprgprojects.ds.xml: 7ms
      [INFO] === 2014-02-26 09:46:46,055 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\DataSource.ds.xml: 20ms
      [INFO] === 2014-02-26 09:46:46,275 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\DataSourceField.ds.xml: 7ms
      [INFO] === 2014-02-26 09:46:46,381 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\OperationBinding.ds.xml: 5ms
      [INFO] === 2014-02-26 09:46:46,419 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\ServerObject.ds.xml: 3ms
      [INFO] === 2014-02-26 09:46:46,498 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\ds\sprlogs.ds.xml: 4ms
      [INFO] === 2014-02-26 09:46:46,538 [l0-3] DEBUG Relation - Caching instance of toDS 'sprlogs' in the DSRequest map
      [INFO] === 2014-02-26 09:46:46,540 [l0-3] DEBUG DataSourceLoader - For DataSource 'sprgprojects', got instanceId 10
      [INFO] === 2014-02-26 09:46:46,596 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\ds\sprgprojversions.ds.xml: 4ms
      [INFO] === 2014-02-26 09:46:46,610 [l0-3] DEBUG DataSourceLoader - For DataSource 'sprgprojversions', got instanceId 18
      [INFO] === 2014-02-26 09:46:46,619 [l0-3] DEBUG DataSourceLoader - For DataSource 'sprlogs', got instanceId 19
      [INFO] === 2014-02-26 09:47:07,713 [l0-3] DEBUG ScreenLoaderServlet - screenLoader - Requested screens:MainPage,ProjectsView,FiltrosProyectos
      [INFO] === 2014-02-26 09:47:07,713 [l0-3] DEBUG ScreenLoaderServlet - screenLoader - Processing screen "MainPage".
      [INFO] === 2014-02-26 09:47:07,807 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms
      [INFO] === 2014-02-26 09:47:07,813 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\isomorphicXML.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:07,921 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Label.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:07,933 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\MethodDeclaration.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:07,941 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Button.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:07,952 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\StatefulCanvas.ds.xml: 4ms
      [INFO] === 2014-02-26 09:47:07,969 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\ValueMap.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,019 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Canvas.ds.xml: 9ms
      [INFO] === 2014-02-26 09:47:08,100 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\HLayout.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,107 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Layout.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,127 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\ToolStripButton.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,162 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\StretchImgButton.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,170 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\StretchImg.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,185 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\ToolStrip.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,194 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\VLayout.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,204 [l0-3] DEBUG ScreenLoaderServlet - screenLoader - Processing screen "ProjectsView".
      [INFO] === 2014-02-26 09:47:08,210 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 1ms
      [INFO] === 2014-02-26 09:47:08,261 [l0-3] DEBUG ScreenLoaderServlet - screenLoader - Processing screen "FiltrosProyectos".
      [INFO] === 2014-02-26 09:47:08,311 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 4ms
      [INFO] === 2014-02-26 09:47:08,317 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\IButton.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,365 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\DynamicForm.ds.xml: 4ms
      [INFO] === 2014-02-26 09:47:08,406 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\FormItem.ds.xml: 4ms
      [INFO] === 2014-02-26 09:47:08,473 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\SectionItem.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,571 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\CanvasItem.ds.xml: 90ms
      [INFO] === 2014-02-26 09:47:08,580 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\RowSpacerItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,586 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\SpacerItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,596 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\TextItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,626 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Validator.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,643 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\IsIntegerValidator.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,650 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\DateItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,670 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\ContainerItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,679 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\SelectItem.ds.xml: 2ms
      [INFO] === 2014-02-26 09:47:08,709 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\Window.ds.xml: 3ms
      [INFO] === 2014-02-26 09:47:08,723 [l0-3] DEBUG ScreenLoaderServlet - screenLoader - Generated response:{
      [INFO] 
      [INFO]   screens: [
      [INFO] 
      [INFO]        { screenName:"MainPage",
      [INFO] 
      [INFO]         source:"\n\tisc.Label.create({\n    ID:\"titleLabel\",\n    autoDraw:false,\n    height:36,\n    width:\"100%\",\n    contents:\"MODULO PROYECTOS\",\n    title:\"Label0\",\n    styleName:\"header\"\n})\n\n\n\tisc.HLayout.create({\n    ID:\"titleLayout\",\n    autoDraw:false,\n    height:36,\n    width:\"100%\",\n    defaultLayoutAlign:\"left\",\n    members:[\n        titleLabel\n    ],\n    layoutAlign:\"left\"\n})\n\n\n\tisc.ToolStripButton.create({\n    ID:\"projDisplayButton\",\n    autoDraw:false,\n    title:\"Proyectos\"\n})\n\n\n\tisc.ToolStripButton.create({\n    ID:\"adminConsoleButton\",\n    autoDraw:false,\n    title:\"Consola Admin.\"\n})\n\n\n\tisc.ToolStripButton.create({\n    ID:\"developConsoleButton\",\n    autoDraw:false,\n    title:\"Consola Desa.\",\n    click:\"\\n\\t\\t\\tisc.showConsole();\\n\\t\\t\"\n})\n\n\t\n\tisc.ToolStripButton.create({\n    ID:\"visualBuilderButton\",\n    autoDraw:false,\n    title:\"Visual Builder\"\n})\n\n\t\n\tisc.ToolStripButton.create({\n    ID:\"hidTest\",\n    autoDraw:false,\n    title:\"Connect HID\"\n})\n\n\t\n\tisc.ToolStrip.create({\n    ID:\"mainToolbar\",\n    autoDraw:false,\n    width:\"100%\",\n    members:[\n        projDisplayButton,\n        adminConsoleButton,\n        developConsoleButton,\n        visualBuilderButton,\n        hidTest\n    ],\n    visibilityMode:\"multiple\"\n})\n\n\t\n\tisc.VLayout.create({\n    ID:\"mainAreaLayout\",\n    autoDraw:false,\n    height:\"100%\",\n    width:\"100%\"\n})\n\n\n\tisc.VLayout.create({\n    ID:\"layoutPrincipal\",\n    autoDraw:false,\n    height:\"100%\",\n    width:\"100%\",\n    members:[\n        titleLayout,\n        mainToolbar,\n        mainAreaLayout\n    ]\n})\n\n\n\n"}
      [INFO] 
      [INFO] 
      [INFO]       ,{ screenName:"ProjectsView",
      [INFO] 
      [INFO]         source:"\n\tisc.ToolStripButton.create({\n    ID:\"busquedaAvanzada\",\n    autoDraw:false,\n    title:\"Busqueda Avanzada\"\n})\n\n\t\n\tisc.ToolStripButton.create({\n    ID:\"limpiarFiltros\",\n    autoDraw:false,\n    title:\"Limpiar Filtros Avanzados\"\n})\n\n\t\n\tisc.ToolStripButton.create({\n    ID:\"refresh\",\n    autoDraw:false,\n    title:\"Recargar Proyectos\"\n})\n\n\t\n\tisc.ToolStrip.create({\n    ID:\"projectActionsToolbar\",\n    autoDraw:false,\n    width:\"100%\",\n    members:[\n        busquedaAvanzada,\n        limpiarFiltros,\n        refresh\n    ]\n})\n\n\n\n\t\t\n\tisc.VLayout.create({\n    ID:\"prjViewLayout\",\n    autoDraw:false,\n    height:\"100%\",\n    width:\"100%\",\n    members:[\n        projectActionsToolbar\n    ]\n})\n\n\n"}
      [INFO] 
      [INFO] 
      [INFO]       ,{ screenName:"FiltrosProyectos",
      [INFO] 
      [INFO]         source:"\n\n\n\tisc.IButton.create({\n    ID:\"searchButton\",\n    autoDraw:false,\n    title:\"Buscar\"\n})\n\n\n\n\tisc.IButton.create({\n    ID:\"clearButton\",\n    autoDraw:false,\n    title:\"Borrar Campos\"\n})\n\n\n\n\tisc.IButton.create({\n    ID:\"cancelarButton\",\n    autoDraw:false,\n    title:\"Cancelar\"\n})\n\n\n\n\tisc.HLayout.create({\n    ID:\"HLayout0\",\n    autoDraw:false,\n    height:20,\n    defaultLayoutAlign:\"center\",\n    members:[\n        searchButton,\n        clearButton,\n        cancelarButton\n    ],\n    membersMargin:10,\n    align:\"center\",\n    endRow:\"true\"\n})\n\n\n\tisc.DynamicForm.create({\n    ID:\"formFiltrosProyectos\",\n    autoDraw:false,\n    height:\"100%\",\n    fields:[\n        {\n            name:\"SectionItem0\",\n            defaultValue:\"Proyecto\",\n            items:[\n                {\n                    name:\"RowSpacerItem4\",\n                    _constructor:\"RowSpacerItem\"\n                },\n                {\n                    mask:\"##########\",\n                    name:\"idProyecto\",\n                    title:\"ID Proyecto\",\n                    Validators:{\n                        IsIntegerValidator:{\n                            clientOnly:true,\n                            errorMessage:\"El ID de proyecto es solo numerico\",\n                            _constructor:\"isInteger\"\n                        }\n                    },\n                    _constructor:\"TextItem\"\n                },\n                {\n                    name:\"nombre\",\n                    title:\"Nombre\",\n                    _constructor:\"TextItem\"\n                },\n                {\n                    name:\"descripcion\",\n                    title:\"Descripcion\",\n                    _constructor:\"TextItem\"\n                }\n            ],\n            _constructor:\"SectionItem\"\n        },\n        {\n            name:\"RowSpacerItem4\",\n            _constructor:\"RowSpacerItem\"\n        },\n        {\n            name:\"SectionItem1\",\n            defaultValue:\"Fecha de Creacion\",\n            items:[\n                {\n                    name:\"RowSpacerItem5\",\n                    _constructor:\"RowSpacerItem\"\n                },\n                {\n                    name:\"Desde\",\n                    startRow:true,\n                    useMask:\"true\",\n                    useTextField:true,\n                    _constructor:\"DateItem\"\n                },\n                {\n                    endRow:true,\n                    name:\"Hasta\",\n                    useMask:\"true\",\n                    useTextField:true,\n                    _constructor:\"DateItem\"\n                }\n            ],\n            _constructor:\"SectionItem\"\n        },\n        {\n            name:\"RowSpacerItem1\",\n            _constructor:\"RowSpacerItem\"\n        },\n        {\n            name:\"SectionItem3\",\n            defaultValue:\"Estado\",\n            items:[\n                {\n                    name:\"RowSpacerItem6\",\n                    _constructor:\"RowSpacerItem\"\n                },\n                {\n                    name:\"SelectItem0\",\n                    title:\"Proyecto\",\n                    valueMap:[\n                        \"Abierto\",\n                        \"Cerrado\",\n                        \"Cancelado\"\n                    ],\n                    _constructor:\"SelectItem\"\n                },\n                {\n                    name:\"SelectItem1\",\n                    title:\"Version\",\n                    valueMap:[\n                        \"Cancelada\",\n                        \"Abierta\"\n                    ],\n                    _constructor:\"SelectItem\"\n                }\n            ],\n            _constructor:\"SectionItem\"\n        },\n        {\n            name:\"RowSpacerItem3\",\n            _constructor:\"RowSpacerItem\"\n        },\n        {\n            colSpan:\"*\",\n            endRow:true,\n            name:\"CanvasItem1\",\n            startRow:true,\n            width:\"*\",\n            showTitle:false,\n            canvas:HLayout0,\n            _constructor:\"CanvasItem\"\n        }\n    ]\n})\n\n\n\n\tisc.Window.create({\n    ID:\"filtersWindow\",\n    autoDraw:false,\n    height:430,\n    width:350,\n    autoCenter:true,\n    isModal:true,\n    visibility:\"visible\",\n    title:\"Filtros\",\n    showMinimizeButton:false,\n    items:[\n        formFiltrosProyectos\n    ],\n    showShadow:false\n})\n\n\n"}
      [INFO] 
      [INFO] 
      [INFO]       ]
      [INFO] 
      [INFO] }
      [INFO] 
      [INFO] 
      [INFO] 
      [INFO] === 2014-02-26 09:47:40,274 [l0-3] DEBUG IDACall - Header Name:Value pair: Accept:*/*
      [INFO] === 2014-02-26 09:47:40,274 [l0-3] DEBUG IDACall - Header Name:Value pair: Referer:http://127.0.0.1:8888/Main.html?gwt.codesvr=127.0.0.1:9997
      [INFO] === 2014-02-26 09:47:40,274 [l0-3] DEBUG IDACall - Header Name:Value pair: Accept-Language:es-ar
      [INFO] === 2014-02-26 09:47:40,274 [l0-3] DEBUG IDACall - Header Name:Value pair: User-Agent:Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/6.0)
      [INFO] === 2014-02-26 09:47:40,275 [l0-3] DEBUG IDACall - Header Name:Value pair: Accept-Encoding:gzip, deflate
      [INFO] === 2014-02-26 09:47:40,275 [l0-3] DEBUG IDACall - Header Name:Value pair: Host:127.0.0.1:8888
      [INFO] === 2014-02-26 09:47:40,277 [l0-3] DEBUG IDACall - Header Name:Value pair: DNT:1
      [INFO] === 2014-02-26 09:47:40,277 [l0-3] DEBUG IDACall - Header Name:Value pair: Connection:Keep-Alive
      [INFO] === 2014-02-26 09:47:40,277 [l0-3] DEBUG IDACall - Header Name:Value pair: Cookie:JSESSIONID=ltg9isw5qgug
      [INFO] === 2014-02-26 09:47:40,277 [l0-3] DEBUG IDACall - Header Name:Value pair: Content-Type:application/x-www-form-urlencoded; charset=UTF-8
      [INFO] === 2014-02-26 09:47:40,277 [l0-3] DEBUG IDACall - Header Name:Value pair: Content-Length:792
      [INFO] === 2014-02-26 09:47:40,278 [l0-3] DEBUG IDACall - Header Name:Value pair: Cache-Control:no-cache
      [INFO] === 2014-02-26 09:47:40,278 [l0-3] DEBUG IDACall - session exists: ltg9isw5qgug
      [INFO] === 2014-02-26 09:47:40,278 [l0-3] DEBUG IDACall - remote user: null
      [INFO] === 2014-02-26 09:47:40,350 [l0-3] INFO  RequestContext - URL: '/Main/sc/IDACall', User-Agent: 'Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/6.0)': MSIE with Accept-Encoding header, ready for compressed JS
      [INFO] === 2014-02-26 09:47:40,385 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms
      [INFO] === 2014-02-26 09:47:40,395 [l0-3] DEBUG XML - Parsed XML from C:\Users\pcarle\proyweb\target\proyweb-1.0.0\Main\sc\system\schema\List.ds.xml: 4ms
      [INFO] === 2014-02-26 09:47:40,397 [l0-3] DEBUG RPCManager - Processing 1 requests.
      [INFO] === 2014-02-26 09:47:40,422 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      [INFO]     criteria:{
      [INFO]     },
      [INFO]     operationConfig:{
      [INFO]         dataSource:"sprgprojects",
      [INFO]         operationType:"fetch"
      [INFO]     },
      [INFO]     appID:"builtinApplication",
      [INFO]     operation:"sprgprojects_fetch",
      [INFO]     oldValues:{
      [INFO]     }
      [INFO] }
      [INFO] === 2014-02-26 09:47:40,422 [l0-3] INFO  IDACall - Performing 1 operation(s)
      [INFO] === 2014-02-26 09:47:40,428 [l0-3] DEBUG Relation - Caching instance of toDS 'sprlogs' in the DSRequest map
      [INFO] === 2014-02-26 09:47:40,429 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
      [INFO] === 2014-02-26 09:47:40,429 [l0-3] DEBUG DeclarativeSecurity - DataSource sprgprojects is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,431 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,431 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,431 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,431 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,431 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - DataSource sprlogs is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,432 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,433 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,434 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,434 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,434 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,434 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,434 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - DataSource sprgprojects is not in the pre-checked list, processing...
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,497 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,498 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,498 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,498 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,498 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,499 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,500 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,500 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,500 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,500 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,501 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,501 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,501 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,501 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,502 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,502 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,504 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field logId
      [INFO] === 2014-02-26 09:47:40,504 [l0-3] DEBUG DeclarativeSecurity - Processing security checks for DataSource sprlogs, field eventDate
      [INFO] === 2014-02-26 09:47:40,509 [l0-3] DEBUG AppBase - [builtinApplication.sprgprojects_fetch] No userTypes defined, allowing anyone access to all operations for this application
      [INFO] === 2014-02-26 09:47:40,510 [l0-3] DEBUG AppBase - [builtinApplication.sprgprojects_fetch] No public zero-argument method named '_sprgprojects_fetch' found, performing generic datasource operation
      [INFO] === 2014-02-26 09:47:40,512 [l0-3] INFO  SQLDataSource - [builtinApplication.sprgprojects_fetch] Performing fetch operation with
      [INFO] 	criteria: {}	values: {}
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - ************************************************************** 
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - Starting Jakarta Velocity v1.4
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - RuntimeInstance initializing.
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - Default Properties File: org\apache\velocity\runtime\defaults\velocity.properties
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - Trying to use logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
      [INFO] === 2014-02-26 09:47:40,578 [l0-3] INFO  Velocity - Using logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
      [INFO] === 2014-02-26 09:47:40,582 [l0-3] INFO  Velocity - Default ResourceManager initializing. (class org.apache.velocity.runtime.resource.ResourceManagerImpl)
      [INFO] === 2014-02-26 09:47:40,585 [l0-3] INFO  Velocity - Resource Loader Instantiated: org.apache.velocity.runtime.resource.loader.FileResourceLoader
      [INFO] === 2014-02-26 09:47:40,585 [l0-3] INFO  Velocity - FileResourceLoader : initialization starting.
      [INFO] === 2014-02-26 09:47:40,585 [l0-3] INFO  Velocity - FileResourceLoader : adding path ''
      [INFO] === 2014-02-26 09:47:40,585 [l0-3] INFO  Velocity - FileResourceLoader : initialization complete.
      [INFO] === 2014-02-26 09:47:40,586 [l0-3] INFO  Velocity - ResourceCache : initialized. (class org.apache.velocity.runtime.resource.ResourceCacheImpl)
      [INFO] === 2014-02-26 09:47:40,586 [l0-3] INFO  Velocity - Default ResourceManager initialization complete.
      [INFO] === 2014-02-26 09:47:40,589 [l0-3] INFO  Velocity - Loaded System Directive: org.apache.velocity.runtime.directive.Literal
      [INFO] === 2014-02-26 09:47:40,591 [l0-3] INFO  Velocity - Loaded System Directive: org.apache.velocity.runtime.directive.Macro
      [INFO] === 2014-02-26 09:47:40,595 [l0-3] INFO  Velocity - Loaded System Directive: org.apache.velocity.runtime.directive.Parse
      [INFO] === 2014-02-26 09:47:40,597 [l0-3] INFO  Velocity - Loaded System Directive: org.apache.velocity.runtime.directive.Include
      [INFO] === 2014-02-26 09:47:40,598 [l0-3] INFO  Velocity - Loaded System Directive: org.apache.velocity.runtime.directive.Foreach
      [INFO] === 2014-02-26 09:47:40,650 [l0-3] INFO  Velocity - Created: 20 parsers.
      [INFO] === 2014-02-26 09:47:40,658 [l0-3] INFO  Velocity - Velocimacro : initialization starting.
      [INFO] === 2014-02-26 09:47:40,658 [l0-3] INFO  Velocity - Velocimacro : adding VMs from VM library template : VM_global_library.vm
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] ERROR Velocity - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro : error using  VM library template VM_global_library.vm : org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro :  VM library template macro registration complete.
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro : allowInline = true : VMs can be defined inline in templates
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro : allowInlineLocal = false : VMs defined inline will be  global in scope if allowed.
      [INFO] === 2014-02-26 09:47:40,664 [l0-3] INFO  Velocity - Velocimacro : messages on  : VM system will output logging messages
      [INFO] === 2014-02-26 09:47:40,665 [l0-3] INFO  Velocity - Velocimacro : autoload off  : VM system will not automatically reload global library macros
      [INFO] === 2014-02-26 09:47:40,665 [l0-3] INFO  Velocity - Velocimacro : initialization complete.
      [INFO] === 2014-02-26 09:47:40,665 [l0-3] INFO  Velocity - Velocity successfully started.
      [INFO] === 2014-02-26 09:47:40,700 [l0-3] INFO  SQLWhereClause - [builtinApplication.sprgprojects_fetch] empty condition
      [INFO] === 2014-02-26 09:47:40,722 [l0-3] INFO  SQLDataSource - [builtinApplication.sprgprojects_fetch] derived query: SELECT $defaultSelectClause FROM sprgprojversions, $defaultTableClause WHERE sprgprojects.projectId = sprgprojversions.projectId AND sprgprojversions.versionId = '0' AND $defaultWhereClause AND $defaultJoinWhereClause
      [INFO] === 2014-02-26 09:47:40,729 [l0-3] INFO  SQLDataSource - [builtinApplication.sprgprojects_fetch] 10: Executing SQL query on 'Oracle': SELECT sprgprojects.areaId, sprgprojects.cancelLogId, sprgprojects.closeLogId, sprgprojects.createLogId, sprgprojects.fsProjectCode, sprgprojects.lockLogId, sprgprojects.lockVersionId, sprgprojects.projectDesc, sprgprojects.projectFlags, sprgprojects.projectId, sprgprojects.projectName, sprgprojects.projectObjSelType, sprgprojects.projectParamsId, CONCAT(sprgprojects.projectId, '.0') AS projectPk, sprgprojects.projectType, sprgprojects.saveLogId, sprgprojects.saveVersionId, sprlog.eventDate AS createDate, sprlog.eventDate AS saveDate, sprlog.eventDate AS lockDate, sprlog.eventDate AS closeDate, sprlog.eventDate AS cancellDate FROM sprgprojversions, sprgprojects, sprlog WHERE sprgprojects.projectId = sprgprojversions.projectId AND sprgprojversions.versionId = '0' AND ('1'='1') AND sprgprojects.createLogId = sprlog.logId AND sprgprojects.saveLogId = sprlog.logId AND sprgprojects.lockLogId = sprlog.logId AND sprgprojects.closeLogId = sprlog.logId AND sprgprojects.cancelLogId = sprlog.logId
      [INFO] === 2014-02-26 09:47:40,811 [l0-3] INFO  PoolManager - [builtinApplication.sprgprojects_fetch] SmartClient pooling started for 'Oracle' objects
      [INFO] === 2014-02-26 09:47:40,812 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.sprgprojects_fetch] Initializing SQL config for 'Oracle' from system config - using DataSource:  oracle.jdbc.pool.OracleDataSource
      [INFO] === 2014-02-26 09:47:42,304 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.sprgprojects_fetch] makeObject() created a pooled Connection '4777043'
      [INFO] === 2014-02-26 09:47:42,380 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.sprgprojects_fetch] Executing pingTest 'select 1 from dual' on connection 4777043
      [INFO] === 2014-02-26 09:47:42,401 [l0-3] DEBUG SQLConnectionManager - [builtinApplication.sprgprojects_fetch] Borrowed connection '4777043'
      [INFO] === 2014-02-26 09:47:42,401 [l0-3] DEBUG SQLDriver - [builtinApplication.sprgprojects_fetch] About to execute SQL query in 'Oracle' using connection '4777043'
      [INFO] === 2014-02-26 09:47:42,401 [l0-3] INFO  SQLDriver - [builtinApplication.sprgprojects_fetch] Executing SQL query on 'Oracle': SELECT sprgprojects.areaId, sprgprojects.cancelLogId, sprgprojects.closeLogId, sprgprojects.createLogId, sprgprojects.fsProjectCode, sprgprojects.lockLogId, sprgprojects.lockVersionId, sprgprojects.projectDesc, sprgprojects.projectFlags, sprgprojects.projectId, sprgprojects.projectName, sprgprojects.projectObjSelType, sprgprojects.projectParamsId, CONCAT(sprgprojects.projectId, '.0') AS projectPk, sprgprojects.projectType, sprgprojects.saveLogId, sprgprojects.saveVersionId, sprlog.eventDate AS createDate, sprlog.eventDate AS saveDate, sprlog.eventDate AS lockDate, sprlog.eventDate AS closeDate, sprlog.eventDate AS cancellDate FROM sprgprojversions, sprgprojects, sprlog WHERE sprgprojects.projectId = sprgprojversions.projectId AND sprgprojversions.versionId = '0' AND ('1'='1') AND sprgprojects.createLogId = sprlog.logId AND sprgprojects.saveLogId = sprlog.logId AND sprgprojects.lockLogId = sprlog.logId AND sprgprojects.closeLogId = sprlog.logId AND sprgprojects.cancelLogId = sprlog.logId
      [INFO] === 2014-02-26 09:47:42,487 [l0-3] INFO  DSResponse - [builtinApplication.sprgprojects_fetch] DSResponse: List with 0 items
      [INFO] === 2014-02-26 09:47:42,491 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      [INFO] === 2014-02-26 09:47:42,492 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      [INFO] === 2014-02-26 09:47:42,494 [l0-3] DEBUG SQLDriver - Freeing SQLDriver dbConnection 4777043
      [INFO] === 2014-02-26 09:47:42,495 [l0-3] DEBUG SQLConnectionManager - About to close PoolableConnection with hashcode "4777043"
      [INFO] === 2014-02-26 09:47:42,495 [l0-3] DEBUG PoolableSQLConnectionFactory - Executing pingTest 'select 1 from dual' on connection 4777043

      Comment


        #4
        Could you also show the code of ProjectTreeDmi class used as serverObject for your data source?

        Code:
        <serverObject className="com.em.teco.server.ds.ProjectTreeDmi" methodName="getProjectVersions" />
        I'd also appreciate if you could remove that serverObject declaration from your ds.xml file and try if it will work that way. This is just a test to help identify the problem, thanks.

        Comment


          #5
          Hi, thanks for your reply, I have also tried removing the serverObject and still performs the same way.

          As a workaround I'm writing the operationBindings myself in the datasource to replicate the correct behavior.

          There is another simpler example for which I get the same results:

          Datasource definition:
          Code:
          <DataSource ID="elementWorkflow" serverType="sql" tableName="pi_element_workflow">
          
          <!-- Workflow de estados de elementos PI
           -->
          
          	<fields>
          		<field name="id" type="integer" canEdit="false" length="12" primaryKey="true" />
          		<field name="status_id_from" type="integer" length="12" required="true" foreignKey="enumerationItem.id" relatedTableAlias="from" />
          		<field name="status_id_to" type="integer" length="12" required="true" foreignKey="enumerationItem.id" relatedTableAlias="to" />
          		
          		<field name="statusFrom" type="text" includeFrom="enumerationItem.label" includeVia="status_id_from" />
          		<field name="statusTo" type="text" includeFrom="enumerationItem.label" includeVia="status_id_to" />
          		
          	</fields>
          
          </DataSource>

          Result query:
          Code:
          SELECT pi_element_workflow.id,
            pi_element_workflow.status_id_from,
            pi_element_workflow.status_id_to,
            pi_enumeration_item.label AS statusFrom,
            pi_enumeration_item.label AS statusTo
          FROM pi_enumeration_item,
            pi_element_workflow
          WHERE ('1'                             ='1')
          AND pi_element_workflow.status_id_from = pi_enumeration_item.id
          AND pi_element_workflow.status_id_to   = pi_enumeration_item.id

          DSRequest execution log:
          Code:
          === 2014-03-14 16:10:12,344 [0-19] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
          === 2014-03-14 16:10:12,345 [0-19] DEBUG AppBase - [builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
          === 2014-03-14 16:10:12,345 [0-19] DEBUG AppBase - [builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
          === 2014-03-14 16:10:12,346 [0-19] INFO  SQLDataSource - [builtinApplication.null] Performing fetch operation with
          	criteria: {}	values: {}
          === 2014-03-14 16:10:12,346 [0-19] INFO  SQLWhereClause - [builtinApplication.null] empty condition
          === 2014-03-14 16:10:12,346 [0-19] INFO  SQLDataSource - [builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause AND $defaultJoinWhereClause
          === 2014-03-14 16:10:12,347 [0-19] INFO  SQLDataSource - [builtinApplication.null] 27: Executing SQL query on 'Oracle': SELECT pi_element_workflow.id, pi_element_workflow.status_id_from, pi_element_workflow.status_id_to, pi_enumeration_item.label AS statusFrom, pi_enumeration_item.label AS statusTo FROM pi_enumeration_item, pi_element_workflow WHERE ('1'='1') AND pi_element_workflow.status_id_from = pi_enumeration_item.id AND pi_element_workflow.status_id_to = pi_enumeration_item.id
          === 2014-03-14 16:10:12,347 [0-19] DEBUG PoolableSQLConnectionFactory - [builtinApplication.null] Executing pingTest 'select 1 from dual' on connection 21013005
          === 2014-03-14 16:10:12,349 [0-19] DEBUG SQLConnectionManager - [builtinApplication.null] Borrowed connection '21013005'
          === 2014-03-14 16:10:12,349 [0-19] DEBUG SQLDriver - [builtinApplication.null] About to execute SQL query in 'Oracle' using connection '21013005'
          === 2014-03-14 16:10:12,349 [0-19] INFO  SQLDriver - [builtinApplication.null] Executing SQL query on 'Oracle': SELECT pi_element_workflow.id, pi_element_workflow.status_id_from, pi_element_workflow.status_id_to, pi_enumeration_item.label AS statusFrom, pi_enumeration_item.label AS statusTo FROM pi_enumeration_item, pi_element_workflow WHERE ('1'='1') AND pi_element_workflow.status_id_from = pi_enumeration_item.id AND pi_element_workflow.status_id_to = pi_enumeration_item.id
          === 2014-03-14 16:10:12,352 [0-19] INFO  DSResponse - [builtinApplication.null] DSResponse: List with 0 items

          Although as stated before I do have a workaround it would be nice to know why this isn't working as expected, and documented in https://www.smartclient.com/smartgwtee/javadoc/com/smartgwt/client/docs/serverds/DataSourceField.html#includeVia


          Thanks

          Comment


            #6
            Downloaded a new version (4.1p 2014-03-11) and it is now working in all the reported cases here. Probably some kind of bug in the previous version.

            Thanks,.

            Comment

            Working...
            X