Filtering on Computed Columns

[arbela-cyberillium]

I have a table with many to one relationship (affected_entity -> entity)

When I query affected_entity, I want to filter by the fields of entity table.
But the only filters I have are like:

affected_entityFilter

Fields
id: UUIDFilter
entity_id: UUIDFilter

In the affected_entity node I can access entity, but without filters

Can I help in any way?

[arbela-cyberillium]

I can create a Computed Field, with

CREATE OR REPLACE FUNCTION public._affected_entity_entity_name(ae public.affected_entity) 
RETURNS TEXT AS $$
DECLARE 
    entity_name TEXT;
BEGIN
    SELECT name INTO entity_name
    FROM public.entity
    WHERE id = ae.entity_id
    LIMIT 1;

    RETURN entity_name;
END;
$$ LANGUAGE plpgsql;

but I can not filter it as well. if we add support to filtering Computed Fields, maybe it will be a good enough workaround, and easier to implement

[olirice]

Sorry I must have linked to the wrong issue in my PR. This isn't resolved.

your request from the first comment is a dupe of #88

but your comment about filtering on computed columns is a good one. I'm going to change the title of this issue to that and re-open