StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODISTINCT is not working in join query Cakephp
primarykey
Id
17767683
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-20T23:28:07.450
FavoriteCount
0
LastActivityDate
2013-07-23T05:59:52.047
LastEditDate
2013-07-23T05:59:52.047
LastEditorUserId
1993318
OwnerUserId
1993318
ParentId
0
PostTypeId
1
Score
0
ViewCount
686
LastEditorDisplayName
text
Body
i am working on a Cakephp 2.x i am newbie to cakephp and getting a very hard time to grasp the cake query methods i have implemented a join query but the distinct is not working here is my code what actually i am trying to accomplish : i have a table name Messages in which there are duplicate numbers in field Message.mobileNo ... i just want to pick the distinct numbers and then on the bases of those distinct numbers i am comparing or joining the contacts table in which there are mobileNo,workNo etc fields and checking that wether those numbers are in the contacts table or not .. if they are grab the contact name for me ..hope you understand it so what i did is ... i am trying to get the rows of contacts table against the distnct numbers of Messages table.. <pre><code>function getRecentMessages($userid){ $this->bindModel(array( 'belongsTo' => array( 'Contact' => array( 'className' => 'Contact', 'foreignKey' => false, 'conditions' => array( 'AND' => array( array('OR' => array( array('Message.mobileNo = Contact.mobileNo'), array('Message.mobileNo = Contact.workNo'), array('Message.mobileNo = Contact.homeNo'), array('Message.mobileNo = Contact.other'), )), ) ), 'type' => 'LEFT', 'order'=>'Message.idTextMessage DESC', ) ) ), false); return $this->find('all', array('conditions' => array('Message.User_id' => $userid), 'contain' => array('Contact' ), 'fields' => array(' DISTINCT Message.mobileNo',//distnct not working 'Contact.mobileNo', 'Contact.workNo', 'Contact.homeNo', 'Contact.other', 'Contact.name', 'Message.dateTime', 'Message.type', 'Message.body'), 'limit' => 6)); } </code></pre> i have tried this <pre><code>DISTINCT (Message.mobileNo) as mobileNo </code></pre> but didnt work too i have tried <pre><code> 'group' => 'Message.mobileNo', </code></pre> by using this it works but then the query is not getting the required results .. i mean the DESC condition not works then
Tags
<cakephp><cakephp-2.0><distinct><cakephp-2.1>
Title
DISTINCT is not working in join query Cakephp
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmynameisjohn
UserOwnerUserId
1. USmynameisjohn
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PODISTINCT is not working in join query Cakephp
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PODISTINCT is not working in join query Cakephp
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
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.