Jason246
September 2, 2014, 2:24pm
1
Dear all
I’m struggling to understand why my model is returning null values on attributes even when trying to use CDbCriteria.
I have a simple table:
[customer_name, street, city, lat, lon]
At the moment, I only want to return [customer_name, street, city]
If I try use CDbCriteria();
$criteria = new CDbCriteria();
$criteria->select = 'customer_name, street, city';
echo json_encode(Customers::model()->findAll($criteria));
It returns [lat,lon] as null. Even though I don’t want it in the response.
{
"customer_name": "A customer name",
"street": "A street name",
"city": "A city name",
"lat": null,
"lon": null
}
Jason246:
Dear all
I’m struggling to understand why my model is returning null values on attributes even when trying to use CDbCriteria.
I have a simple table:
[customer_name, street, city, lat, lon]
At the moment, I only want to return [customer_name, street, city]
If I try use CDbCriteria();
$criteria = new CDbCriteria();
$criteria->select = 'customer_name, street, city';
echo json_encode(Customers::model()->findAll($criteria));
It returns [lat,lon] as null. Even though I don’t want it in the response.
Print the result without json_encode.
redguy
September 2, 2014, 2:52pm
3
Jason246:
Dear all
I’m struggling to understand why my model is returning null values on attributes even when trying to use CDbCriteria.
I have a simple table:
[customer_name, street, city, lat, lon]
At the moment, I only want to return [customer_name, street, city]
If I try use CDbCriteria();
$criteria = new CDbCriteria();
$criteria->select = 'customer_name, street, city';
echo json_encode(Customers::model()->findAll($criteria));
It returns [lat,lon] as null. Even though I don’t want it in the response.
You query just for specified attributes but it does not change the fact that the model has also other attributes related to other columns in table which is modelled. Model does not change on every single query, because it must provide some common interface.
You need to manually extract attributes to serialize or mess with model meta-functions (CModel::attributeNames() http://www.yiiframework.com/doc/api/1.1/CModel#attributeNames-detail and so on) so that it returns reduced attribute set…
alirz23
September 2, 2014, 3:40pm
4
you can map the array and select the attributes you need
Jason246
September 2, 2014, 3:44pm
5
Thanks for all the suggestions. There was some hope with Scenarios, but that has unfortunately not been able to help.
I’ve decided to quit this struggle and just write a straight up use a DAO object to retrieve the results how I want it.
