distinct query with lumen and mongodb not working
0
I want to get count of unique value my query is like below,
$query = DB::connection('mongodb')->collection('email_message')
->distinct()->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
it's count value should be 9 and I am getting it as 12.
it is not giving me distinct value.
can any one help me to resolve it out?
I have update my mongodb screen shot below, here I have deleted one record , so it will show total 11 records
php mongodb laravel eloquent
asked Nov 20 at 5:47
hetal gohel
1079
add a comment |
0
I want to get count of unique value my query is like below,
$query = DB::connection('mongodb')->collection('email_message')
->distinct()->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
it's count value should be 9 and I am getting it as 12.
it is not giving me distinct value.
can any one help me to resolve it out?
I have update my mongodb screen shot below, here I have deleted one record , so it will show total 11 records
php mongodb laravel eloquent
asked Nov 20 at 5:47
hetal gohel
1079
2
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
fieldname is missing indistinct()which might be the reason for incorrect results.
– Farooq Khan
Nov 20 at 6:28
add a comment |
0
0
0
I want to get count of unique value my query is like below,
$query = DB::connection('mongodb')->collection('email_message')
->distinct()->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
it's count value should be 9 and I am getting it as 12.
it is not giving me distinct value.
can any one help me to resolve it out?
I have update my mongodb screen shot below, here I have deleted one record , so it will show total 11 records
php mongodb laravel eloquent
asked Nov 20 at 5:47
hetal gohel
1079
I want to get count of unique value my query is like below,
$query = DB::connection('mongodb')->collection('email_message')
->distinct()->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
it's count value should be 9 and I am getting it as 12.
it is not giving me distinct value.
can any one help me to resolve it out?
I have update my mongodb screen shot below, here I have deleted one record , so it will show total 11 records
php mongodb laravel eloquent
php mongodb laravel eloquent
asked Nov 20 at 5:47
hetal gohel
1079
asked Nov 20 at 5:47
hetal gohel
1079
edited Nov 20 at 7:50
asked Nov 20 at 5:47
hetal gohel
1079
asked Nov 20 at 5:47
hetal gohel
1079
asked Nov 20 at 5:47
hetal gohel
1079
1079
2
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
fieldname is missing indistinct()which might be the reason for incorrect results.
– Farooq Khan
Nov 20 at 6:28
add a comment |
2
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
fieldname is missing indistinct()which might be the reason for incorrect results.
– Farooq Khan
Nov 20 at 6:28
2
2
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
field name is missing in distinct() which might be the reason for incorrect results.– Farooq Khan
Nov 20 at 6:28
field name is missing in distinct() which might be the reason for incorrect results.– Farooq Khan
Nov 20 at 6:28
add a comment |
1 Answer
1
active
oldest
votes
1
You didn't mention the distinct('FIELD_NAME') field name.
$query = DB::connection('mongodb')->collection('email_message')
->distinct('email_thread_id')->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
NB:: I have just mention the field name over distinct()
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
|
show 6 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386936%2fdistinct-query-with-lumen-and-mongodb-not-working%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You didn't mention the distinct('FIELD_NAME') field name.
$query = DB::connection('mongodb')->collection('email_message')
->distinct('email_thread_id')->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
NB:: I have just mention the field name over distinct()
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
|
show 6 more comments
1
You didn't mention the distinct('FIELD_NAME') field name.
$query = DB::connection('mongodb')->collection('email_message')
->distinct('email_thread_id')->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
NB:: I have just mention the field name over distinct()
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
|
show 6 more comments
1
1
1
You didn't mention the distinct('FIELD_NAME') field name.
$query = DB::connection('mongodb')->collection('email_message')
->distinct('email_thread_id')->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
NB:: I have just mention the field name over distinct()
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
You didn't mention the distinct('FIELD_NAME') field name.
$query = DB::connection('mongodb')->collection('email_message')
->distinct('email_thread_id')->select("email_thread_id")
->where('email_account_id', (int)$request->email_account_id)
->where('status', "Active")->where('folder_id', "=", $folderId);
$result = $query->count();
NB:: I have just mention the field name over distinct()
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
edited Nov 20 at 6:31
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
answered Nov 20 at 6:13
MD. Jubair Mizan
604511
604511
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
|
show 6 more comments
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
ok, let me check it out
– hetal gohel
Nov 20 at 6:45
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, it is still gives me 12, instead of 9
– hetal gohel
Nov 20 at 7:19
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
it is not working, dear :(
– hetal gohel
Nov 20 at 7:20
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
try to use email_account_id instead of email_thread_id
– MD. Jubair Mizan
Nov 20 at 7:21
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
but I required distinct value of email_thread_id with mongodb
– hetal gohel
Nov 20 at 7:23
|
show 6 more comments
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386936%2fdistinct-query-with-lumen-and-mongodb-not-working%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
"it's count value should be 9 and I am getting it as 12." - This statement requires proof. If you want to say something then you need to provide the means for someone else to reproduce your results.. This also ensures you were not actually mistaken and missed something pretty obvious. Read the link and give people something they can reproduce.
– Neil Lunn
Nov 20 at 5:51
fieldname is missing indistinct()which might be the reason for incorrect results.– Farooq Khan
Nov 20 at 6:28