StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGORM get/find resource by ID using MongoDB in Grails
primarykey
Id
17128436
data
AcceptedAnswerId
17129264
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-15T22:18:50.157
FavoriteCount
0
LastActivityDate
2018-04-18T23:47:53.133
LastEditDate
2015-05-14T04:18:38.877
LastEditorUserId
1553812
OwnerUserId
1553812
ParentId
0
PostTypeId
1
Score
5
ViewCount
4330
LastEditorDisplayName
text
Body
Grails makes it easy to <a href="https://grails.github.io/grails-doc/latest/ref/Domain%20Classes/get.html" rel="nofollow">get</a> a domain object by ID (handy for building a REST API). A controller to retrieve a resource can be as simple as: MetricController.groovy <pre><code>import grails.converters.JSON class MetricController { def index() { def resource = Metric.get(params.id) render resource as JSON } } </code></pre> When using the Grails plugin for MongoDB GORM (<code>compile ":mongodb:1.2.0"</code>), the default <code>id</code> type of <code>Long</code> <a href="http://blog.mongodb.org/post/18510469058/grails-in-the-land-of-mongodb" rel="nofollow">needs to be changed</a> to type <code>String</code> or <code>ObjectId</code>. Metric.groovy <pre><code>import org.bson.types.ObjectId class Metric { static mapWith = "mongo" ObjectId id String title } </code></pre> However, doing a <code>.get(1)</code> will now result in: <pre><code>Error 500: Internal Server Error URI /bow/rest/metric/1 Class java.lang.IllegalArgumentException Message invalid ObjectId [1] </code></pre> I took a guess and changed the controller to use <code>findById</code>: <pre><code>def resource = Metric.findById(new ObjectId(new Date(), params.id.toInteger())) </code></pre> That fixed the error, but it fails to find the object (always returns null). For example, using the id of "-1387348672" does not find this test object: <pre><code>{ "class" : "Metric", "id" : { "class" : "org.bson.types.ObjectId", "inc" : -1387348672, "machine" : 805582250, "new" : false, "time" : 1371329632000, "timeSecond" : 1371329632 }, "title" : "Test" } </code></pre> The <code>ObjectId.inc</code> field may not even be the correct field to use for the resource ID. So, what is the simplest way to retrieve a domain object by ID when using MongoDB?
Tags
<mongodb><rest><grails><gorm><objectid>
Title
GORM get/find resource by ID using MongoDB in Grails
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDem Pilafian
UserOwnerUserId
1. USDem Pilafian
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
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POGORM get/find resource by ID using MongoDB in Grails
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.