use the related name on the staff model for project field with __ lookup as
in
class Staff(models.Model):
.............
.........
....
project = foreignkey relationship (related_name='staffs')
SO the query would be Projects.objects.filter(staffs__project_id=F('pk'))
On Tuesday, 15 June 2021 at 14:13:26 UTC+5:30 eugenet...@gmail.com wrote:
> Team,
>
> I am a little bit confused: I have a table callect Projects and another
> called Staffs. I want a particular staff member to view only the project
> he/she has a role in. In the Staffs table I have a project foreign key
> project_id. But I am confused about how to construct the query. I think of
> the SQL as below
>
> *Select * from Projects where Projects.id = Staffs.projects_id *
>
> I want to transform this query into a django query.
>
> Assist please
>
> --
> *Eugene*
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/6f74a18a-9798-4080-a462-6eff3231d7acn%40googlegroups.com.
