Filtering entities by related entity's properties

[yuri]

"view": "Fields.Enum",
"options": [ COPY OPTIONS FROM ACCOUNT ]

[alasdaircr]

So given that this works well, I think I'll look at making it automatic - so the code that creates ormMetadata.php would add every fieldtype that exists as a filter for an entity as a foreign field to any entity which has a relationship with it.

That shouldn't be too tricky to figure out.

[alasdaircr]

Because doing this manually is a bit of a pain.

[alasdaircr]

"view": "Fields.Enum",
"options": [ COPY OPTIONS FROM ACCOUNT ]

I'm looking at Model::getfieldType().

Can you access one models' field defs from another model.

eg

getFieldType: function (field) {
            if (('defs' in this) && ('fields' in this.defs) && (field in this.defs.fields)) {
                if (this.defs.fields[field].type === 'foreign') {
                    model = GET_MODEL_FROM_NAME(this.defs.fields[field].link);
                    return model.defs.fields[field].type;
                }
                else return this.defs.fields[field].type || null;
            }
            return null;
        }, 

[alasdaircr]

More thinking required, but am getting somewhere thanks

[alasdaircr]

So I was looking at this again last night.

During a rebuild, after the Unifier stage, I will scan the metadata and create the foreign fields. I will also modify the clientLayouts so that the filters are available.

But the problem is in the client code, where I need to get the properties of the foreign fields - ie the default option, min/max, enumerations, etc. Do you have a suggestion on how to do that?

[yuri]

You don't need the most of params from foreign field. Only "options".

[alasdaircr]

Yes, but is there a cleaner way to do this, other than scraping through the metadata structure?

[yuri]

Don't think so.

[alasdaircr]

Hi Im revisiting this, as I really need the functionality.

I can get the options for the foreign field from getMetadata() in side views/search/filter.js however how & where do I apply these and to what object?

[hi-ko]

Has the field type foreign for any field except name and id been removed? I can't get this working and can't find any implementation in the code.