soqlDatatable: Limitations

Nested / Inner / Child SOQL is not supported.

For example: SELECT Id, Name, (SELECT Id, Name FROM Contacts) FROM Account.

This is not feasible using lightning-datatable and would instead require something like lightning-tree-grid.

Configurable Flow / LWC actions is only supported on App / Record Page.

Currently, this is disabled when soqlDatatable is on a Screen Flow because it would be possible to create infinite dialogs (nested, with every nested soqlDatatable on a Flow Screen).

Due to this possibility, I have not yet enabled it for Screen Flows.

Additionally, I have not evaluated the UX of overlapping Modal / Dialogs (which is feasible if I were to enable it).

When configuring flow actions, you must include some default input variables.

Please see soqlDatatable configuration.

Inline Edit has a few limitations.

• Keyboard navigation is not supported yet.
• Geolocation fields must be queried with the __Longitude__s and __Latitude__s (capital L).
• Time data type is not yet supported for view or edit.
• RecordType restricted picklist values are supported with a limitation:

  When using mass edit on a Picklist field for a Standard Object enabled with Record Types, it's possible to mass apply a value which does not belong on that table. This seems to be because Standard Object picklist fields do not have the Restrict picklist to the values defined in the value set option.

Aggregate SOQL has a few limitations.

• Using max/min with any Date or DateTime field does not currently display properly.

Links to lookup fields on parent record names don't work.

An issue has been logged but no ETA for fix.

For column sorting, multi-sort and column filtering actions are not supported.