Note that there are some explanatory texts on larger screens.

plurals
  1. USbb89
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI actually ended up creating a view (actually needed 2 for mysql) and then an unmanaged model as you suggested and that worked perfectly. I'll add another post explaining what I did later for those that might be interested. Thanks again for all your help!
      singulars
    2. COThanks for the explanation! That makes a lot of sense. I have tried using the extra clause, however now I'm getting a SQL error. I modified my query to be: MessageLog.objects.filter(logtime__week_day=i) .extra({'date_logged': "date(logtime)"}).values('date_logged') .annotate(num_msgs=Count('id')) .aggregate(Avg('num_msgs')) And the error I get is "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM (SELECT (date(logtime)) AS `date_logged`, COUNT(`myapp_messagelog`.`id' at line 1")
      singulars
    3. COThe whole point is for it to be cut off. Each pane is supposed to be the size of the viewport so that only one pane is visible at a time. My plan is to change which pane is visible by shifting the carousel right and left. So any panes that are off the screen, either to the right or the left, need to be hidden. So if the viewport is 1000px wide then each pane would be 1000px wide. If I wanted to show the first pane I would have left:0 on carousel. If I wanted to show the second pane it would be left:-1000, and so on. Does that make sense?
      singulars
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload