This topic contains 2 replies, has 2 voices, and was last updated by Bill Curtis 10 years ago.
- Topic
I’m creating a datagrid where the data displayed is not from the DB but rather fetched via a REST web service. Is there a way to set the source of my grid via code (maybe in the controller)?
Here’s a common config as found in OroCRMCallBundle where type is orm. Perhaps another type could accomplish this?
123456789101112131415161718192021calls-grid:source:type: ormacl_resource: orocrm_call_viewquery:select:- call.id- CONCAT(contact.firstName, CONCAT(' ', contact.lastName)) as contactName- account.name as accountName- call.subject- CONCAT(CASE WHEN call.phoneNumber IS NOT NULL THEN call.phoneNumber ELSE contactPhone.phone END, '') as phone- call.callDateTime as dateTimefrom:- { table: %orocrm_call.call.entity.class%, alias: call }join:left:- { join: call.relatedContact, alias: contact }- { join: call.contactPhoneNumber, alias: contactPhone }- { join: call.relatedAccount, alias: account }Thanks in advance
The forum ‘OroPlatform – Programming Questions’ is closed to new topics and replies.