[OzzModz] Thread Field Filter 2.0.1 Patch Level 2

[Ozzy47]

Ozzy47 submitted a new resource:

[OzzModz] Thread Field Filter - Filter threads by custom fields values

Requirements:
XenForo 2.2.0+

Description:

Filter threads by custom fields values

Features:

• Node-dependent permission to allow filtering thread list by custom field values
• Option to disable field in forum filters
• All standard field types is supported (like multiselect, checkboxes and stars)

View attachment 259863

View attachment 259864

View attachment 259865

Read more about this resource...

 

[Tamasita]

Hello @Ozzy47

This addon is very useful. Is it would be possible to show the selected filters on the filter bar too?

 

[Russ]

Having trouble with this one. I have a simple check box a custom thread field.





I have a few threads with it enabled:


I see it in the filter:



But it returns no results.


Permissions are good as well: [OzzModz] Thread Field Filter: Can use Yes


Any thoughts? Am I missing something?

 

[PASS]

Hello @Ozzy47

This addon is very useful. Is it would be possible to show the selected filters on the filter bar too?

View attachment 269652

I would like to see this added also to stay consistent with how other filters are removed.

 

[Ozzy47]

Ozzy47 updated [OzzModz] Thread Field Filter with a new update entry:

[OzzModz] Thread Field Filter for XenForo 2.2+ Update 2.0.0 Patch Level 1

Fix: passing phrase to phrase_dynamic() (reported by @XDinc)

Read the rest of this update entry...

 

[Robert9]

Is this a good idea to search without an index?

I need an age-field and other integer_fields and think about

• to add it to xf_thread with index
• to use custom_fields and your add-on
• to add a new table made perfect to search for values in for some of my custom_fields.

It will be used only for one subforum and there for maybe 5000 threads; I plan with 10.000 users in a year or two;
the 5000 from the start could be 15.000 threads then, maybe more.

So the question is:
Is there a sense to search in the custom_fields_values when you have 15.000 threads and no index; and this maybe thousand or ten thousands times a day?

 

[Robert9]

This works also with rebuild? If not: how can I rebuild the fieldCache?
How can I recreate the fields itself? I am not sure if my fields are ok, after deleting some fields.

    public function postInstall(array &$stateChanges)
    {
        \XF::runOnce('rebuildFieldCache', function()
        {
            /** @var \XF\Repository\ThreadField $fieldRepo */
            $fieldRepo = $this->app->repository('XF:ThreadField');
            $fieldRepo->rebuildFieldCache();
        });
    }

 

[Robert9]

Add-on works nice for

field age, interger.
=> filter age =35


Add-on does not work for checkbox field like this:

field color, checkboxes
1=>red
2=>yellow
3=>green
4=>blue

 

[Robert9]

I play around and find this for example:

search-term:
%s:1:"70"%

itis not correct, it must be
%s:1:"7"%
%s:2:"70"%
%s:3:"703"%

for example; s=number of digits/chars

 

[Robert9]

Maybe like this?

p/c/forum

                if (is_array($filterValue) && in_array($definition['field_type'], ['multiselect', 'checkbox']))
                {
                    $whereOr = [];
                    foreach ($filterValue as $value)
                    {
                        $valueLength = strlen($value);
                        $whereOr[] = ['FieldValue.field_value', 'LIKE', $threadFinder->escapeLike('s:'.$valueLength.':"' . $value . '"', '%?%')];
                    }

                    $threadFinder->whereOr($whereOr);
                }

 

[Robert9]

There is no check for the used fields in a forum?

 

[Robert9]

You don't want to repair it?
There are more strange things.

I am forced to fill fields in the filter.
If I force myself or users to fill in custom fields, this in one thing,
but to force me or them to use the filters in the same way makes no sense!

 

[Dannymh]

The custom field filter does not respect the forum restriction for the custom field, so a custom field that is only for one specific forum, shows across all forums.

 

[Robert9]

I have uninstalled it, from my point of view this add-on is not finished.
Instead of this, i use an additional search table now.

 

[Ozzy47]

Ozzy47 updated [OzzModz] Thread Field Filter with a new update entry:

[OzzModz] Thread Field Filter for XenForo 2.2+ Update 2.0.1 Patch Level 1

2.0.1 Patch Level 1:

• Fix: multi-selection & checkboxes fields search (thanks to Robert9)
• Fix: filter available fields in the forum

Read the rest of this update entry...

 

[d.kavelin]

it fails if you have two or more custom field with "select" type
because you will get this conditions
* WHERE field_id='field_id1' AND field_value='field_value1' AND field_id = 'field_id2' AND field_value='field_value2'

profiler says "Impossible WHERE"

 

[Ozzy47]

Ozzy47 updated [OzzModz] Thread Field Filter with a new update entry:

[OzzModz] Thread Field Filter for XenForo 2.2+ Update 2.0.1 Patch Level 2

2.0.1 Patch Level 2:
Fixed search by multiple custom fields

Read the rest of this update entry...