Select All Check Box In Datagrid

Hi Team
How to configure the Select all check box in datagrid.yml. Please Let us know any solution
Thanks and Regards,
Ummar

Topic

[MichaelKeymaster]

Please clarify your question. A screenshot/mockups of what you are trying to achieve may also help.

[ummarfarooq87Participant]

Hi Michel,
Please find the attachment datagrid.yml and UI of datagrid. Please let us know solution for select all checkbox
Thanks and Regards,
Ummar

Attachments:

1. 

[ummarfarooq87Participant]

Please find the datagrids.yml
promotion-partindex-grid:
source:
type: orm
query:
select:
– pind.id
– pind.partindexcode
– pind.partindexlabel
– vo.name
– >
(CASE WHEN (:partindex IS NOT NULL) THEN
CASE WHEN (:partindex MEMBER OF pind.promotions OR pind.id IN (:data_in)) AND pind.id NOT IN (:data_not_in)
THEN true ELSE false END
ELSE
CASE WHEN pind.id IN (:data_in) AND pind.id NOT IN (:data_not_in)
THEN true ELSE false END
END) as hasPartindex

from:
– { table: IZMOPartReferenceBundle:PartIndex, alias: pind }
join:
inner:
– { join: pind.owner, alias:vo }
– { join: IZMOPartReferenceBundle:EnvironmentMaster, alias: env,conditionType: WITH, condition: env.id = pind.environment}
bind_parameters:
–
name: partindex
default: null
type: integer
columns:
hasPartindex:
label: ‘izmo.promotions.promotion.haspartindex.label’
editable: true
frontend_type: boolean
partindexcode:
label: ‘izmo.partreference.partindex.partindexcode.label’
shortenableLabel: false
partindexlabel:
label: ‘izmo.partreference.partindex.partindexlabel.label’
shortenableLabel: false
properties:
id: ~
sorters:
columns:
partindexcode:
data_name: pind.partindexcode
partindexlabel:
data_name: pind.partindexlabel
filters:
columns:
partindexcode:
type: string
data_name: pind.partindexcode
partindexlabel:
type: string
data_name: pind.partindexlabel
options:
entityHint: partindex
rowSelection:
dataField: id
columnName: hasPartindex
selectors:
included: ‘#appendIzmoprompartindex’
excluded: ‘#removeIzmoprompartindex’

• This reply was modified 4 years, 4 months ago by  ummarfarooq87.
• This reply was modified 4 years, 4 months ago by  ummarfarooq87.

[MichaelKeymaster]

If you are asking about how to add “Select All / None / Visible” drop-down to allow users to select multipe records in the datagrid and then perform some action on the selected records – please check https://github.com/oroinc/platform/blob/3.1.17/src/Oro/Bundle/DataGridBundle/Resources/doc/backend/extensions/mass_action.md

[ummarfarooq87Participant]

Hi Michel,
In this datagrid how to implement the select all option

YAML

promotion-partindex-grid: source: type: orm query: select: - pind.id - pind.partindexcode - pind.partindexlabel - vo.name - > (CASE WHEN (:partindex IS NOT NULL) THEN CASE WHEN (:partindex MEMBER OF pind.promotions OR pind.id IN (:data_in)) AND pind.id NOT IN (:data_not_in) THEN true ELSE false END ELSE CASE WHEN pind.id IN (:data_in) AND pind.id NOT IN (:data_not_in) THEN true ELSE false END END) as hasPartindex from: - { table: IZMOPartReferenceBundle:PartIndex, alias: pind } join: inner: - { join: pind.owner, alias:vo } - { join: IZMOPartReferenceBundle:EnvironmentMaster, alias: env,conditionType: WITH, condition: env.id = pind.environment} bind_parameters: - name: partindex default: null type: integer columns: hasPartindex: label: 'izmo.promotions.promotion.haspartindex.label' editable: true frontend_type: boolean partindexcode: label: 'izmo.partreference.partindex.partindexcode.label' shortenableLabel: false partindexlabel: label: 'izmo.partreference.partindex.partindexlabel.label' shortenableLabel: false properties: id: ~ sorters: columns: partindexcode: data_name: pind.partindexcode partindexlabel: data_name: pind.partindexlabel filters: columns: partindexcode: type: string data_name: pind.partindexcode partindexlabel: type: string data_name: pind.partindexlabel options: entityHint: partindex rowSelection: dataField: id columnName: hasPartindex selectors: included: '#appendIzmoprompartindex' excluded: '#removeIzmoprompartindex'

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

promotion-partindex-grid:         source:             type: orm             query:                 select:                     - pind.id                     - pind.partindexcode                     - pind.partindexlabel                     - vo.name                     - >                       (CASE WHEN (:partindex IS NOT NULL) THEN                         CASE WHEN (:partindex MEMBER OF pind.promotions OR pind.id IN (:data_in)) AND pind.id NOT IN (:data_not_in)                         THEN true ELSE false END                       ELSE                         CASE WHEN pind.id IN (:data_in) AND pind.id NOT IN (:data_not_in)                         THEN true ELSE false END                       END) as hasPartindex                                      from:                     - { table: IZMOPartReferenceBundle:PartIndex, alias: pind }                 join:                     inner:                         - { join: pind.owner, alias:vo }                         - { join: IZMOPartReferenceBundle:EnvironmentMaster, alias: env,conditionType: WITH, condition: env.id = pind.environment}             bind_parameters:                 -                     name: partindex                     default: null                     type: integer         columns:             hasPartindex:                 label: 'izmo.promotions.promotion.haspartindex.label'                 editable:      true                 frontend_type: boolean             partindexcode:                 label: 'izmo.partreference.partindex.partindexcode.label'                 shortenableLabel: false             partindexlabel:                 label: 'izmo.partreference.partindex.partindexlabel.label'                 shortenableLabel: false         properties:             id: ~         sorters:             columns:                 partindexcode:                     data_name: pind.partindexcode                 partindexlabel:                     data_name: pind.partindexlabel         filters:             columns:                 partindexcode:                     type:      string                     data_name: pind.partindexcode                 partindexlabel:                     type:      string                     data_name: pind.partindexlabel                     options:             entityHint: partindex             rowSelection:                 dataField: id                 columnName: hasPartindex                 selectors:                     included: '#appendIzmoprompartindex'                     excluded: '#removeIzmoprompartindex'

Thanks and Regards,
Ummar

[Andrey YatsenkoModerator]

To see the “select all” option you have to implement at least one mass action by following the documentation article that Michael shared before.

[Author]

Replies