Is there a way to have the results of filtering ranked according to how many filter values they fulfill?
For example, for a filter of "Company activity area" for which the user checked the filter values "industrial maintenance," "cleaning," and "industrial supply," is it possible to have the companies/records which fulfill all 3 of these values appear first, following by those which only fulfill 2 out of 3, and so forth?
To register for the forums, please contact your Digital-Clay representative.
Rating Filter Results
-
ZevToledano
- Posts: 722
- Joined: Fri Apr 03, 2009 2:29 pm
Re: Rating Filter Results
The only solution I can think of uses a complex nested SQL query and this assumes that you are using a linked field for the filter. Any other kind of field wouldn't work.
i.e. the query would be something like: give me a list of records in table A that are linked to records x,y, z in table B, and sort by the count of records B grouped by record A with the same filter values.
Unluckily, this kind of complex query isn't currently possible in Clay, but 'nested query' support is planned for a future version (possibly 9.1).
Unless the filter values are always the same of course, then you can rank the records using automation rules and sort using this ranking field.
i.e. the query would be something like: give me a list of records in table A that are linked to records x,y, z in table B, and sort by the count of records B grouped by record A with the same filter values.
Unluckily, this kind of complex query isn't currently possible in Clay, but 'nested query' support is planned for a future version (possibly 9.1).
Unless the filter values are always the same of course, then you can rank the records using automation rules and sort using this ranking field.