Codeigniter with MongoDB sub array

Question

I have below type of collection in mongodb:

Array
(
[_id] => 4fcf383a5990581c0b000015
[user_id] => 1
[username] => admin
[password] => 21232f297a57a5a743894a0e4a801fc3
[first_name] => admin
[last_name] => admin
[address] => 
[address_2] => 
 [deshboard_report] => Array
    (
        [0] => Array
            (
                [report_ids] => 1
                [rpt_color] => color-red
                [rpt_status] => max
                [report_title] => Last Point
                [report_file] => last_location
            )
        [1] => Array
            (
                [report_ids] => 2
                [rpt_color] => color-green
                [rpt_status] => max
                [report_title] => Inactive Device
                [report_file] => inactive_devices
            )
    )
)

I want to search in report_ids and that search return sub array of deshboard_report how it is possible?

I use this library to connect: https://github.com/alexbilbie/codeigniter-mongodb-library

just for reference the same question has been asked here as well: groups.google.com/forum/?fromgroups#!topic/mongodb-user/… — Barrie
– Barrie, Commented Jun 6, 2012 at 19:16

Stennie · Accepted Answer · 2012-06-07 16:35:28Z

1

When querying for an element in an array, your results will currently return the whole document by default.

You can return whole documents matching subarrays with specific report_ids using $elemMatch.

Example for the JS shell .. find documents with report_ids=2 :

  db.collection.find({'deshboard_report': {"$elemMatch": {report_ids: 2}}});

answered Jun 7, 2012 at 16:35

Stennie

65.6k15 gold badges155 silver badges181 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Codeigniter with MongoDB sub array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related