making query with django model

Using Django Mystery Errors
1

I am developing a result management project, I want a student to check his result when he is logedin. please i need your help am new.
here is my model

class FirstSemisterResult(models.Model):
    
    regNo=models.ForeignKey(StudentRegistration, on_delete=models.CASCADE)
    name=models.ForeignKey(User, on_delete=models.CASCADE)
    level=models.ForeignKey(Class, on_delete=models.CASCADE)
    
    courseCode=models.ForeignKey(CollegeCourse, on_delete=models.CASCADE)
    scores=models.IntegerField()
    courseUnit=models.IntegerField()
    dateUploaded=models.DateTimeField(auto_now_add=True,blank=True, null=True)
    
    
    def __str__(self):
        
        return(self.regNo)

this is my view in the computer result

 @login_required
def ComputeResult(request):
    fsrt=FirstSemisterResult.objects.all()
    secrt=SecondSemisterResult.objects.all()
    checkresult=CheckResult.objects.all()
    
    #def get_result(self):
        #return self.request.user.exam_set.all()
    
    sum_gradepoint=0
    sec_sum_gradepoint=0
    #total_gradepoint=0
    total_courseunit=0
    #sec_total_gradepoint=0
    sec_total_courseunit=0
    check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)

this is the traceback


## Traceback [Switch to copy-and-paste view](http://127.0.0.1:8000/Computeresult#)

* `C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\exception.py`, line 55, in inner

  55. response = get_response(request)

…

Local vars

|||
| --- | --- |
|||
|||
|||

* `C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\base.py`, line 197, in _get_response

  197. response = wrapped_callback(request, *callback_args, **callback_kwargs)

…

Local vars

|||
| --- | --- |
|||
|||
|||
|||
|||
|||
|||
|||

* `C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\contrib\auth\decorators.py`, line 23, in _wrapper_view

  23. return view_func(request, *args, **kwargs)

…

Local vars

|||
| --- | --- |
|||
|||
|||
|||
|||
|||
|||

* `C:\Users\ENGR_AIR\ResultManagement\ResultManagementApp\views.py`, line 180, in ComputeResult

  180. check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)

…

Local vars
2

Side note: You need to use the backtick - ` to fence your code, not the apostrophe - '. Also the line of ``` must be a line by itself, not part of any other text on that line. (I’ve taken the liberty of fixing your post for this.) Also, it’s usually more useful to post the full traceback from the console where you’re running runserver and not what gets displayed in the browser.

Unfortunately, the portion of the error you posted is not enough to begin to diagnose the issue.

3

sorry am ne here I will adapt soon
my model

 class FirstSemisterResult(models.Model):
    
    regNo=models.ForeignKey(StudentRegistration, on_delete=models.CASCADE)
    name=models.ForeignKey(User, on_delete=models.CASCADE)
    level=models.ForeignKey(Class, on_delete=models.CASCADE)
    
    courseCode=models.ForeignKey(CollegeCourse, on_delete=models.CASCADE)
    scores=models.IntegerField()
    courseUnit=models.IntegerField()
    dateUploaded=models.DateTimeField(auto_now_add=True,blank=True, null=True)
    
    
    def __str__(self):
        
        return(self.regNo)

views

 def ComputeResult(request):
    fsrt=FirstSemisterResult.objects.all()
    secrt=SecondSemisterResult.objects.all()
    checkresult=CheckResult.objects.all()
    
    #def get_result(self):
        #return self.request.user.exam_set.all()
    
    sum_gradepoint=0
    sec_sum_gradepoint=0
    #total_gradepoint=0
    total_courseunit=0
    #sec_total_gradepoint=0
    sec_total_courseunit=0
    check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)

traceback

 Internal Server Error: /Computeresult
Traceback (most recent call last):
  File "C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\exception.py", line 55, in inner
    response = get_response(request)
  File "C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\contrib\auth\decorators.py", line 23, in _wrapper_view
    return view_func(request, *args, **kwargs)
  File "C:\Users\ENGR_AIR\ResultManagement\ResultManagementApp\views.py", line 180, in ComputeResult
    check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)
NameError: name 'regNo' is not defined
[18/Feb/2024 07:20:17] "GET /Computeresult HTTP/1.1" 500 69210
4

I fixed your post again - you need to use the backtick - `, no other character.

This variable is not defined in your view.

5

\\ class FirstSemisterResult(models.Model):

regNo=models.ForeignKey(StudentRegistration, on_delete=models.CASCADE)
name=models.ForeignKey(User, on_delete=models.CASCADE)
level=models.ForeignKey(Class, on_delete=models.CASCADE)

courseCode=models.ForeignKey(CollegeCourse, on_delete=models.CASCADE)
scores=models.IntegerField()
courseUnit=models.IntegerField()
dateUploaded=models.DateTimeField(auto_now_add=True,blank=True, null=True)


def __str__(self):
    
    return(self.regNo)

def ComputeResult(request):
fsrt=FirstSemisterResult.objects.all()
secrt=SecondSemisterResult.objects.all()
checkresult=CheckResult.objects.all()

#def get_result(self):
    #return self.request.user.exam_set.all()

sum_gradepoint=0
sec_sum_gradepoint=0
#total_gradepoint=0
total_courseunit=0
#sec_total_gradepoint=0
sec_total_courseunit=0
check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)

Internal Server Error: /Computeresult
Traceback (most recent call last):
File “C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\exception.py”, line 55, in inner
response = get_response(request)
File “C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\core\handlers\base.py”, line 197, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File “C:\Users\ENGR_AIR\Envs\iskcoe\lib\site-packages\django\contrib\auth\decorators.py”, line 23, in _wrapper_view
return view_func(request, *args, **kwargs)
File “C:\Users\ENGR_AIR\ResultManagement\ResultManagementApp\views.py”, line 180, in ComputeResult
check=FirstSemisterResult.objects.filter(name=request.user,regNo=regNo,level=level)
NameError: name ‘regNo’ is not defined
[18/Feb/2024 07:20:17] “GET /Computeresult HTTP/1.1” 500 69210

\\

6 
#def get_result(self):
    #return self.request.user.exam_set

This should be in my views or model pls