🐛 Bug: Group-by for belongs-to field throws error

[dstala]

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Steps to reproduce ?

• Country hm City
• On city table, group-by over belongs to column
• Try to remove group by, system crashes

[Nest] 88331  - 12/04/2023, 11:23:48 AM   ERROR [GlobalExceptionFilter] Cannot read properties of null (reading 'title')
TypeError: Cannot read properties of null (reading 'title')
    at /Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/db/BaseModelSqlv2.ts:4464:28
    at async BaseModelSqlv2.substituteColumnIdsWithColumnTitles (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/db/BaseModelSqlv2.ts:4475:25)
    at async BaseModelSqlv2.execAndParse (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/db/BaseModelSqlv2.ts:4428:14)
    at async BaseModelSqlv2.groupBy (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/db/BaseModelSqlv2.ts:721:12)
    at async DatasService.getDataGroupBy (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/services/datas.service.ts:246:18)
    at async DatasService.dataGroupBy (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/services/datas.service.ts:41:12)
    at async DataAliasController.dataGroupBy (/Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/controllers/data-alias.controller.ts:90:12)
TypeError: Cannot read properties of null (reading 'title')
    at /Users/rajuudava/NocoDB/nocodb/packages/nocodb/src/db/BaseModelSqlv2.ts:4464:28
[nodemon] app crashed - waiting for file changes before starting...

Desired Behavior

If we do not support groupby over belongs to, let us not show that info in group by modal

Project Details

Node: v18.14.0
Arch: arm64
Platform: darwin
Docker: false
RootDB: sqlite3
PackageVersion: 0.202.9

Attachments

No response