Conditional Relationships

[nilios]

I have a unique case where I have a model with a relationship to two other models (ProductCatalog and Peripheral). In my model I have created a 'device' attribute which determines which relationship to return based on the id type of the item. Here's what it looks like:

public function getDeviceAttribute() {
        if($this->inventory_id > 0) {
            return $this->product;
        }

        if($this->peripheral_id > 0) {
            return $this->peripheral;
        }

        return null;
    }

In my table I can then create a column with 'device.name' and it works great. However when I try to search, the search throws an error that 'name' is not a column. I have tried various methods to get this to work with my table from using joins to using a conditional query in the datasource, I even tried create a 'device' method in the model but that didn't work either. Nothing seems to work and I'm starting to get a little frustrated. I'm thinking the answer is probably something simple that I'm overlooking, but if someone could point me in the right direction I would sure appreciate it.

[nilios]

So far the only luck I've had with figuring this out is to check if $this->search has a value and then do my own where checks in the dataSource builder. It works how I want, but there's got to be a better way of doing this as this defeats the whole point of having the 'searchable' functionality.

[luanfreitasdev]

This case seems to be unique. Could you create an example repository working similarly so we can look into it more deeply?

[nilios]

I hope this works for you I tried to do a very simplified version of what I'm doing that directly shows the issue. https://github.com/nilios/powergrid-conditional-relationships

[nilios]

Just checking if anyone had a chance to review this yet? Wondering if this problem is me overlooking something simple or if it is a limitation of Powergrid?

[luanfreitasdev]

I achieved this just by adjusting the relationSearch method

public function relationSearch(): array
{
    return [
        'peripheral' => 'name',
        'product' => 'name'
    ];
}

[nilios]

Thanks for looking into it for me. It is working with the relationSearch. I had tried with that first and it didn't work for me, but now it does. I don't know what I did wrong, but glad it's sorted out now. Thank you!