Grid Help

I am passing an array of contact ids to grid. I want to select all the contact ids in passed array.

This only works when I have one value in the attendees array. Anything more, I get no result in grid. What am I doing wrong?

PHP

{% set gridData = dataGrid.renderGrid(gridName, {attendees: [12,76]}, { cssClass: 'inner-grid' }) %} campuscontact-group-contacts-grid: acl_resource: oro_contact_view source: type: orm query: select: - c.id - c.firstName - c.lastName - > (CASE WHEN (:attendees IS NOT NULL) THEN CASE WHEN (c.id IN (:attendees) OR c.id IN (:data_in)) AND c.id NOT IN (:data_not_in) THEN true ELSE false END ELSE CASE WHEN c.id IN (:data_in) AND c.id NOT IN (:data_not_in) THEN true ELSE true END END) as hasGroup from: - { table: %oro_contact.entity.class%, alias: c } bind_parameters: - attendees columns: hasGroup: label: oro.contact.group.has_group.label editable: true frontend_type: boolean id: label: 'id' firstName: label: oro.contact.first_name.label lastName: label: oro.contact.last_name.label properties: id: ~ filters: columns: hasGroup: data_name: hasGroup type: boolean firstName: type: string data_name: c.firstName lastName: type: string data_name: c.firstName sorters: columns: hasGroup: data_name: hasGroup firstName: data_name: c.firstName lastName: data_name: c.lastName default: { hasGroup: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC } options: entityHint: contacts rowSelection: dataField: id columnName: hasGroup selectors: included: '#groupAppendContacts' excluded: '#groupRemoveContacts'

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

{% set gridData = dataGrid.renderGrid(gridName, {attendees: [12,76]}, { cssClass: 'inner-grid' }) %}   campuscontact-group-contacts-grid:         acl_resource: oro_contact_view         source:             type: orm             query:                 select:                     - c.id                     - c.firstName                     - c.lastName                     - >                       (CASE WHEN (:attendees IS NOT NULL) THEN                         CASE WHEN (c.id IN (:attendees) OR c.id IN (:data_in)) AND c.id NOT IN (:data_not_in)                         THEN true ELSE false END                       ELSE                         CASE WHEN c.id IN (:data_in) AND c.id NOT IN (:data_not_in)                         THEN true ELSE true END                       END) as hasGroup                 from:                     - { table: %oro_contact.entity.class%, alias: c }             bind_parameters:                 - attendees         columns:             hasGroup:                 label: oro.contact.group.has_group.label                 editable: true                 frontend_type: boolean             id:                 label: 'id'             firstName:                 label: oro.contact.first_name.label             lastName:                 label: oro.contact.last_name.label         properties:             id: ~         filters:             columns:                 hasGroup:                     data_name: hasGroup                     type:  boolean                 firstName:                     type: string                     data_name: c.firstName                 lastName:                     type: string                     data_name: c.firstName         sorters:             columns:                 hasGroup:                     data_name: hasGroup                 firstName:                     data_name: c.firstName                 lastName:                     data_name: c.lastName             default: { hasGroup: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC }         options:             entityHint: contacts             rowSelection:                 dataField: id                 columnName: hasGroup                 selectors:                     included: '#groupAppendContacts'                     excluded: '#groupRemoveContacts'

Topic

[zhex900Participant]

Fixed it!

PHP

campuscontact-group-contacts-grid: acl_resource: oro_contact_view source: type: orm query: select: - c.id - c.firstName - c.lastName - > CASE WHEN (c.id IN (:attendees) OR c.id IN (:data_in)) AND c.id NOT IN (:data_not_in) THEN true ELSE false END as hasGroup from: - { table: %oro_contact.entity.class%, alias: c } bind_parameters: - attendees columns: hasGroup: label: oro.contact.group.has_group.label editable: true frontend_type: boolean id: label: 'id' firstName: label: oro.contact.first_name.label lastName: label: oro.contact.last_name.label properties: id: ~ filters: columns: hasGroup: data_name: hasGroup type: boolean firstName: type: string data_name: c.firstName lastName: type: string data_name: c.firstName sorters: columns: hasGroup: data_name: hasGroup firstName: data_name: c.firstName lastName: data_name: c.lastName default: { hasGroup: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC } options: entityHint: contacts rowSelection: dataField: id columnName: hasGroup selectors: included: '#groupAppendContacts' excluded: '#groupRemoveContacts'

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

campuscontact-group-contacts-grid:         acl_resource: oro_contact_view         source:             type: orm             query:                 select:                     - c.id                     - c.firstName                     - c.lastName                     - >                         CASE WHEN (c.id IN (:attendees) OR c.id IN (:data_in)) AND c.id NOT IN (:data_not_in)                         THEN true ELSE false END                         as hasGroup                 from:                     - { table: %oro_contact.entity.class%, alias: c }             bind_parameters:                 - attendees         columns:             hasGroup:                 label: oro.contact.group.has_group.label                 editable: true                 frontend_type: boolean             id:                 label: 'id'             firstName:                 label: oro.contact.first_name.label             lastName:                 label: oro.contact.last_name.label         properties:             id: ~         filters:             columns:                 hasGroup:                     data_name: hasGroup                     type:  boolean                 firstName:                     type: string                     data_name: c.firstName                 lastName:                     type: string                     data_name: c.firstName         sorters:             columns:                 hasGroup:                     data_name: hasGroup                 firstName:                     data_name: c.firstName                 lastName:                     data_name: c.lastName             default: { hasGroup: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_DESC }         options:             entityHint: contacts             rowSelection:                 dataField: id                 columnName: hasGroup                 selectors:                     included: '#groupAppendContacts'                     excluded: '#groupRemoveContacts'

[Author]

Replies