Filter by category without the module

I was searching the functionality of adding a sub/category filter, but I see that it is on the module. Any plans to integrate this functionality on the component filters?

Nevermind, I saw the categories core field

Ok, the problem is that it seems I´m not able to get two differents category fields filtering (for example, suppose that I have two classifications, Colors and Number of wheels. I would like to have an articles pages where I can filter by both)

not possible ... need a specific field
with depth option to display only specific level

Mmmm

What if I can use a simpler way?:

I have:
- Main Category Articles
- Secondary categories, different colors

I want to show Articles with the option to filter by colors but colors is not a subcategory from Article.


What about a field type called "secondary categories" for this? that only work as filter

Hello

it is best to use a
select,
multiselect
radio,
radioimage,
checkbox
checkboximage

when you want to achieve such filtering,

i mean avoid creating categories when you can use the above

about the categories filter, this will list subcategories of current category, and it has less filtering options than the category selector of the filtering module

Regards

I see... but sometimes you want to show both orders. Suppose a webpage of cars, organized by country and by brand. You could want a item menu entry to show all the cars from brand X. And another one to show all cars from country Y. In this case, both brand and country works as category and a secondary field.

It´s interesting. Thinking about it maybe I can try to create a select sql field where the values are categories. Mmmm

Ok, I have made something good enough for my needs. Pending more tests, but the main idea seems to work

I have made a select field

The value (hidden):

select fcir.catid as value, c.title as text
from #__flexicontent_cats_item_relations as fcir
left join #__categories as c on fcir.catid = c.id
left join #__categories as cp on c.parent_id = cp.id
where cp.alias = 'countries'
and fcir.itemid = {item->id}


The selector

select fcir.catid as value, c.title as text
from #__categories as c
left join #__flexicontent_cats_item_relations as fcir on fcir.catid = c.id
left join #__categories as cp on c.parent_id = cp.id
where cp.alias = 'countries'


What do you think?

Hello

custom SQL query for select field is there for such needs, if it achieves the desired result for you then i see no problem in using this

Regards

Regarding this, I would like to know:

If I´m using {field->id} on the select, I have the problem that I have to save two times. One to save the field in question and the second one to save the related value (for example, in case I change the category) Is there a way to avoid this?

I was looking at this 8http://www.flexicontent.org/documentation/faq/71-fields-usages-tips-joomla-plugin-/253-creating-relation-between-fields.html), but I´m not sure it can be used for this.