StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCakePHP 2.1 - How to properly use DISTINCT in find()
primarykey
Id
11170885
data
AcceptedAnswerId
11177491
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-06-23T15:52:48.560
FavoriteCount
3
LastActivityDate
2017-10-29T08:37:01.353
LastEditDate
2017-10-29T08:37:01.353
LastEditorUserId
7040040
OwnerUserId
1469742
ParentId
0
PostTypeId
1
Score
10
ViewCount
23073
LastEditorDisplayName
text
Body
I have a question which is driving me crazy and I have to admit I am not that experienced in CakePHP. As mentioned in this question, <a href="https://stackoverflow.com/questions/1718482/using-distinct-in-a-cakephp-find-function">Using DISTINCT in a CakePHP find function</a>, using DISTINCT this way: <pre><code>$this->Model->find('all', array('fields'=>'DISTINCT field_name')); </code></pre> does not return DISTINCT values, instead it returns all rows. In fact, the DISTINCT here is completely pointless because, for some reason , CakePHP adds <code>TableName</code>.<code>id</code>in the SQL query (why?? can I remove the id reference??), effectively returning every DISTINCT primary key (=all rows=unhelpful). So, I still want to return the DISTINCT values of a particular field_name column. Can I not do it using just the find('all') or find('list') function? Is it really that the proper way of doing it using this Set::extract() function described in the link above? That appears to be a overly indirect solution by CakePHP, normally Cake make my life easier. :-) What is the proper way of using find and DISTINCT together? Maybe DISTINCT doesn't work for find()? Looking at the CookBook, they say: "A quick example of doing a DISTINCT query. You can use other operators, such as MIN(), MAX(), etc., in a similar fashion:" <pre><code><?php array( 'fields' => array('DISTINCT (User.name) AS my_column_name'), 'order' = >array('User.id DESC') ) ?> </code></pre> Source: <a href="http://book.cakephp.org/2.0/en/models/retrieving-your-data.html" rel="nofollow noreferrer">http://book.cakephp.org/2.0/en/models/retrieving-your-data.html</a> This indicates that DISTINCT should be possible to use, but what is what here? Does (User.name) correspond to the field_name I want DISTINCT for or is my_column_name my field_name? Finally, has any of this changed when migrating from CakePHP 1.x to CakePHP 2.x? Ie are the answers for CakePHP 1.x seen on Stackoverflow still relevant? Thanks in advance!
Tags
<cakephp><find><cakephp-2.0><distinct><extract>
Title
CakePHP 2.1 - How to properly use DISTINCT in find()
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USalieninlondon
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.