我想使用此查詢從數(shù)據(jù)庫中查找所有數(shù)據(jù)： $dataSearch = House::find() ->select(["number","DATE(reg_date) AS date","((value) > 100) AS result","info"]) ->join("INNER JOIN", Owner::tableName(), Owner::tableName().'.number_ow= '.House::tableName().'.number_ow') ->andWhere([House::tableName().'.number_ow'=>$house->number_ow]) ->andFilterWhere([House::tableName().'.space'=>$space]) ->orderBy([House::tableName().'.reg_date'=>SORT_DESC,'info'=>SORT_ASC]); $data = $dataSearch->asArray()->all();如果我執(zhí)行查詢all()只返回結(jié)果的一小部分，但如果我對(duì)數(shù)據(jù)庫執(zhí)行原始 SQL 查詢，我會(huì)得到所有結(jié)果。我不明白問題出在哪里。這是原始 SQL：SELECT `number`, DATE(reg_date) AS date, ((value) > 100) AS result, `info` FROM `ho_house` INNER JOIN `ho_owner` ON ho_owner.number_ow = oh_ho_house.number_ow WHERE (`ho_house`.`number_ow`=2100174106) AND (`ho_house`.`space`='m')ORDER BY `ho_house`.`reg_date` DESC, `info`
使用 all() 的 Yii2 查詢返回的數(shù)據(jù)少于預(yù)期
桃花長(zhǎng)相依
2022-01-02 17:18:52
