XF 2.0 How to use display_style_priority in XF2

[SyTry]

Hello,

In XF1.5 I made a page to display the staff. I use display_style_priority to display member in ASC/DESC :

public function getStaffDetails()
{
  return $this->_getDb()->fetchAll("
    SELECT *
    FROM `xf_user`
    INNER JOIN `xf_user_group` ON `xf_user_group`.`user_group_id` = `xf_user`.`display_style_group_id`
    WHERE `is_staff` = '1'
    ORDER BY `display_style_priority` DESC
    ");
}

How can I use it in XF2 ?

Regards, SyTry

 

[XenConcept]

Hello,

What do you want to do ?

Regards

 

[SyTry]

Hello,

What do you want to do ?

Regards

For example : I have a user group legend and I want to set the display in ASC/DESC, how to do it ? In xenForo 1.5 I use this :

ORDER BY `display_style_priority` DESC

Regards, SyTry

 

[XenConcept]

For example : I have a user group legend and I want to set the display in ASC/DESC, how to do it ? In xenForo 1.5 I use this :

ORDER BY `display_style_priority` DESC

Regards, SyTry

Same for XF2. You can use the finder to do it.

https://xenforo.com/xf2-docs/dev/entities-finders-repositories/

 

[SyTry]

Same for XF2. You can use the finder to do it.

https://xenforo.com/xf2-docs/dev/entities-finders-repositories/

Thanks