Forum Discussion

vmalla's avatar
vmalla
Adept
7 years ago

Pulling Users based on criteria

Hi Team,

Is there way to pull all the users who has created threads in a category?

Or Is there a way to pull the users with some criteria like

'SELECT count(*) FROM users WHERE email like '%lithium%'

I'm open to suggestions.

 

 

5 Replies

Sort By
  • cike's avatar
    cike
    Champion
    7 years ago

    Hi vmalla,

    to filter users by criteria you could only use the queries and constraints described in the API documentation.

    Unfortunately, LIQL does not contain a LIKE operator.

     

    Regards,

    Christian

  • srujanayeruvaka's avatar
    srujanayeruvaka
    Champion
    7 years ago

    Hi vmalla,

    As per this documentation, you can pull the users (authors) who have created posts in a 'board' but not at category level. Still achievable through some custom code though.

    Hope this helps!

    Thanks,
    Srujana.

  • cike's avatar
    cike
    Champion
    7 years ago

    While users can only write at the board level and not at the category level, I think you will always need to traverse from board to category (via parent_category or root_category attributes).