Skip to content

soqlDatatable: Limitations

Jump to bottom
James Hou edited this page Jan 31, 2021 · 3 revisions

  1. Nested / Inner / Child SOQL is not supported.

    • e.g. 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.

  2. Configurable Flow / LWC actions is only supported on App / Record Page. It does not work in Screen Flows.

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

  4. 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.

  5. Aggregate SOQL has a few limitations:

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

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

Clone this wiki locally