Searching dashboards as a customer with entityquerycontroller

[CalmNite]

Hello,

I was tying out some API endpoints and i came across a bug.

1. I logged in as a customer in the swagger-ui
2. I searched the entity-query-controller, in the endpoint api/entitiesQuery/find
3. I tried to retrieve all the dashboards that I'm allow to view as a client with the following query

{
"entityFields": [],
"entityFilter": { "type": "entityType", "entityType": "DASHBOARD"},
"keyFilters": [],
"latestValues": [],
"pageLink": { "page": 0, "pageSize": 10}
}

I get the following error. If i do the same as a tenant this query will work.

I might be wrong but I understand that the problem is related with dashboards not having a customer_id field in the database

[ashaforost]

Hi @CalmNite

I tested your query on v3.6.4, and it works fine:

The same works with the /api/entitiesQuery/find request.

What's your thingsboard version? Is the installation valid? Maybe there were errors during an upgrade?

[CalmNite]

thanks for the answer @ashaforost

I have installed a new version in a different environment following the documentation in your web.
https://thingsboard.io/docs/user-guide/install/docker/

I have selected the option for kafka. I'm using the image thingsboard/tb-postgres and done all the steps which are indicated in the provided url.

In this version i get the same error but with different log. I have also tried in older version and get a similar error.

Are you logging in as a tenant or a customer?
Am i doing something wrong?

[CalmNite]

i have been checking the source code and i came with the answer myself. i added that code to the defaultPermissionQuery in DefaultEntityQueryRepository and now the query works perfectly

[ashaforost]

@CalmNite

This bug was reported and verified, and the fix is planned for v3.7-3.7.1.
Thank you for reporting the issue and providing a solution!