AnsweredAssumed Answered

missing data in the requests table?

Question asked by pmichaud@uw.edu on May 27, 2015
Latest reply on Dec 1, 2015 by Zac Watson

It looks like in our requests table, there are no assignment, conversation, discussion or quiz links:

 

canvas=> select * from requests where quiz_id is not null or conversaion_id is not null or discussion_id is not null or assignment_id is not null limit 10;

id | user_id | course_id | account_id | user_account_id | course_account_id | url_id | quiz_id | discussion_id | conversaion_id | assignment_id | url | timestamp | user_request | user_agent | participated | http_method | remote_ip | interaction_micros

----+---------+-----------+------------+-----------------+-------------------+--------+---------+---------------+----------------+---------------+-----+-----------+--------------+------------+--------------+-------------+-----------+--------------------

(0 rows)

 

I found one of my requests, by querying using the user_id and url, (select * from requests where user_id = 284958281182175157 and url like '%/assignments/%';) and found this id in the list:

 

canvas=> select * from requests where id = '0477fec0-cd9c-0131-1377-1238d537ad9d';

                  id                  |      user_id       |    course_id    | account_id | user_account_id | course_account_id |     url_id      | quiz_id | discussion_id | conversaion_id | assignment_id |                 url                 |      timestamp      | user_request |                                    user_agent                                     | participated | http_method | remote_ip | interaction_micros

--------------------------------------+--------------------+-----------------+------------+-----------------+-------------------+-----------------+---------+---------------+----------------+---------------+-------------------------------------+---------------------+--------------+-----------------------------------------------------------------------------------+--------------+-------------+-----------+--------------------

0477fec0-cd9c-0131-1377-1238d537ad9d | 284958281182175157 | 100000000893967 |            |                 |                   | 100000002467387 |         |               |                |               | /courses/893967/assignments/2467387 | 2014-06-03 22:26:24 |              | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0 |              | GET         |           |             932489

(1 row)

 

based on the output of select * from assignment_dim where canvas_id = 2467387; I would expect the assignment_id column in that result to have the value 100000002467387

 

Is that field intentionally left blank?  The ER diagram shows links to the correct tables.

Outcomes