Updating includeFrom fields

nitrojin

Registered Developer

Join Date: Aug 2014
Posts: 20

6 Oct 2014, 02:12

I have a SQL datasource that is bound to a DynamicForm. I want to execute an update operation on fields that have been included in my DS via the includeFrom directive. The server logs seem to suggest that these fields are automatically ignored:

Code:

=== 2014-10-06 15:07:42,185 [ec-7] INFO  SQLValuesClause - [builtinApplication.leadsSQL_update] Ignored data for non-existent or included columns: [phone, userCities, pinCode, email, address, custName]

Can someone please recommend the best to go about this? I'd like the generated SQL query to contain all the necessary joins and update all fields present in the datasource.

Datasource:

Code:

<DataSource 
	dbName="bmf_mar17"
	tableName="leads"
	ID="leadsSQL"
	sequenceMode="jdbcDriver"
	dataSourceVersion="1"
	useAnsiJoins="true"
	serverType="sql"
>
	<fields>
		<field implicitSequence="true" primaryKey="true" name="id" type="sequence"></field>
		<field nativeFK="users.id" name="id_user_owner" type="integer"></field>
		<field foreignKey="ordersSQL.id" name="id_order" type="integer"></field>
		<field foreignKey="usersSQL.id" name="id_user" type="integer"></field>
		<field nativeFK="lead_sources.id" name="id_lead_source" type="integer"></field>
		<field nativeFK="operators.id_user" name="id_operator" type="integer"></field>
		<field nativeFK="status_master.id" name="id_status_code" type="integer"></field>
		<field nativeFK="cities.id" name="id_city" type="integer"></field>
		<field name="received_at" type="datetime"></field>
		<field name="updated_at" type="datetime"></field>
		<field name="last_comment_at" type="datetime"></field>
		<field name="priority_points" type="integer"></field>
		<field nativeFK="organizations.id" name="id_organizaion" type="integer"></field>
		
		<field name="address" includeFrom="addressesSQL.street_name" includeVia="id_order" valueWriteXPath="addressesSQL.street_name"/>
		<field name="userCities" includeFrom="addressesSQL.id_city" includeVia="id_order" />
		<field name="userState" includeFrom="addressesSQL.id_state" includeVia="id_order" />
		<field name="userCountry" includeFrom="addressesSQL.id_country" includeVia="id_order" />
		<field name="pinCode" includeFrom="addressesSQL.pin_code"></field>
		<field name="custName" includeFrom="user_detailsSQL.first_name" includeVia="id_user" />
		<field name="phone" includeFrom="user_detailsSQL.mobile" includeVia="id_user" />
		<field name="email" includeFrom="usersSQL.email" includeVia="id_user" />
	</fields>
	
	<operationBindings>  
		<binding operationType="update" serverMethod="updateLeadDetailsForm">  
			<serverObject lookupStyle="spring" bean="LeadService" />
		</binding>
	</operationBindings>
</DataSource>

Full Server logs:

Code:

