Skip to content

Using insecureRawSQL error #2

@TrilipuT

Description

@TrilipuT

if (filter.field.startsWith('_universal_search_')) {

Seems like this does not include case if insecureRawSQL is used as filter. I have next error once trying using it.

Something like if (filter?.field.startsWith('_universal_search_')) { might be needed there

[13:18:26.786] ERROR (AF): Error in handler TypeError: Cannot read properties of undefined (reading 'startsWith')
[13:18:26.786] ERROR (AF): TypeError: Cannot read properties of undefined (reading 'startsWith')
    at normalizeFilterValue (file:///Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/@adminforth/quick-filters/dist/index.js:59:38)
    at default.<anonymous> (file:///Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/@adminforth/quick-filters/dist/index.js:84:43)
    at Generator.next (<anonymous>)
    at file:///Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/@adminforth/quick-filters/dist/index.js:7:71
    at new Promise (<anonymous>)
    at __awaiter (file:///Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/@adminforth/quick-filters/dist/index.js:3:12)
    at transformer (file:///Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/@adminforth/quick-filters/dist/index.js:83:41)
    at handler (/Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/adminforth/modules/restApi.ts:755:31)
    at async expressHandler (/Users/vitalynikolaiev/LocalSites/adminforth-app/node_modules/adminforth/servers/express.ts:374:18)

my object looks like

 {
  source: 'list',
  resourceId: 'vehicle',
  limit: 50,
  offset: 0,
  filters: [
    { insecureRawSQL: "data @> '[1678]'::jsonb" },
    { field: 'status', operator: 'eq', value: 1 },
    { field: 'id', operator: 'in', value: [Array] }
  ],
  sort: [ { field: 'id', direction: 'desc' } ],
  filtersTools: {
    checkTopFilterExists: [Function: checkTopFilterExists],
    removeTopFilter: [Function: removeTopFilter],
    removeTopFilterIfExists: [Function: removeTopFilterIfExists],
    replaceOrAddTopFilter: [Function: replaceOrAddTopFilter]
  }
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions