Yii ORDER BY FIELD() in CDbCriteria

本文关键字：in CDbCriteria FIELD ORDER BY Yii | 更新日期: 2023-09-27

有没有办法使用ORDER BY FIELD（）功能创建CDbCriteria实例？

列glncrna_id，id_list："GlncRNA10003d"、"GlncRNA10027d"、"GlncRNA20024d"

$criteria1->order = "FIELD(glncrna_id, 'GlncRNA10003d', 'GlncRNA10027d', 'GlncRNA20024d')";

或

$criteria1->order = "FIELD('glncrna_id', GlncRNA10003d, GlncRNA10027d, GlncRNA20024d)";

或

$criteria1->order = "FIELD('glncrna_id', 'GlncRNA10003d, GlncRNA10027d, GlncRNA20024d')";

显示一般错误：1 没有这样的函数：字段

$criteria1->order = "FIELD(glncrna_id, GlncRNA10003d, GlncRNA10027d, GlncRNA20024d)";

显示不是 GlncRNA10003d 列

如何在id_list中订购结果？我使用 sqlite 数据库

试试这个：

$criteria1=new CDbCriteria;  <br/>
$criteria1->order="FIELD(glncrna_id,'GlncRNA10003d','GlncRNA10027d','GlncRNA20024d') DESC";

您必须使用

Cshort 来使用不同的顺序

        $sort = new CSort();
        //this should be default order
        $sort->defaultOrder = 't.glncrna_id DESC'; 
        $sort->attributes = array(
            'GlncRNA10003d' => array(
                'asc' => 'GlncRNA10003d asc',
                'desc' => 'GlncRNA10003d desc'
            ),
            'GlncRNA10027d' => array(
                'asc' => 'GlncRNA10003d asc',
                'desc' => 'GlncRNA10027d desc'
            ),
        );
        $dataProvider = new CActiveDataProvider('ModelName', array(
            'criteria' => $criteria,
            'sort' => $sort
        ));