Get chosen dropdown option from Django filter

I am new to the Django and searched a lot about my problem, but could not use any of the solution.

I am using Django filter to select some of the options available and use them to recreate and show my table in the HTML output.

I have created the databse and the query, and it partially works. Whenever I try to run the app, I get the IDs of the values from the database and actual values are not returned. I am using Django 2.2.16

filters.py

import django_filters
from .models import *

class OrderFilter(django_filters.FilterSet):
    class Meta:
        model = Order
        fields = '__all__'

model.py

`from django.db import models

class CodeName(models.Model): code_name = models.CharField(max_length=200, null=True)

def __str__ (self):
    return self.code_name

class FileName(models.Model): file_Name = models.CharField(max_length=200, null=True) def str (self): return self.file_Name

class Order(models.Model):

codename = models.ForeignKey(CodeName, null=True,on_delete = models.SET_NULL)
filename = models.ForeignKey(FileName, null=True,on_delete = models.SET_NULL)

` views.py

def stats1(request):
    import pandas as pd

    data = {
      "calories": [420, 380, 390],
      "duration": [50, 40, 45]
    }

    #load data into a DataFrame object:
    NoneConceptsTable1 = pd.DataFrame(data)
    myFilter = OrderFilter()
    print(df) 
    print('stats')
    print(len(NoneConceptsTable1))
    if len(NoneConceptsTable1)>0:
        print("Yes, the lenght of NoneConceptsTable1 was geater than 1")
        pos = NoneConceptsTable1.Frequency.values
        
        
        codeName_instance = list(NoneConceptsTable1.Name.values)
        # print(codeName_codeName_instance[i]instance)
% I need help after this. I want to get the selected codes from HTML and use them to filter the table: NoneConceptsTable1 
        req = request.GET
        fileName_instance = list(NoneConceptsTable1.filename.values)
        context = {'result_present': True,
          'df': NoneConceptsTable1.to_html(table_id= "table_id"),'myFilter':myFilter}
        # context = {'myFilter':myFilter}
        return render(request, 'stats1.html',context)

I want to get the selected words, but instead I get some unwanted numbers of option IDs like shown below enter image description here

Please let me know any solution you have including any available app.

Back to Top