=== 2014-10-06 15:39:09,205 [ec-9] INFO  RequestContext - URL: '/bmfview/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6': Moz (Gecko) with Accept-Encoding header
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: host:127.0.0.1:8080
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: accept-language:en-us,en;q=0.5
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip,deflate
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: accept-charset:ISO-8859-1,utf-8;q=0.7,*;q=0.7
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: keep-alive:115
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: connection:keep-alive
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: referer:http://127.0.0.1:8080/index.jsp?gwt.codesvr=127.0.0.1:9997
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: content-length:994
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: cookie:GLog=%7B%0D%20%20%20%20left%3A282%2C%20%0D%20%20%20%20top%3A47%2C%20%0D%20%20%20%20width%3A1129%2C%20%0D%20%20%20%20height%3A657%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%2C%20%0D%20%20%20%20%20%20%20%20ResultSet%3A5%2C%20%0D%20%20%20%20%20%20%20%20RPCManagerResponse%3A5%2C%20%0D%20%20%20%20%20%20%20%20RPCManager%3A5%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7D; JSESSIONID=C873C5D41132B3F18A3775E6D69BF257; isc_cState=ready
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: pragma:no-cache
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - session exists: C873C5D41132B3F18A3775E6D69BF257
=== 2014-10-06 15:39:09,206 [ec-9] DEBUG IDACall - remote user: anirudhjava777@gmail.com
=== 2014-10-06 15:39:09,207 [ec-9] WARN  RPCManager - client/server version mismatch.  Client is version: v9.1p_2014-09-01, server is version: v9.1p_2014-08-20 - mixing different client/server versions is generally not supported.  If you've installed a more recent client version, try clearing the browser cache and reloading the page.
=== 2014-10-06 15:39:09,326 [ec-1] INFO  RequestContext - URL: '/bmfview/sc/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6': Moz (Gecko) with Accept-Encoding header
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: host:127.0.0.1:8080
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: user-agent:Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.7; en-US; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: accept:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: accept-language:en-us,en;q=0.5
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: accept-encoding:gzip,deflate
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: accept-charset:ISO-8859-1,utf-8;q=0.7,*;q=0.7
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: keep-alive:115
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: connection:keep-alive
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: content-type:application/x-www-form-urlencoded; charset=UTF-8
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: referer:http://127.0.0.1:8080/index.jsp?gwt.codesvr=127.0.0.1:9997
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: content-length:3501
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: cookie:GLog=%7B%0D%20%20%20%20left%3A282%2C%20%0D%20%20%20%20top%3A47%2C%20%0D%20%20%20%20width%3A1129%2C%20%0D%20%20%20%20height%3A657%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%2C%20%0D%20%20%20%20%20%20%20%20ResultSet%3A5%2C%20%0D%20%20%20%20%20%20%20%20RPCManagerResponse%3A5%2C%20%0D%20%20%20%20%20%20%20%20RPCManager%3A5%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Atrue%0D%7D; JSESSIONID=C873C5D41132B3F18A3775E6D69BF257; isc_cState=ready
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: pragma:no-cache
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - Header Name:Value pair: cache-control:no-cache
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - session exists: C873C5D41132B3F18A3775E6D69BF257
=== 2014-10-06 15:39:09,327 [ec-1] DEBUG IDACall - remote user: anirudhjava777@gmail.com
=== 2014-10-06 15:39:09,328 [ec-1] WARN  RPCManager - client/server version mismatch.  Client is version: v9.1p_2014-09-01, server is version: v9.1p_2014-08-20 - mixing different client/server versions is generally not supported.  If you've installed a more recent client version, try clearing the browser cache and reloading the page.
=== 2014-10-06 15:39:09,452 [c-10] INFO  Download - Returning 304: Not modified on conditional get of: /Users/nmotwani/Documents/workspace/BMF_Mar17/WebContent/bmfview/sc/skins/Enterprise/images/blank.gif
=== 2014-10-06 15:39:09,601 [ec-9] DEBUG XML - Parsed XML from (in memory stream): 394ms
=== 2014-10-06 15:39:09,601 [ec-9] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2014-10-06 15:39:09,601 [ec-1] DEBUG XML - Parsed XML from (in memory stream): 273ms
=== 2014-10-06 15:39:09,602 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'transaction'
=== 2014-10-06 15:39:09,602 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2014-10-06 15:39:09,602 [ec-9] DEBUG ISCKeyedObjectPool - Borrowing object for 'Object'
=== 2014-10-06 15:39:09,603 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2014-10-06 15:39:09,603 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2014-10-06 15:39:09,603 [ec-9] DEBUG ISCKeyedObjectPool - Borrowing object for 'List'
=== 2014-10-06 15:39:09,603 [ec-9] DEBUG ISCKeyedObjectPool - Borrowing object for 'elem'
=== 2014-10-06 15:39:09,604 [ec-9] DEBUG RPCManager - Processing 1 requests.
=== 2014-10-06 15:39:09,604 [ec-9] DEBUG ISCKeyedObjectPool - Borrowing object for 'Operators'
=== 2014-10-06 15:39:09,605 [ec-9] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        id:1
    },
    operationConfig:{
        dataSource:"Operators",
        operationType:"fetch",
        textMatchStyle:"exact"
    },
    componentId:"isc_DynamicForm_0",
    appID:"builtinApplication",
    operation:"Operators_fetch",
    oldValues:{
        id:1
    }
}
=== 2014-10-06 15:39:09,605 [ec-9] INFO  IDACall - Performing 1 operation(s)
=== 2014-10-06 15:39:09,605 [ec-9] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2014-10-06 15:39:09,605 [ec-9] DEBUG DeclarativeSecurity - DataSource Operators is not in the pre-checked list, processing...
=== 2014-10-06 15:39:09,605 [ec-9] DEBUG AppBase - [builtinApplication.Operators_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-10-06 15:39:09,606 [ec-9] DEBUG AppBase - [builtinApplication.Operators_fetch] No public zero-argument method named '_Operators_fetch' found, performing generic datasource operation
=== 2014-10-06 15:39:09,606 [ec-9] DEBUG JPADataSource - [builtinApplication.Operators_fetch] Creating EntityManager and starting transaction.
=== 2014-10-06 15:39:09,607 [ec-1] DEBUG RPCManager - Processing 1 requests.
=== 2014-10-06 15:39:09,607 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'leadsSQL'
=== 2014-10-06 15:39:09,607 [ec-1] DEBUG DSRequest - Caching instance 599 of DS leadsSQL from DSRequest.getDataSource()
=== 2014-10-06 15:39:09,608 [ec-1] DEBUG RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        id:21
    },
    values:{
        id_operator:1,
        phone:"3432342",
        received_at:new Date(1407303667000),
        userCities:51,
        id_status_code:2,
        id_lead_source:3,
        priority_points:7,
        id:21,
        pinCode:"122018",
        id_user:30,
        updated_at:new Date(1407303671000),
        email:"agdeep01291@gmail.com",
        address:"Unit No. 262 & 263, 2nd Floor, Tower B, Spaze iTech Park, Sohna Road, Gurgaon -122018",
        id_organizaion:2,
        id_order:540,
        custName:"jagdeep",
        last_comment_at:new Date(1407303672000)
    },
    operationConfig:{
        dataSource:"leadsSQL",
        operationType:"update",
        textMatchStyle:"exact"
    },
    componentId:"isc_DynamicForm_0",
    appID:"builtinApplication",
    operation:"leadsSQL_update",
    oldValues:{
        id_operator:1,
        phone:"3432342",
        received_at:new Date(1407303667000),
        userCities:51,
        id_status_code:2,
        id_lead_source:3,
        priority_points:7,
        id:21,
        pinCode:"122018",
        id_user:30,
        updated_at:new Date(1407303671000),
        email:"jagdeep01291@gmail.com",
        address:"Unit No. 262 & 263, 2nd Floor, Tower B, Spaze iTech Park, Sohna Road, Gurgaon -122018",
        id_organizaion:2,
        id_order:540,
        custName:"jagdeep",
        last_comment_at:new Date(1407303672000)
    }
}
=== 2014-10-06 15:39:09,608 [ec-1] INFO  IDACall - Performing 1 operation(s)
=== 2014-10-06 15:39:09,608 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'ordersSQL'
=== 2014-10-06 15:39:09,608 [ec-1] DEBUG Relation - Caching instance of toDS 'ordersSQL' in the DSRequest map
=== 2014-10-06 15:39:09,608 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'addressesSQL'
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG Relation - Caching instance of toDS 'addressesSQL' in the DSRequest map
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'usersSQL'
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG Relation - Caching instance of toDS 'usersSQL' in the DSRequest map
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG ISCKeyedObjectPool - Borrowing object for 'user_detailsSQL'
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG Relation - Caching instance of toDS 'user_detailsSQL' in the DSRequest map
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2014-10-06 15:39:09,639 [ec-1] DEBUG DeclarativeSecurity - DataSource leadsSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:09,640 [ec-9] DEBUG DSRequest - [builtinApplication.Operators_fetch] Clobbering existing FreeResourcesHandler of type 'com.isomorphic.jpa.JPA2DataSource' with a 'com.isomorphic.jpa.JPA2DataSource'
=== 2014-10-06 15:39:09,640 [ec-9] DEBUG JPADataSource - [builtinApplication.Operators_fetch] Executing fetch.
=== 2014-10-06 15:39:09,640 [ec-9] WARN  JPADataSource - [builtinApplication.Operators_fetch] Field name: 'id' specified in criteria is not defined in data source. Skipping.
=== 2014-10-06 15:39:09,640 [ec-1] INFO  ServerObject - DMI on Spring bean: LeadService
=== 2014-10-06 15:39:09,640 [ec-9] DEBUG JPADataSource - [builtinApplication.Operators_fetch] Query string: select _Operators, users1 from Operators _Operators  left outer join _Operators.users users1
=== 2014-10-06 15:39:09,689 [ec-9] INFO  DSResponse - [builtinApplication.Operators_fetch] DSResponse: List with 7 items
=== 2014-10-06 15:39:09,690 [ec-9] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2014-10-06 15:39:09,690 [ec-9] DEBUG JPADataSource - Committing current transaction.
=== 2014-10-06 15:39:09,760 [ec-9] DEBUG RPCManager - non-DMI response, dropExtraFields: true
=== 2014-10-06 15:39:09,761 [ec-9] DEBUG JPADataSource - Releasing entity manager.
=== 2014-10-06 15:39:09,764 [ec-9] INFO  Compression - /bmfview/sc/IDACall: 636 -> 239 bytes
=== 2014-10-06 15:39:11,687 [ec-1] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
=== 2014-10-06 15:39:11,688 [ec-1] DEBUG DeclarativeSecurity - DataSource leadsSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,689 [ec-1] DEBUG AppBase - [builtinApplication.leadsSQL_update] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-10-06 15:39:11,690 [ec-1] DEBUG AppBase - [builtinApplication.leadsSQL_update] No public zero-argument method named '_leadsSQL_update' found, performing generic datasource operation
=== 2014-10-06 15:39:11,700 [ec-1] INFO  SQLDataSource - [builtinApplication.leadsSQL_update] Performing update operation with
	criteria: {id:21}	values: {id_operator:1,phone:"3432342",received_at:new Date(1407303667000),userCities:51,id_status_code:2,id_lead_source:3,priority_points:7,id:21,pinCode:"122018",id_user:30,updated_at:new Date(1407303671000),email:"agdeep01291@gmail.com",address:"Unit No. 262 & 263, 2nd Floor, Tower B, Spaze iTech Park, Sohna Road, Gurgaon -122018",id_organizaion:2,id_order:540,custName:"jagdeep",last_comment_at:new Date(1407303672000)}
