Data and Analytics

Join

Why are there three ObjectId fields in the Content Objects data set?

Jennifer.W.973
Jennifer.W.973 Posts: 418 🎆
in Social Groups

We're trying to pull due dates for Discussion Topics that are added to the associated Content item. There are three fields in Content Objects - ObjectId1, ObjectId2, and ObjectId3 - and the documentation for all three is: "Object ID, depending on the type of associated tool: TopicId, ChecklistId, SurveyId, QuizId, DropboxId, ChatId, Self-AssessmentId. Field can be null."

Why are there three fields for this association? I'm not understanding how/why one Content item would have three different associated tools. Do I need to look at all three ObjectId fields when I'm trying to join Discussion Topics to Content Topics on TopicId?

· Share on Twitter

Best Answer

  • Bruce.B.64
    Bruce.B.64 Posts: 54
    Answer ✓

    Hi Jennifer! Thank you for reaching out (again). I've been speaking with our data analytics SMEs on our side to get you an answer. The three objectIDs are multi-purposed for having different information based on the tool information.

    For example: If your tool is ToolID 3000 (Discussions) - this would then fill in the fields as:

    ObjectID1 = QuickLink to Forum

    ObjectID2 = Quicklink to Topic

    ObjectID3 = Quicklink to Thread

    As you can tell, the behaviour is different by tool; and not all fields need to be populated in order to have the information present.

    I'm going to continue the conversation internally and i'll follow-up in the near future once we have a supporting article to accompany the information in our Brightspace Data Sets.

    · Share on Twitter

Answers

  • Bruce.B.64
    Bruce.B.64 Posts: 54

    Hi Jennifer - I've reached out to some internal folks to help answer the question. Based on my experience, I believe that content objects can be linked to different tools (eg. Assignments, Discussions, etc) which is the reason for one of the three ObjectId fields (ObjectID1).

    The other two I want to get clarity on this before responding in more detail (I believe these may be related to Grade Object IDs or the External LTI Link ID information). I'll edit this post once I get more information for you.

    · Share on Twitter
  • Jennifer.W.973
    Jennifer.W.973 Posts: 418 🎆

    Thanks Bruce. Would I only need to look in ObjectId1 then if I'm looking for the TopicId for a Discussion topic that was added to Content? It would be great if ObjectId2 was for Grade Object IDs since we were originally trying to just connect Grade Results to Content Items (to pull the due date on a discussion topic that was already graded).

    The documentation is just not clear on how ObjectId1, 2, and 3 are different. It makes it seem like a content item could be three different tools at once - e.g. a topic and a checklist and a survey - which is not possible.

    · Share on Twitter
  • Bruce.B.64
    Bruce.B.64 Posts: 54

    Hi Jennifer;

    Great question regarding the Grade Object ID - which I can answer more readily (but it is a bit complicated). Since content doesn't explicitly have a relationship with the grades tool, the individual tools (Assignments, Discussions, Quizzes, etc) have relationships with the grades tool.

    Although the content experience may visibly look like it has a relationship with the grades tool, the content tool creates a window into the assessment tool and does not have a direct relationship with the grades tool.

    If you are attempting to link from the Content tool to the grades tool, you will need to link up the respective assessment tool (Assignments, discussions, quizzes, etc) and cross-reference the grade object/item ID in that manner.

    I hope that helps with that question, and i'm working with the team on my side to confirm the ObjectID# relationshilp from content.

    — Bruce

    · Share on Twitter

Categories