MU
Maciej UrmańskiFeb. 20, 2019, 9:11 a.m.

User attendance in app

django, python, Django

Hi, i try to create list of users attendance in goal app.

But i don't know how to filter user.

I have Goal model:

class Goal(models.Model, Activity):
    title = models.CharField(max_length=255, verbose_name='Tytuł')
    image = ImageField(blank=True, verbose_name='Tło')
    body = HTMLField(verbose_name='Treść')
    tags = TaggableManager()
    created_at = models.DateTimeField(auto_now_add=True)
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    slug = AutoSlugField(populate_from='title')

and Joined model:

class Joined(models.Model, Activity):
    goal = models.ForeignKey(Goal, on_delete=models.CASCADE, related_name='joined')
    user = models.ForeignKey(User, on_delete=models.CASCADE, related_name='joined_users')
    created_at = models.DateTimeField(auto_now_add=True)
    joined = models.BooleanField(default=False)

I try:

def goalusers(request, slug):
    goal = get_object_or_404(Goal, slug=slug)

    users = goal.joined_users.all()

    return render(request, 'goals/users.html',
                {'goal': goal,
                'users': users})

This makes error: 'Goal' object has no attribute 'joined_users'.

I try also:

users = User.objects.filter(joined_users__joined__in=goal)

but then error is:
'Goal' object is not iterable.

We recommend hosting TIMEWEB
We recommend hosting TIMEWEB
Stable hosting, on which the social network EVILEG is located. For projects on Django we recommend VDS hosting.

Do you like it? Share on social networks!

4
Evgenii Legotckoi
  • Feb. 20, 2019, 9:29 a.m.

Hello,

For second solution try this

users = User.objects.filter(joined_users__joined__in=[goal])

For first solution I think need to use annotate or aggregate methods, but it may be slowly and strongly.

    MU
    • Feb. 20, 2019, 9:52 a.m.

    Now error say: ["Value 'Test' must be True or False."]

      Evgenii Legotckoi
      • Feb. 20, 2019, 9:57 a.m.

      For me it is unexpected error.

      What is 'Test' value? Do you use some object, in which exists some Test variable or member?

      Do you have applied migrations?

        MU
        • Feb. 20, 2019, 10:06 a.m.
        • The answer was marked as a solution.

        Yes, ok I have solution!

        Thank you for directing me about annotate.:)

        Solution is:

        users_in = User.objects.filter(joined_users__goal=goal, joined_users__joined=True)
        

          Comments

          Only authorized users can post comments.
          Please, Log in or Sign up
          AD

          C ++ - Test 004. Pointers, Arrays and Loops

          • Result:50points,
          • Rating points-4
          m

          C ++ - Test 004. Pointers, Arrays and Loops

          • Result:80points,
          • Rating points4
          m

          C ++ - Test 004. Pointers, Arrays and Loops

          • Result:20points,
          • Rating points-10
          Last comments
          i
          innorwallNov. 15, 2024, 5:30 p.m.
          Qt/C++ - Lesson 065. The correspondence of HTTP errors to server response errors in QNetworkAccessManager s Midsummer Classic in Kansas City priligy online pharmacy
          i
          innorwallNov. 15, 2024, 4:44 p.m.
          Qt/C++ - Lesson 039. How to paint stroke in QSqlTableModel by value in the column? Many OPKs would advise users to start using the test strips around day 9 of your cycle, considering day 1 to be the first day of full menstrual flow buy priligy australia
          i
          innorwallNov. 15, 2024, 1:27 p.m.
          Release of C++/Qt and QML application deployment utility CQtDeployer v1.4.0 (Binary Box) optionally substituted alkoxy, optionally substituted alkenyloxy, optionally substituted alkynyloxy, optionally substituted aryloxy, OCH, OC H, OC H, OC H, OC H, OC H, OC H, O C CH, OCH CH OH, O…
          i
          innorwallNov. 15, 2024, 8:26 a.m.
          Qt/C++ - Lesson 031. QCustomPlot – The build of charts with time buy generic priligy We can just chat, and we will not lose too much time anyway
          i
          innorwallNov. 15, 2024, 6:03 a.m.
          Qt/C++ - Lesson 060. Configuring the appearance of the application in runtime I didnt have an issue work colors priligy dapoxetine 60mg revia cost uk August 3, 2022 Reply
          Now discuss on the forum
          t
          tonypeachey1Nov. 15, 2024, 5:04 p.m.
          google domain [url=https://google.com/]domain[/url] domain [http://www.example.com link title]
          i
          innorwallNov. 15, 2024, 4:50 p.m.
          добавить qlineseries в функции priligy for sale Gently flush using an ear syringe
          i
          innorwallNov. 11, 2024, 9:55 p.m.
          Всё ещё разбираюсь с кешем. priligy walgreens levitra dulcolax carbs The third ring was found to be made up of ultra relativistic electrons, which are also present in both the outer and inner rings
          9
          9AnonimOct. 25, 2024, 7:10 p.m.
          Машина тьюринга // Начальное состояние 0 0, ,<,1 // Переход в состояние 1 при пустом символе 0,0,>,0 // Остаемся в состоянии 0, двигаясь вправо при встрече 0 0,1,>…

          Follow us in social networks