aggregation framework - Matching on compound _id fields in MongoDB aggregate -

-

i'm mongodb novice please forgive me if question has obvious answer...

context:

i've followed example in mongodb docs implement hierarchical aggregation using map-reduce. example uses "compound" _id field map-reduce key producing aggregate documents this...

{    _id: { u: "rick", d: isodate("2010-10-10t14:00:00z") },    value: {        ts: isodate('2010-10-10t15:01:00z'),        total: 254,        count: 10,        mean: 25.4 } }

this , good. particular use case requires values several similar keys emitted each map step. example...

{    _id: { u: "rick", d: isodate("2010-10-10t14:00:00z"), hobby: "wizardry" },    value: {        ts: isodate('2010-10-10t15:01:00z'),        total: 254,        count: 10,        mean: 25.4 } }  {    _id: { u: "rick", d: isodate("2010-10-10t14:00:00z"), gender: "male" },    value: {        ts: isodate('2010-10-10t15:01:00z'),        total: 254,        count: 10,        mean: 25.4 } }

(the values same, _id keys different.)

this , good.

question:

now i'd aggregate on hierarchical collections (views), contain documents having several different compound _id fields, on documents $matching _id fields. example, i'd aggregate on documents possessing {u: string, d: date, hobby: string} type _id or documents _id of type {u: string, d: date}.

i'm aware can use $exists operator restrict _id fields should , shouldn't permitted, don't want have create separate aggregation each _id (potentially many).

is there simple way of programmatically restricting $matching documents containing (or not containing) particular fields in aggregate?

i think best way address issues storing data differently. "_id" sort of has arbitrary values key , should avoid. store documents as:

{     _id: { u: "rick", d: isodate("2010-10-10t14:00:00z"), type: hobby, value: "wizardry" } } {     _id: { u: "rick", d: isodate("2010-10-10t14:00:00z"), type: gender, value: "male" }, }

and match because simple without having create different match each type.


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

html - Accumulated Depreciation of Assets on php -

-
i have problem table print out asset accumulated depreciation on php, stright line method. $query = mysqli_query($connect, "select current_value, salvage_value, useful_life, placed_service assets"); if(!$query){ echo 'could not run query b: ' . mysqli_error($connect); exit; } while($asset = mysqli_fetch_row($query)){ echo "assets :"; print_r($asset); $month = 12; $year = date('y',strtotime($asset[3])); $first_year = $month - ((int)date('m',strtotime($asset[3]))-1); $last_year = $month - $first_year; $first = round((($asset[0] - $asset[1])/$asset[2])*(($first_year)/12),0); $last = round((($asset[0] - $asset[1])/$asset[2])*(($last_year)/12),0); $others = ($asset[0] - $asset[1])/$asset[2]; echo "<table border=1>"; echo "<tr><th>year</th><th>book value year start</th><th>depreciation expense</th><th...
Read more

#1062 - Duplicate entry '' for key 'unique_id' When Trying to add UNIQUE KEY (MySQL) -

-
Image
i've got error on mysql while trying add unique key. here's i'm trying do. i've got column called 'unique_id' varchar(100). there no indexes defined on table. i'm getting error: #1062 - duplicate entry '' key 'unique_id' when try add unique key. here screenshot of how i'm setting in phpmyadmin: here mysql query that's generate phpmyadmin: alter table `wind_archive` add `unique_id` varchar( 100 ) not null first , add unique ( `unique_id` ) i've had problem in past , never resolved rebuilt table scratch. unfortunately in case cannot there many entries in table already. help! the error says all: duplicate entry '' so run following query: select unique_id,count(unique_id) yourtblname group unique_id having count(unique_id) >1 this query show problem select * yourtblname unique_id='' this show there values have duplicates. trying create unique index on field duplicates. need r...
Read more