Relation filter problem

[crisleiria]

Hello,

I am getting the same error from this issue #455, but from a dexexpress datagrid. Same scenario kpi table as a one to many relation to section table.

AppServiceProvider.php

Lodata::discoverEloquentModel(Kpi::class);
Lodata::discoverEloquentModel(Section::class);
Lodata::getEntitySet('Kpis')->discoverRelationship('section');

relation on Model Kpi.php

#[LodataRelationship]
public function section()
{
  return $this->belongsTo(Section::class,'section_id');
}

devexpress datasource object

dataSource : {
        store : {
            type : 'odata',
            url : '/odata/kpis',
            key: 'id',
            version : 4,
            beforeSend: function (e) {
                e.headers = {
                    'OData-Version': '4.0',
                };
            },
        },
        expand : ['section']
    }

It work, data is displayed. But when I try to search the name field on section object, I am getting the error:

E4018 - The server has returned a non-numeric value in a response to an item count request. See: http://js.devexpress.com/error/22_2/E4018

And this is the json from server

{
    "@context": "http://localhost:81/odata/$metadata#Kpis",
    "value": [OData-error: {
            "code": "expression_parser_error",
            "message": "Encountered an invalid symbol at: contains(tolower(section/>n<ame),'example')",
            "target": null,
            "details": [],
            "innererror": {}
}

this is the request made by the data grid component

http://localhost:81/odata/Kpis?$filter=contains(tolower(section/name),'example')&$top=0&$count=true

[mgerzabek]

Did you find a solution for that?
To me it looks like your client did not encode the filter for the expanded entity correct. It should be something like

http://localhost:81/odata/Kpis?$filter=section/any(section:contains(tolower(section/name),'example'))&$top=0&$count=true?

[crisleiria]

Customer decided to remove that column..
I did not explore all datagrid option.. problably was some setting on grid not set.
Without relations it works great.

[mgerzabek]

Hi @crisleiria,
Maybe then it's a good idea to close this issue?

[crisleiria]

Yes, you can close. If I come back to this, I will report.

[mgerzabek]

Only the owner of the issue, which is you @crisleiria or the owner of the repo can close an issue ;-)