Skip to content

Error filtering by 'author' in dataset 'api.assessment' #62

@SergioZSZ

Description

@SergioZSZ

Context
We are using DASHVerse at UPM to track the repos of our research group.

Describe the bug

When filtering by author in DashVERSE 0.2.0, the query fails with a PostgreSQL error instead of returning the filtered rows.

Example error:

Unexpected error
Error: invalid input syntax for type json
LINE 3: WHERE author = 'SergioZSZ' GROUP BY id, author 
                       ^
DETAIL:  Token "SergioZSZ" is invalid.
CONTEXT:  JSON data, line 1: SergioZSZ

I uploaded to DashVERSE DDBB by postgrest service a JSON-LD adding the keys '@id' and 'author' by my own, with the format:

      "@id": "https://github.com/SergioZSZ/Software-Quality-Observatory-Orchestrator-TFG/assessment/2026-04-16T11:18:46Z",
      "author": "SergioZSZ"

To Reproduce
Steps to reproduce the behavior:

  1. Insert the example.json in DashVERSE DDBB
  2. Go to a chart or dataset based on api.assessment.
  3. Add a filter using (for example) author = 'SergioZSZ'.
  4. Run the query.
  5. See the error.

Expected behavior

The filter should work normally and return only the rows where author = 'oeg-upm', without raising a JSON syntax error.

I`m attaching an example JSON-LD that works to reproduce the error. Just try to filter it by author in api.assessment dataset to reproduce it.

json_example.json

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions