Hi, We need more information. We need to know which field causes the problem. Maybe the full error message with full traceback could help.
Regards, A. Antonis Christofides http://djangodeployment.com On 2017-05-18 12:53, Amisha Hans wrote: > Hey , > > I am facing a lot of issues regarding this foreign key !. > > Scenario is a s follows :- > > models.py > > class ComponentDeprecation(models.Model): > row_id = models.IntegerField(primary_key=True) > component = models.ForeignKey('SsComponents', db_column='component') > submitter = models.CharField(max_length=12) > description = models.CharField(max_length=4000) > deprecation_date = models.DateField() > submitted_date = models.DateTimeField() > deprecated_by = models.CharField(max_length=12, blank=True, null=True) > deprecated_date = models.DateTimeField(blank=True, null=True) > > class Meta: > managed = False > db_table = 'component_deprecation' > > > class SsComponents(models.Model): > component = models.CharField(primary_key=True, max_length=40) > ddts_class = models.CharField(max_length=20) > vob = models.CharField(max_length=20) > vob_rel_path = models.CharField(max_length=30) > owner = models.CharField(max_length=16, blank=True, null=True) > comp_main_branch = models.CharField(max_length=60, blank=True, null=True) > starting_version = models.CharField(max_length=10, blank=True, null=True) > include_list = models.CharField(max_length=60, blank=True, null=True) > other_list = models.CharField(max_length=60, blank=True, null=True) > created_by = models.CharField(max_length=16) > created_date = models.DateField() > comp_type = models.CharField(max_length=3, blank=True, null=True) > lifecycle = models.CharField(max_length=20, blank=True, null=True) > description = models.CharField(max_length=4000, blank=True, null=True) > component_approval = models.ForeignKey(ComponentApproval, blank=True, > null=True) > component_deprecation = models.ForeignKey(ComponentDeprecation, > blank=True, null=True) > migrated = models.NullBooleanField() > migrated_date = models.DateField(blank=True, null=True) > last_updatetime = models.DateField(blank=True, null=True) > > class Meta: > managed = False > db_table = 'ss_components' > > views.py > > def lc_depr_detail_form(request): > ''' > Returns the Fields in the form of List containing Dictionary to be > rendered to HTML Page for Deprecate Report. > ''' > user_name = request.META['REMOTE_USER'] > #Fetching the field values from the HTML Page > component = request.POST.get('comp') > submitter = request.POST.get('submitter') > submitted_date = request.POST.get('sub_date') > deprecated_by = request.POST.get('dep_by') > deprecated_date = request.POST.get('dep_date') > stri = "" > #Putting the field values in a string variable > if(component and component!= "None"): > comp1= component.replace("*", ".*") > stri=stri+" ,component=r'^%s$'" % (comp1) > if(submitter and submitter!= "None"): > submitter1=submitter.replace("*", ".*") > stri=stri+" ,submitter__regex=r'^%s$'" % (submitter1) > if(submitted_date and submitted_date!= "None"): > sub_date1=submitted_date.replace("*", ".*") > stri=stri+" ,submitted_date__regex=r'^%s$'" % (sub_date1) > if(deprecated_by and deprecated_by!= "None"): > dep_by1=deprecated_by.replace("*", ".*")j > stri=stri+" ,deprecated_by__regex=r'^%s$'" % (dep_by1) > if(deprecated_date and deprecated_date!= "None"): > dep_date1=deprecated_date.replace("*", ".*") > stri=stri+" ,deprecated_date__regex=r'^%s$'" % (dep_date1) > #Substituting the first comma with a space > data= re.sub(r',',"",stri,1) > #Checking when no data is Entered in the Form > if (data == ''): > return render(request, > 'lc_depr.html',{'user':user_name,'message':'Please provide atleast one > Input','page':r'help/home.html'}) > > details="ComponentDeprecation.objects.filter(%s).order_by('-deprecated_date').values('component','deprecated_by','deprecated_date')" > % (data) > print details > #Evaluates the details as a Python Expression > details_list = eval(details) > print details_list > #Checking if the list is empty due to Wrong data Input by the User > if not details_list: > return render(request, > 'lc_depr_report.html',{'user':user_name,'message':'Oops! Couldnot figure out > what you were searching for.Please recheck the inputs provided for the > query','page':r'help/home.html'}) > else: > return render(request, > 'lc_depr_report.html',{'user':user_name,'details_list':details_list,'page':r'help/home.html'}) > > > > i am getting this error: related field got invalid lookup: regex component > only > i dont know how to access the value of component .. for other fields no error > is comming . > > > > > -- > 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 > <mailto:django-users+unsubscr...@googlegroups.com>. > To post to this group, send email to django-users@googlegroups.com > <mailto:django-users@googlegroups.com>. > Visit this group at https://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/773176fa-3560-49eb-afbd-0ca8eac30b1f%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/773176fa-3560-49eb-afbd-0ca8eac30b1f%40googlegroups.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout. -- 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 post to this group, send email to django-users@googlegroups.com. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/befba015-4e47-38da-c69b-46e59dc826d5%40djangodeployment.com. For more options, visit https://groups.google.com/d/optout.
