Hello,
I'm developing a plugin for K2, where you can select an extra value in the k2 user profile, using your example plugin, to add a fields to the user profile form, i have:
<params group="user">
<param name="userCustomGroup" type="list" size="3" label="userCustomGroup" description="Select which group you belong to">
<option value="B">Business</option>
<option value="M">Media</option>
<option value="S">Sales</option>
</param>
</params>
This works great, and I can see the value is stored in the database in the _k2_users table, in the 'plugins' column, say I selected the 'Media' option in my user profile, the value in the database is {"notifieruserCustomGroup":"M"}
My question is, how can I retrieve a list of all users from the database who have this value stored?