20210916 - Interactive Grid vs Interactive Report (by John Snyders)

어떤 상황에 Interactive Grid를 써야할지, Interactive Report를 써야할지 고민이 되는데 APEX 전문가의 의견을 들어보자 (by John Snyders)

Things IG can do that IR can't

- Edit

- Single or Multiple selection and cell range selection. Selection copy to clipboard.

- Scroll pagination

- Sticky footer

- Advanced JavaScript configuration for other pagination options

- Freeze columns

- Column groups in grid view

- Column heading behaviors sort including sort multiple, resize, reorder

- Has some extra chart view capabilities

- Resizable column widths (table layout fixed)

- Master Detail

- Lazy load [hope to have this in IR for 21.1]

- Fully configurable toolbar and menus through advanced configuration [IR is limited and not documented]

- More column types than IR has

- Column configuration: Alternate label, CSS Class, use as row header

- Has more events and documented APIs

Things IR can do that IG can't

- Table layout auto

- Variable height rows [hope to have this in IG for 21.1]

- Views: pivot, group by

- Computed columns

- Complex filters

- Pagination remembers current page

- Control over pagination control location

- Select text and copy to clipboard (not table/grid aware)

- Has right of interactive report search bar button position

- More declarative control over toolbar

- When more data found message/maximum rows to process

UI differences such as in dialogs and Actions menu. Not sure about differences in download and printing. Minor differences in how Detail and Icon views are configured.

There is a big difference in the implementation architecture with IR being server rendered and IG being client rendered with model veiw separation.

Ref. https://hardlikesoftware.com/weblog/