Django community: RSS
This page, updated regularly, aggregates Django Q&A from the Django community.
-
Modify how a field displays on Django tables2 table
I am trying to take a date field and display it in a django tables2 table. The issue is my field uses Djangos DateTimeField and has the time added on to the end which I don't care to display. My initial thought was to use a property decorator, and reference that in my table rather than using my original date field. But when I try to use split inside my property function nothing gets displayed in my table. If I modify the function to just print a string without using split it seems to work as intended. It seems that I can't use split anywhere in the function, even if I return a hard coded string instead of whatever I am splitting. Using split within the function just breaks it and makes it display nothing. Why can I not use split inside my function, and is there an alternative or better way of modifying what the date looks like when it displays on my table? #tables.py class ReportTable(tables.Table): def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs) class Meta: attrs = {"class": "mytable"} model = models.Report fields = ("formatted_date") #models.py class Report(models.Model): id = models.AutoField(db_column="RootCauseID", primary_key=True) date = models.DateTimeField(db_column="date", blank=False, null=True) @property def … -
how fix Django error column accounts_sitename.languageCode does not exist
i create models.py in accounts for the siteName model but i dont know how to fix error it. how fix Django error column accounts_sitename.languageCode does not exist ProgrammingError at /ar/admin/accounts/sitename/ column accounts_sitename.languageCode does not exist LINE 1: ...tename"."user_id", "accounts_sitename"."site_id", "accounts_... ^ class siteName(models.Model): user = models.ForeignKey(User, on_delete=models.CASCADE) site = models.ForeignKey(Site, on_delete=models.CASCADE) languageCode = models.CharField( max_length=10, choices=LANGUAGES,unique=True ) nameHome = models.CharField(max_length=111, blank=True) imageHome = models.ImageField( upload_to='site/' ) bioHome = models.TextField(max_length=5500, blank=True) nameVideo = models.CharField(max_length=111, blank=True) imageVideo = models.ImageField( upload_to='site/' ) bioVideo = models.TextField(max_length=5500, blank=True) nameForum = models.CharField(max_length=111, blank=True) imageForum = models.ImageField( upload_to='site/' ) bioForum = models.TextField(max_length=5500, blank=True) def __str__(self): return self.nameHome ProgrammingError at /ar/admin/accounts/sitename/ column accounts_sitename.languageCode does not exist LINE 1: ...tename"."user_id", "accounts_sitename"."site_id", "accounts_... ^ -
how to use triple nested quotes in django tempates?
i'm trying to use inline CSS and loading an image as a background in Django template. i need three quotes but don't know how to do it. how can i fix the code bellow? <div class="full-background" style="background-image: url("{% static '/img/curved-images/white-curved.jpg' %}")"></div> -
Django Admin Page execute javascript on Custom Action Buttons
I'm trying to add a custom button in each row next to a user to the django admin page which makes it easier for the admin to click the button and generate a password reset link for a particular user rather than navigate to the hidden actions section of the django admin page. Something like this - https://hakibenita.com/how-to-add-custom-action-buttons-to-django-admin Following is the code I've implemented and it works and navigates to a new page with the correct reset-password request and the reset_password() method executes with a link being sent to the user. However, when I click the button, I would like to send an AJAX GET request to the same url as above and just a show an alert to the admin on request completion instead of navigating to a new page. Currently I'm unable to run the javascript code using the format_html method in Django (see code below) Is there a way to run the class UserAdmin(Admin.modelAdmin): list_display = ('name', 'email', 'custom_actions') form = forms.UserAdminForm def get_urls(self): urls = super().get_urls() custom_urls = [ url( r'reset-password/(?P<user_id>.+)', self.admin_site.admin_view(self.reset-password), name='reset-password', ), ] return custom_urls + urls def custom_actions(self, obj): user = user_model.User.get(user_id=obj.id) password_reset_url = reverse('admin:reset-password', args=[user.id]) return mark_safe(format_html( f'<a class="button" onclick="parent.location=\'{password_reset_url}\'" >Reset Password</a>&nbsp;' … -
How to substract custom date in models.DateField from now()?
I still can't find a working solution, hence I decided to throw my first post. Note, I'm a beginner in Django. Building a portal that displays days since the user has been verified. I tested my model without using custom DateField (verified_since), just with date_joined, and it works properly - showing the count of days remaining (I countdown from 365 days, I am not worried about the leap year yet) since the user has registered in the database vs. today. class Profile(models.Model): verified_since = models.DateField(default=now) @property def ver_since(self): return 365 - (now() - self.user.date_joined).days Now if I use verified_since instead date_joined, I get an error. I suspect this is due to a different format of a date, or maybe a string format instead of a date which can't be subtracted then from datetime.now() verified_since is manually entered date on the form by user. class Profile(models.Model): verified_since = models.DateField(default=now) @property def ver_since(self): return 365 - (now() - self.user.verified_since).days Here is settings: TIME_ZONE = 'CET' USE_I18N = True USE_L10N = False USE_TZ = True TIME_INPUT_FORMATS = ('%H:%M',) DATE_INPUT_FORMATS = ['%d/%m/%Y'] -
Post Blob Image to django rest framework with ajax
I have a html page that allows a user to take a screenshot from their camera. This screenshot is then rendered in the page with the function from main.js down below. If i do console.log(image) i get image tag with a src to a blob:http that has the image. Now for the fun part. I want to post this image to my api in django rest framework. Basically how do i go from a blob image to a post request to the api? I tried using $.ajax but I dont know how to format the "blob data" to be accepted for the "data:" parameter field in ajax. Note also that i'm not using forms in the html, when i do that the html page gets refreshed as soon as i take a screenshot so the image does not stay on the page.. If I have to use forms in order to make this work, please let me know and I will try another approach. main.js async function grabFrame() { const img = await imageCapture.grabFrame(); const url = URL.createObjectURL(await imageCapture.takePhoto()); document.querySelector("img").src = url #id_image is where the screenshot is located const image = document.getElementById('id_image') console.log(image) index.html <button onclick="grabFrame()">Grab Frame</button> <img id="id_image" … -
Hovering over Morris Chart is not working as expected
Hovering is not working for my chart, any suggestions as to what it could be? This is a django template with the Morris Chart within. I've got Morris Chart working on other django templates just fine so I'm not sure if it's the payload that the chart doesn't like or just a simple syntax issue - thanks!! {% for item in data_alpha %} <div class="row"> <div class="col-lg-12"> <div class="panel panel-primary"> <div class="panel-heading"> Load Time | {{ item.link }} <button class="btn btn-sm btn-default vertical-allign-baseline pull-right" data-toggle="modal" data-target="#helpLoadTime"> <i class="fa fa-question-circle" aria-hidden="true"></i> Help </button> </div> <div class="panel-body"> {% for key, value in regions.items %} <span class="regions" style="background-color: {{ value }}"></span> <span> {{ key }}</span> {% endfor %} <div id="tg-load-chart_{{ forloop.counter }}" style="height: 300px;"></div> <script> rawData = {{item.tg_load_time_graph|safe}}; aws_regions = Object.keys({{item.tg_load_time_graph|safe}}); processedData = processRawData(rawData, aws_regions); chartData = processToChartData(processedData); colours = Object.values({{regions|safe}}); new Morris.Line({ element: 'tg-load-chart_{{ forloop.counter }}', data: chartData, xkey: 'datetime', ykeys: aws_regions, labels: aws_regions, hideHover: 'auto', pointSize: 0, xLabels: '10min', lineColors: colours, }); </script> -
Django-ckeditor dialog box fields are not displaying properly
I'm trying to use Django-CKEditor for a RichTextField, the text editor is showing fine, but the dialog boxes for its options are displaying with a ruined text field in my forms. The editor and dialog boxes are working fine in admin forms, I tried to use bootstrap4 but the problem is still there. {{form.media}} is on my page here is a picture of the problem. -
.Env file in Django project
I write this lines in .env file in django project to link my project to my Data base but visual code make a problem to the file -
ZMQ - Multiple workers with the same socket Dealer
I have a Python package with the purpose of serving as Dealer to several pieces of code scattered in my solution. But until now it was only being used in a Django Views, so within an application. But now I would like to use this package in a separate script and it seems to me that the script is failing to execute zmq.Context.instance().socket(zmq.DEALER).connect(SOCKET_ADDR) because it is already being used by views.py. Does it make sense? dealer.py (package): imports... context = zmq.Context.instance() workerCnctn = context.socket(zmq.DEALER) workerCnctn.identity = 'xxxxx' workerCnctn.setsockopt(zmq.LINGER, 0) workerCnctn.connect(SOCKET_ADDR) class A: def __init__(self): self.workerCnctn = workerCnctn def send(self, arg1, arg2): ... self.workerCnctn.send_string(msg) views.py: imports ... import dealer ... @api_view(["POST"]) def send(request): ... dealer = dealer.A() A.send(arg1, arg2) ... script.py: imports ... import dealer ... def main(): ... dealer = dealer.A() A.send(arg1, arg2) ... The script is to be called manually and the Django application is running constantly. What I noticed is that in the logs of the Router I can only catch messages that come from views.py. So I ask, can't I have different workers with the same purpose using the same socket? -
Django websockets and channels group_send not working
I started looking into websockets and I would liek to implement realtime communication between web-client (Angular 13) and Python app. As backend I used Django with implemented websockets and channels As i am having problem i simplified code as much as i could so a lot of values are hardcoded for a sake to make it work. (Right now it is One WebClient and one Bot) I implemented 2 Consumers. Bot and webclient: class BotConsumer(AsyncJsonWebsocketConsumer): async def connect(self): await self.accept() await self.channel_layer.group_add("bot","dev") async def disconnect(self, close_code): await self.channel_layer.group_discard("bot","dev") async def receive(self, text_data): await self.channel_layer.group_send("dev",{"type": "recv","text": "test"}) print("Data sent to group") class WebClientConsumer(AsyncJsonWebsocketConsumer): async def connect(self): await self.accept() await self.channel_layer.group_add("client","dev") async def recv(self,event): print("Consumer received smthing from channels") async def disconnect(self, close_code): await self.channel_layer.group_discard("client","dev") async def receive(self, text_data): print("Smthing received") my channel_layer setup in Setting.py CHANNEL_LAYERS = { 'default': { # 'BACKEND': 'channels_redis.core.RedisChannelLayer', # 'CONFIG': { # "hosts": [('192.168.1.10', 6379)], # }, "BACKEND": "channels.layers.InMemoryChannelLayer" }} I tried both Redis with local server running and in memory channels My websocket's routing.py: from django.urls import re_path from . import consumers websocket_urlpatterns = [ re_path(r'live/bot', consumers.BotConsumer.as_asgi()), re_path(r'live/webclient', consumers.WebClientConsumer.as_asgi()), ] My behavior: Django logs: HTTP POST /core/UpdateAvailableServers 200 [0.07, 127.0.0.1:50494] HTTP POST /core/GetPostInfo 200 [0.02, … -
Djnago Adding ManytoMany objects to an object after being created
Im trying to add a many to many field to an object after it is created but keep running into the same error: Direct assignment to the forward side of a many-to-many set is prohibited. Use dogs.set() instead. in my models.py class linkedDog(models.Model): linked_dog = models.ForeignKey(Dog, blank=True, null=True, on_delete=models.CASCADE) service_chosen = models.ManyToManyField(Service, blank=True) shampoos_chosen = models.ManyToManyField(Shampoo, blank=True) total_time = models.IntegerField(blank=True, default=0) class PsuedoAppointment(models.Model): client = models.ForeignKey(User, blank=False, on_delete=models.CASCADE) dogs = models.ManyToManyField(linkedDog, blank=True) total_time = models.IntegerField(blank=False, default=0) I am trying to add a linkedDog object to dogs field in my views I've used this question as a reference Direct assignment to the forward side of a many-to-many set is prohibited. Use emails_for_help.set() instead But can't figure out what I'm doing differently or where its going wrong @login_required def loggedin_appointment_view(request): if request.method == "POST": form = linkedDogForm(request.POST, user=request.user) if form.is_valid(): dog = form.save() dog_id = dog.id dogsquery = linkedDog.objects.filter(id=dog_id) appointment = PsuedoAppointment.objects.create(client=request.user, dogs=None, total_time=None) for dog in dogsquery: appointment.dogs.add(dog) return render(request, 'home.html') else: dog_form = linkedDogForm(user=request.user) return render(request, "appointment_template/loggedin_appointmentmaker.html", context={'dog_form' : dog_form}) I also tried dog = form.save() dog_id = dog.id dogsquery = linkedDog.objects.filter(id=dog_id) appointment = PsuedoAppointment.objects.create(client=request.user, dogs=None, total_time=None) appointment.dogs.set(dogsquery) -
Getting queryset with direct results
Is there any way to actually get queryset by direct values of params? I'm scraping data from api and sometimes there are 3 options. Single record can have full date which is year-month-day, another one could have only year-month and another could have only year. If there is certain date in my database, then i want to get it and add to the new object, but if there is not, then i want to create it. The problem is that, when i'm getting value of let's say year 2017, then i can get values of 2017, 2017-month, and 2017-month-day. Is there any way to search in database so it can act that if param have no value, then it's null? My model here: class Date(models.Model): year = models.PositiveIntegerField() month = models.PositiveIntegerField(blank=True, null=True, validators=[ MaxValueValidator(12), MinValueValidator(1)]) day = models.PositiveIntegerField(blank=True, null=True, validators=[ MaxValueValidator(31), MinValueValidator(1)]) -
Why should I only allow image upload during DEBUG mode?
I want to add a field for users to edit their profile pictures and checked out a few tutorials. However, every tutorial I've found included some form of this in urls.py: if settings.DEBUG: urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT Why can't I do this with deployment and if it has to be like this? Is there any way for me to allow users to upload and modify their profile pictures? Any help would be appreciated. Thanks. -
IntegrityError in Django model
I am doing a little prototype of a (social network/chat), I have an app to chat and other to groups and when I post a message get this: ('23000', "[23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'grupo_id', table 'redsocial.dbo.chat_mensaje'; column does not allow nulls. INSERT fails. (515) (SQLExecDirectW); [23000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The statement has been terminated. (3621)") This is my models.py file in group app: from django.db import models from django.contrib.auth import get_user_model from django.urls import reverse class Grupo(models.Model): nombre_grupo = models.CharField(max_length=50) descripcion = models.CharField(max_length=200, default="Sin descripcion") fecha = models.DateTimeField(auto_now_add=True) propietario = models.ForeignKey( get_user_model(), on_delete=models.CASCADE, ) def __str__(self): return self.nombre_grupo def get_absolute_url(self): return reverse('lista_grupos') This is my models.py file in chat app: from django.db import models from django.contrib.auth import get_user_model from django.urls import reverse # Create your models here. class Mensaje(models.Model): grupo = models.ForeignKey( 'grupo.Grupo', on_delete=models.CASCADE, ) mensaje = models.CharField(max_length=200) propietario = models.ForeignKey( get_user_model(), on_delete=models.CASCADE, ) def __str__(self): return self.mensaje def get_absolute_url(self): return reverse('chat', args=[self.grupo.id]) This is my view.py file in chat app: from django.views.generic import ListView, CreateView from .models import Mensaje class MensajeView(CreateView): model = Mensaje template_name = 'chat/crear_mensaje.html' fields = ('mensaje',) def form_valid(self, form): form.instance.propietario = self.request.user … -
In Django is there a way to "Convert" admin inlines to formsets / front-end?
I have a project that I have been building with some nested relationships (foreign keys). I have come to the end of building the models and getting the admin set up using admin.py. A simple example is: class PhoneInlineAdmin(admin.TabularInline): model = Phone extra = 0 list_display = ["number", "type"] @admin.register(Person) class ContactAdmin(admin.ModelAdmin): list_display = ["last_name", "first_name", "email"] inlines = (PhoneInlineAdmin, ) I love how the admin page works. I can search filter and click save to update all the tables. I am reading through the formsets documentation and class-based views, which is how I have decided to build this learning project. It seems to be quite involved to replicate something that already, near perfectly, exists in the admin page of my app. Is there a simple way that I am missing to replicate the functionality, or do I need to rebuild everything to come close to replicating the admin functionality? If I need to roll up my sleeves, I will, but I thought it was worth asking. -
Django Group Entries by Month
I'm simply trying to group entries in my Data.active_objects that occur in the same month and year. I would like if entries sharing the same month and year would be annotated with the number of occurrences in Data.active_objects Data.active_objects has a few entries with the same month values in 'ts_create' What I've tried so far is test = Data.active_objects.annotate(ts_create__count=Count(TruncMonth('ts_create), distinct=True) However, this does not produce results that I would expect as every entry in Data.active_objects has an annotated value 'ts_create__count' of 1 even when the entries occur in the same month -
How Do I Add A Decorator To A Class?
So I'm able to add a decorator to several functions within my code but I'm unsure as to how to add it to a class. Here are my decorators: def unauthenticated_user(view_func): def wrapper_func(request, *args, **kwargs): if request.user.is_authenticated: return redirect('index') else: return view_func(request, *args, **kwargs) return wrapper_func --------------------------------------------------------------------- def allowed_users(allowed_roles=[]): def decorator(view_func): def wrapper_func(request, *args, **kwargs): group = None if request.user.groups.exists(): group = request.user.groups.all()[0].name if group in allowed_roles: return view_func(request, *args, **kwargs) else: return HttpResponse('You are not authorised to view this page') return wrapper_func return decorator --------------------------------------------------------------------- Here is the Class: class PasswordsChangeView(PasswordChangeView): form_class = PasswordChangedForm success_url = reverse_lazy('password-success') -
Getting Django view dictionary key in Javascript, but instead of considering it a String, considers a Variable Name
I am doing a project in Django. In my views I send data to the HTML pages with dictionaries. I can easily access that data on HTML, but when I try to access it on Javascript I can't because Javascripts thinks it's a variable name. For example, I have a log in page. If the credentials are wrong, I send them to the same page and tell them that the username or password are wrong. I want to keep the previously written username on the form, so the person only needs to rewrite the password. I send the username from the view to the Javascript, but I can't access it. My view code: def login_form(request): assert isinstance(request, HttpRequest) if 'username' and 'password' in request.POST: user = request.POST['username'] passw = request.POST['password'] if rightcredentials(user,passw): tparams = { 'message': 'login successful', } return render(request, 'about.html', tparams) else: tparams = { 'login' : 'failure1', 'username_info' : user } return render(request, 'login_form.html', tparams) Javascript code: {% if login == 'failure1' %} <form action="." method="post"> {% csrf_token %} <div class="program-info"> <h3 class="program-title">Sign Into Your Account</h3> <p>Wrong Username or password</p> <div class="form-group"> <input type="text" value="" class="form-control" name="username" id="username" placeholder="Username"> </div> <div class="form-group"> <input type="password" class="form-control" name="password" placeholder="Password"> … -
how to change the Model field value with logic to time
Say I have a model named Quote class Quote(models.Model): # date_validity will have persistent data like this 2023-11-30 15:00 date_validity = models.CharField(max_length=100, blank=True) quote_status = models.CharField( max_length=150, default='active') So I need to set quote_status expired if data_validity meets the current time, If validity is 2 days later from now then the quote should expire if validity time is over. How can I manage this automatically? As far as I know self.save() method does not trigger automatically. So any suggestions to solve this? -
Django error while serializing image model of child field
I am new to this tech, while working on django project i got some issues when i try to serialize Ticket's account.profile_pic models.py class Account(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE profile_pic = models.ImageField(upload_to='images/profile_pics/', blank=True, null=True) created_at = models.DateTimeField(auto_now_add=True) class Ticket(models.Model): author = models.ForeignKey(Account, on_delete=models.CASCADE) descr = models.TextField(blank=False, null=False) likes = models.ManyToManyField(User) serializers.py class DetailedTicketSerializer(serializers.ModelSerializer): # Error occurs on below line: No file associated with ImageField author_profile_pic = serializers.ReadOnlyField(source='author.profile_pic') author_username = serializers.ReadOnlyField(source='author.user.username') class Meta: model = Ticket fields = ['id', 'author_profile_pic', 'author_username', 'likes', 'descr'] Anyone knows how do i serialize Account.profile_pic's url??? -
Unable to send context to django template
Didn't find a solution to similar issue. I have a list of tasks rendered on a page and after clicking on a title a modal window is popping up with a form to update the task. List and update are made in one class-based view. When a modal window is opened task id is received by views.py from AJAX to update my context in order to show saved data in form fields. I can see updated context with specific object when printing it in my views.py, but the object is not shown in HTML via template tag. Please, help me to figure out what am I doing wrong. Here is my views.py: class KanbanBoardView(PermissionRequiredMixin, View): permission_required = ('projects.view_taskassign',) def get(self, request, *args, **kwargs): context = { 'heading': "Kanban board", 'pageview': "Tasks", 'tasks': TaskAssign.objects.all(), 'statuses': Status.objects.all(), 'users': User.objects.all(), } if 'taskid' in request.GET: task_id = request.GET.get('taskid') task_object = TaskAssign.objects.get(id=task_id) context['task'] = task_object return render(request, 'tasks/kanbanboard.html', context) return render(request, 'tasks/kanbanboard.html', context) def post(self, request): if 'edittask' in request.POST: id = request.POST['id'] deadline = request.POST['deadline'] status = request.POST['status'] user = request.POST['user'] task = TaskAssign.objects.filter(id=id) task.update(deadline=deadline, status=status, user_id=int(user)) return redirect('tasks-kanbanboard') else: status_id = int(request.POST.get('status')) task_id = int(request.POST.get('task_id')) task = get_object_or_404(TaskAssign, pk=task_id) task.status_id = status_id … -
Django. General design philosophy question: best way to implement "toggleable" separate features in a website
Let's say I want to create a blueprint of an online store that I can sell to potential clients. However, the idea is to make it so that the client chooses features that they want their store to have (from a pre-designated list) and pay only for those features, that way avoiding paying for something they don't need. So for example, one client wants to have and online store with a Cart, Purchase History, Graphs, Reports. Another one only wants simple registration and cart (but maybe in future they will want me to "enable" other features as well). My question is: what, in your opinion, is the best way to tackle this problem from a Django developer perspective? My thoughts: Create every feature as a separate app and deploy the whole thing commenting out the features that client did not pay for. And when a client wants additional features, I simply go to settings.py and uncomment the app they requested. Can I even make changes on the settings.py file on a live website without restarting it? Create an admin panel for myself (the superuser) that will have an ability to turn features on or off. So when the client pays … -
How to handle create/update on multiple nested serializers?
I've been able to make creating/updating happen on nested serializers, but I can't seem to get it to work when there are multiple many to many nest serializers. Models: class Brand(models.Model): name = models.CharField(max_length=500) class Incentive(models.Model): name = models.CharField(max_length=500) brands = models.ManyToManyField(Brand, related_name='incentives_brand') start_dt = models.DateTimeField(auto_now_add=False, blank=True, null=True) end_dt = models.DateTimeField(auto_now_add=False, blank=True, null=True) class Version(models.Model): name = models.CharField(max_length=1000) incentives = models.ManyToManyField(Incentive, related_name='versions_incentive', blank=True) brands = models.ManyToManyField(Brand, related_name='versions_brand') Serializers: class BrandSerializer(serializers.ModelSerializer): class Meta: model = Brand depth = 1 fields = ['id', 'name'] class IncentiveSerializer(serializers.ModelSerializer): brands = BrandSerializer(many=True) class Meta: model = Incentive # depth = 1 fields = ['id', 'name', 'brands', 'start_dt', 'end_dt'] class VersionSerializer(serializers.ModelSerializer): incentives = IncentiveSerializer(many=True) brands = BrandSerializer(many=True) class Meta: model = Version fields = ['id', 'name', 'incentives', 'brands'] def create(self, validated_data): brands = validated_data.pop('brands', []) incentives = validated_data.pop('incentives', []) instance = Version.objects.create(**validated_data) for brand_data in brands: brand = Brand.objects.get(**brand_data) instance.brands.add(brand) for incentive_data in incentives: incentive = Incentive.objects.get(**incentive_data) instance.incentives.add(incentive) return instance def update(self, instance, validated_data): brands = validated_data.pop('brands', []) incentives = validated_data.pop('incentives', []) instance = super().update(instance, validated_data) brand_objs = [] incentive_objs = [] for brand_data in brands: brand = Brand.objects.get(**brand_data) brand_objs.append(brand) instance.brands.set(brand_objs) for incentive_data in incentives: incentive = Incentive.objects.get(**incentive_data) incentive_objs.append(incentive) instance.incentives.set(incentive_objs) return instance I tried using the … -
How to filter queryset based on boolean value, then count in template
I want to count how many jobs are open vs closed. I don't understand why this isn't working, I have added {{ap.id}} and {{open.line_num_id }} after the forloop just to see what was rendered. I would think that if they match, then it's added to the count. This is not the case, all jobs are counted regardless of the "if" statement. Totally lost as to what is happening and why. Any help would be very appreciated . I have two models: class Airplane(models.Model): line_num = models.CharField(max_length=10, unique=True) vh_num = models.CharField(max_length=4, unique=True) vz_num = models.CharField(max_length=4, unique=True) stall = models.CharField(max_length=30, choices=stall_picker) status = models.CharField(max_length=30, choices=status_picker) owner = models.ForeignKey(User, on_delete=models.CASCADE) is_completed = models.BooleanField(default=False) pm = models.BooleanField(default=False) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) def __str__(self): return self.line_num class Job(models.Model): line_num = models.ForeignKey( Airplane, on_delete=models.CASCADE, related_name="ap_jobs") job_num = models.CharField(max_length=10, unique=True) description = models.CharField(max_length=200) status = models.CharField(max_length=30, choices=status_picker) category = models.CharField(max_length=30, choices=categories_picker) is_completed = models.BooleanField(default=False) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) class meta: ordering = ["category", "status"] def __str__(self): return (f"{self.job_num}: {self.description} : {self.is_completed}") My View: def Ap_linup(request): context = { 'ap_list': Airplane.objects.all().filter(is_completed=False), 'open_jobs': Job.objects.all().filter(is_completed=False), 'closed_jobs': Job.objects.all().filter(is_completed=True) } return render(request, 'airplane/airplane_list.html', context) Template: {% extends 'base.html' %} {% block title %} Airplane List {% endblock %} …
