XF 2.0 Questions related to XenForo Finder

[Finexes]

Hey guys,

I'd need a little help with the XenForo Finder as I am completely new to this.

1) I am using the XenForo Finder to show members of specific usergroups in my template. Currently, the specific part of my PHP code looks like this:

$usersMember = \XF::finder('XF:User')->where('secondary_group_ids', 48)->order('username', 'ASC')->fetch();

That works as expected, except there's one problem: Our users have several secondary user groups. When a user has the secondary groups

48, 50, 51

, it works. But when the user is member of groups

37, 48, 50

, it doesn't, although he is part of group 48. Does anyone have a solution for this?

2) Later I would also like to show members that ticked a specific profile field. Would it be possible using the Finder?

Thank you very much for your input, it's appreciated

 

[Finexes]

Anyone able to help?

 

[CMTV]

Basically, you need this: https://stackoverflow.com/questions/5033047/mysql-query-finding-values-in-a-comma-separated-string

Also, in order to build such a query, you need to use ->whereSql(...) function:

$userMember = \XF::finder('XF:User')->whereSql('FIND_IN_SET(48, secondary_group_ids) <> 0')->order...

But FIND_IN_SET might be not available since it is a MySQL function...

 

[Finexes]

Fantastic, that works great! Thank you very much CMTV

Now I just a need a solution for selecting users with a specific profile field ticked.

 

[Lukas W.]

But FIND_IN_SET might be not available since it is a MySQL function...

XF2 currently only supports MySQL/MariaDB, so that function is basically available to everyone at the moment.