Hi, all. I want to generate a report of my job status in somedays, so I make a QuerySet like following:
==================================== # Generate query set jobs = Job.list(request.REQUEST) #today_jobs = jobs.filter(started_time__gte = date.fromtimestamp (time.time())) 7days_jobs = jobs.filter(started_time__gte = date.fromtimestamp (time.time() - 24 * 60 * 60 * 7)) #30days_jobs = jobs.filter(started_time__gte = date.fromtimestamp (time.time() - 24 * 60 * 60 * 30)) ==================================== The issue is when I place the jobs QuerySet to the new value named 7days_jobs, Django will report ('invalid syntax', ('/Users/xkuang/Documents/Projects/DjangoApp/report/ views.py', 157, 18, ' 7days_jobs = jobs.filter (started_time__gte = date.fromtimestamp(time.time() - 24 * 60 * 60 * 7))\n')) But after I rename the 7days_jobs to jobs it will works fine, But the function I need will can not implemented. Does anybody know are there some solution to resolve it ? BTW: The another very strange thing is to place the QuerySet like following will works fine. ==================================== # Get the lastest jobs of need top_longest_jobs = jobs.order_by('-process_time')[:10] top_recipes_jobs = jobs.order_by('-recipes_count')[:10] ==================================== I'm very confusing in it ... Please help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---