=== 2014-10-06 15:39:11,702 [ec-1] INFO  SQLValuesClause - [builtinApplication.leadsSQL_update] Ignored data for non-existent or included columns: [phone, userCities, pinCode, email, address, custName]
=== 2014-10-06 15:39:11,714 [ec-1] DEBUG PoolableSQLConnectionFactory - [builtinApplication.leadsSQL_update] Executing pingTest 'select 1 from dual' on connection 888779554
=== 2014-10-06 15:39:11,715 [ec-1] DEBUG SQLConnectionManager - [builtinApplication.leadsSQL_update] Borrowed connection '888779554'
=== 2014-10-06 15:39:11,716 [ec-1] DEBUG SQLTransaction - [builtinApplication.leadsSQL_update] Started new bmf_mar17 transaction "888779554"
=== 2014-10-06 15:39:11,716 [ec-1] DEBUG SQLDriver - [builtinApplication.leadsSQL_update] About to execute SQL update in 'bmf_mar17' using connection'888779554'
=== 2014-10-06 15:39:11,717 [ec-1] INFO  SQLDriver - [builtinApplication.leadsSQL_update] Executing SQL update on 'bmf_mar17': UPDATE leads SET id_lead_source=3, id_operator=1, id_order=540, id_organizaion=2, id_status_code=2, id_user=30, last_comment_at='2014-08-06 11:11:12', priority_points=7, received_at='2014-08-06 11:11:07', updated_at='2014-08-06 11:11:11' WHERE (leads.id=21)
=== 2014-10-06 15:39:11,723 [ec-1] DEBUG SQLDataSource - [builtinApplication.leadsSQL_update] update operation affected 1 rows
=== 2014-10-06 15:39:11,724 [ec-1] INFO  SQLDataSource - [builtinApplication.leadsSQL_update] primaryKeys: {id=21}
=== 2014-10-06 15:39:11,726 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource null, field null
=== 2014-10-06 15:39:11,727 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource leadsSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,727 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource ordersSQL, field id
=== 2014-10-06 15:39:11,728 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource ordersSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,729 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id
=== 2014-10-06 15:39:11,729 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource addressesSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,730 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field street_name
=== 2014-10-06 15:39:11,731 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource addressesSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,732 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource ordersSQL, field id
=== 2014-10-06 15:39:11,733 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id
=== 2014-10-06 15:39:11,733 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id_city
=== 2014-10-06 15:39:11,734 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource ordersSQL, field id
=== 2014-10-06 15:39:11,735 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id
=== 2014-10-06 15:39:11,736 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id_state
=== 2014-10-06 15:39:11,737 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource ordersSQL, field id
=== 2014-10-06 15:39:11,738 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id
=== 2014-10-06 15:39:11,738 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id_country
=== 2014-10-06 15:39:11,739 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource ordersSQL, field id
=== 2014-10-06 15:39:11,740 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field id
=== 2014-10-06 15:39:11,741 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource addressesSQL, field pin_code
=== 2014-10-06 15:39:11,742 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource usersSQL, field id
=== 2014-10-06 15:39:11,742 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource usersSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,743 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource user_detailsSQL, field id
=== 2014-10-06 15:39:11,744 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource user_detailsSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,745 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource user_detailsSQL, field first_name
=== 2014-10-06 15:39:11,745 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] DataSource user_detailsSQL is not in the pre-checked list, processing...
=== 2014-10-06 15:39:11,746 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource usersSQL, field id
=== 2014-10-06 15:39:11,747 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource user_detailsSQL, field id
=== 2014-10-06 15:39:11,748 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource user_detailsSQL, field mobile
=== 2014-10-06 15:39:11,749 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource usersSQL, field id
=== 2014-10-06 15:39:11,750 [ec-1] DEBUG DeclarativeSecurity - [builtinApplication.leadsSQL_update] Processing security checks for DataSource usersSQL, field email
=== 2014-10-06 15:39:11,753 [ec-1] DEBUG AppBase - [builtinApplication.leadsSQL_update, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
=== 2014-10-06 15:39:11,754 [ec-1] DEBUG AppBase - [builtinApplication.leadsSQL_update, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
=== 2014-10-06 15:39:11,762 [ec-1] INFO  SQLDataSource - [builtinApplication.leadsSQL_update, builtinApplication.null] Performing fetch operation with
	criteria: {id:21}	values: {id:21}
=== 2014-10-06 15:39:11,773 [ec-1] INFO  SQLDataSource - [builtinApplication.leadsSQL_update, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause$defaultAnsiJoinClause WHERE $defaultWhereClause
=== 2014-10-06 15:39:11,776 [ec-1] INFO  SQLDataSource - [builtinApplication.leadsSQL_update, builtinApplication.null] 599: Executing SQL query on 'bmf_mar17': SELECT leads.id, leads.id_user_owner, leads.id_order, leads.id_user, leads.id_lead_source, leads.id_operator, leads.id_status_code, leads.id_city, leads.received_at, leads.updated_at, leads.last_comment_at, leads.priority_points, leads.id_organizaion, a1.street_name AS address, a1.id_city AS userCities, a1.id_state AS userState, a1.id_country AS userCountry, addresses.pin_code AS pinCode, a3.first_name AS custName, a3.mobile AS phone, a2.email FROM leads JOIN orders a0 ON leads.id_order = a0.id LEFT OUTER JOIN addresses a1 ON a0.id_address = a1.id JOIN orders ON leads.id_order = orders.id LEFT OUTER JOIN addresses ON orders.id_address = addresses.id JOIN users a2 ON leads.id_user = a2.id JOIN user_details a3 ON a2.id = a3.id WHERE (leads.id=21)
=== 2014-10-06 15:39:11,777 [ec-1] DEBUG SQLDriver - [builtinApplication.leadsSQL_update, builtinApplication.null] About to execute SQL query in 'bmf_mar17' using connection '888779554'
=== 2014-10-06 15:39:11,777 [ec-1] INFO  SQLDriver - [builtinApplication.leadsSQL_update, builtinApplication.null] Executing SQL query on 'bmf_mar17': SELECT leads.id, leads.id_user_owner, leads.id_order, leads.id_user, leads.id_lead_source, leads.id_operator, leads.id_status_code, leads.id_city, leads.received_at, leads.updated_at, leads.last_comment_at, leads.priority_points, leads.id_organizaion, a1.street_name AS address, a1.id_city AS userCities, a1.id_state AS userState, a1.id_country AS userCountry, addresses.pin_code AS pinCode, a3.first_name AS custName, a3.mobile AS phone, a2.email FROM leads JOIN orders a0 ON leads.id_order = a0.id LEFT OUTER JOIN addresses a1 ON a0.id_address = a1.id JOIN orders ON leads.id_order = orders.id LEFT OUTER JOIN addresses ON orders.id_address = addresses.id JOIN users a2 ON leads.id_user = a2.id JOIN user_details a3 ON a2.id = a3.id WHERE (leads.id=21)
=== 2014-10-06 15:39:11,788 [ec-1] INFO  DSResponse - [builtinApplication.leadsSQL_update, builtinApplication.null] DSResponse: List with 1 items
=== 2014-10-06 15:39:11,790 [ec-1] INFO  DSResponse - [builtinApplication.leadsSQL_update] DSResponse: List with 1 items

SmartClient Version: v9.1p_2014-09-01/EVAL Deployment

Tags: None

Blama

Registered Developer

Join Date: Sep 2009

Posts: 6815
#2

6 Oct 2014, 03:18

Hi nitrojin,

I don't think that this is possible. It's not with a single SQL and is also not useful from a logical point of view. See update anomaly.

Best regards,
Blama
Comment
nitrojin

Registered Developer

Join Date: Aug 2014

Posts: 20
#3

6 Oct 2014, 03:35

Thanks Blama. So then am I correct in assuming that a DMI is the only option in this case?
Comment
Blama

Registered Developer

Join Date: Sep 2009

Posts: 6815
#4

6 Oct 2014, 06:21

Hi nitrojin,

I'd assume this. But this is for Isomorphic to answer.

Best regards,
Blama
Comment
nitrojin

Registered Developer

Join Date: Aug 2014

Posts: 20
#5

6 Oct 2014, 23:52

Hi Isomorphic,

I'd appreciate if you can confirm this.

Thanks
Comment
Isomorphic

Administrator

Join Date: May 2006

Posts: 54573
#6

7 Oct 2014, 01:04

DMI is not the *only* way to do it, but yes, you'd have to do something like a DMI or a custom operationBinding that uses server scripting to make multiple updates to appropriate DataSources. Or you could just build the appropriate updates client-side and send them in a queue.

Last edited by Isomorphic; 7 Oct 2014, 01:07.
Comment

Previous template Next

Announcement

Updating includeFrom fields

Comment

Comment

Comment

Comment

Comment