Trying to select a group of users by their Extended fields

- 5 Posts
Fredrik Reply #1, 13 years, 11 months ago
Hi,
This might very well be an easy problem for you pro:s to solve but I have hit my wall here.

I want to get a collection of users based on this sql query
```
SELECT id FROM `modx_user_attributes` 
WHERE (`extended` LIKE '%testfield%')
```
If I run the query in mySQL it gives me the id of 10 users out of 11750 how would one get this done in a nice way.

Cheers

5 Posts

Fredrik Reply #2, 13 years, 8 months ago

Just to let anyone else is trying to do sorting / searches on extended fields (Yes I know I should make my own extended DB Table but this site is not my baby..... I got it in my lap and have many other things to fix first)

$c = $modx->newQuery('modUserProfile');
$c->where(array(
    'extended:LIKE' => '%' . $company . '%',
    'AND:extended:LIKE' => '%' . $showdate . '%',
    //'fullname:LIKE' => 'A%',
));

$count = $modx->getCount('modUserProfile',$c);
echo 'UserProfile count: ' . $count . '</br>';

$profiles = $modx->getCollection('modUserProfile',$c);

Cheers