You could follow the steps below.
- Create a view function that takes the search parameter as a keyword
argument.
- Use the QuerySet object to filter the Skill table by the search
parameter.
- Use the prefetch_related() method to load the Recruitment objects
associated with the Skill objects.
- Return the Recruitment objects.
I mean something like this
def get_recruitments_by_skill(request, skill):
# Get the skills that match the search parameter.
skills = Skill.objects.filter(sk1=skill)
# Prefetch the recruitments associated with the skills.
skills.prefetch_related('recruitment')
# Return the recruitments.
return render(request, 'recruitments.html', {'skills': skills})
Thanks & Regards,
---------------------
Mayank Tripathi
"Do what you can, with what you have, where you are -by Theodore Roosevelt"
On Sat, May 13, 2023 at 4:56 PM Oduwa Imade <oduwa2...@gmail.com> wrote:
> Hello Guys! How do I write a model query in django python to get the User
> details(Recruitment) when i pass a search parameter( skill) to the Skill
> table?
>
> class Recruitment(models.Model):
> fname = models.CharField(max_length=50)
> lname = models.CharField(max_length=50)
> address = models.CharField(max_length=100)
> phone = models.IntegerField()
> email = models.CharField(max_length=50)
> password = models.CharField(max_length=30)
>
> class CV(models.Model):
> summary = models.TextField()
> f_key_REC = models.ForeignKey(Recruitment, related_name='cv',
> on_delete=models.CASCADE)
>
> class Skill(models.Model):
> sk1 = models.CharField(max_length=100, default=None)
> sk2 = models.CharField(max_length=100, default=None)
> sk3 = models.CharField(max_length=100, default=None)
> fk_sCV = models.ForeignKey(CV, related_name='skill',
> on_delete=models.CASCADE)
>
> --
> 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/c381af8c-e2f7-41b8-ae48-71f389a23459n%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/c381af8c-e2f7-41b8-ae48-71f389a23459n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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/CALQo0B8sRLh-ivziMQSdLN_qqbgn4XyOQS%2BXNkWaH%2BzKm%3D376g%40mail.gmail.com.
