Using Relationships Children of Relationship in Lookup

[joaonivaldo]

Hello, I need to do a search on a property that is within a child relationship and I'm not getting it. I need to search the property nomeExibicao_nomeFantasia that is inside the RECORD relationship that is inside the OWNER relationship of my PG model. Like this: $rate->owner->record->nomeExibicao_nomeFantasia.

I put the relationSearch like this and it presents the following error:

See that it is looking for the RECORD relationship within the Model RATE. Since in fact the Record is inside the OWNER which is a relationship of the Rate model.

Thanks

[BenOussama180]

can you please show your datasource?

[joaonivaldo]

[BenOussama180]

i think u need to join the tables as said in the documentation
https://livewire-powergrid.com/#/table/datasource?id=join-tables