Ufdjrw

Where and when has Thucydides been studied?

Found this skink in my tomato plant bucket. Is he trapped? Or could he leave if he wanted?

Why can't fire hurt Daenerys but it did to Jon Snow in season 1?

Is there a verb for listening stealthily?

Problem with display of presentation

Improvising over quartal voicings

My mentor says to set image to Fine instead of RAW — how is this different from JPG?

Do i imagine the linear (straight line) homotopy in a correct way?

NIntegrate on a solution of a matrix ODE

Sally's older brother

Russian equivalents of おしゃれは足元から (Every good outfit starts with the shoes)

How to name indistinguishable henchmen in a screenplay?

Is a copyright notice with a non-existent name be invalid?

Are there any irrational/transcendental numbers for which the distribution of decimal digits is not uniform?

What is "Lambda" in Heston's original paper on stochastic volatility models?

How does TikZ render an arc?

Statistical analysis applied to methods coming out of Machine Learning

Why do C and C++ allow the expression (int) + 4*5?

First paper to introduce the "principal-agent problem"

How do you cope with tons of web fonts when copying and pasting from web pages?

Does the Rock Gnome trait Artificer's Lore apply when you aren't proficient in History?

Does the universe have a fixed centre of mass?

Should man-made satellites feature an intelligent inverted "cow catcher"?

Is there a spell that can create a permanent fire?

Related Field got invalid lookup: icontains - Django 2.1

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I am trying to make the "vanKit" field searchable in my admin page. "vanKit" is a ForeignKey and whenever I add it it my search_fields list it gives me this error "Related Field got invalid lookup: icontains". Here's my code:

Models.py

class KitSupplies(models.Model):
 supplyName = models.ForeignKey(supplies, on_delete=models.CASCADE)
 vanKit = models.ForeignKey(van_kit, on_delete=models.CASCADE)
 quantity = models.PositiveSmallIntegerField(blank=False)
 def __str__(self):
 return str(self.supplyName)
 class Meta:
 verbose_name_plural = 'Kit Supplies'

admin.py

class KitSuppliesAdmin(admin.ModelAdmin):
 list_display = ('supplyName', 'vanKit', 'quantity')
 search_fields = ['vanKit']

admin.site.register(KitSupplies, KitSuppliesAdmin)

I tried to use search_fields = ['vanKit__name'] like the other stack overflow answers suggested but that did not work for me. Can anyone explain why I am getting this error and how to get around it? I am using Django 2.1 and python 3.7. Thanks in advance!

django python-3.x django-models

share|improve this question

asked Mar 9 at 1:01

Tank12Tank12

237

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What does the vanKit model look like? Are you sure VanKit.name is a string field?
  
  – farooq
  Mar 9 at 1:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is van_kit and supplies your class name?why not VanKit and Supply? See: docs.python-guide.org/writing/style
  
  – Waket Zheng
  Mar 9 at 3:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  vanKit is a foreign key to van_kit. The name of the van kits are specified by " van_kit_name = models.CharField(max_length=100)" in the van_kit class
  
  – Tank12
  Mar 9 at 7:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'll make those changes to correct the class names as well
  
  – Tank12
  Mar 9 at 7:41
  

  
  
  
  

add a comment | 

1

I am trying to make the "vanKit" field searchable in my admin page. "vanKit" is a ForeignKey and whenever I add it it my search_fields list it gives me this error "Related Field got invalid lookup: icontains". Here's my code:

Models.py

class KitSupplies(models.Model):
 supplyName = models.ForeignKey(supplies, on_delete=models.CASCADE)
 vanKit = models.ForeignKey(van_kit, on_delete=models.CASCADE)
 quantity = models.PositiveSmallIntegerField(blank=False)
 def __str__(self):
 return str(self.supplyName)
 class Meta:
 verbose_name_plural = 'Kit Supplies'

admin.py

class KitSuppliesAdmin(admin.ModelAdmin):
 list_display = ('supplyName', 'vanKit', 'quantity')
 search_fields = ['vanKit']

admin.site.register(KitSupplies, KitSuppliesAdmin)

I tried to use search_fields = ['vanKit__name'] like the other stack overflow answers suggested but that did not work for me. Can anyone explain why I am getting this error and how to get around it? I am using Django 2.1 and python 3.7. Thanks in advance!

django python-3.x django-models

share|improve this question

asked Mar 9 at 1:01

Tank12Tank12

237

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What does the vanKit model look like? Are you sure VanKit.name is a string field?
  
  – farooq
  Mar 9 at 1:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is van_kit and supplies your class name?why not VanKit and Supply? See: docs.python-guide.org/writing/style
  
  – Waket Zheng
  Mar 9 at 3:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  vanKit is a foreign key to van_kit. The name of the van kits are specified by " van_kit_name = models.CharField(max_length=100)" in the van_kit class
  
  – Tank12
  Mar 9 at 7:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'll make those changes to correct the class names as well
  
  – Tank12
  Mar 9 at 7:41
  

  
  
  
  

add a comment | 

I am trying to make the "vanKit" field searchable in my admin page. "vanKit" is a ForeignKey and whenever I add it it my search_fields list it gives me this error "Related Field got invalid lookup: icontains". Here's my code:

Models.py

class KitSupplies(models.Model):
 supplyName = models.ForeignKey(supplies, on_delete=models.CASCADE)
 vanKit = models.ForeignKey(van_kit, on_delete=models.CASCADE)
 quantity = models.PositiveSmallIntegerField(blank=False)
 def __str__(self):
 return str(self.supplyName)
 class Meta:
 verbose_name_plural = 'Kit Supplies'

admin.py

class KitSuppliesAdmin(admin.ModelAdmin):
 list_display = ('supplyName', 'vanKit', 'quantity')
 search_fields = ['vanKit']

admin.site.register(KitSupplies, KitSuppliesAdmin)

I tried to use search_fields = ['vanKit__name'] like the other stack overflow answers suggested but that did not work for me. Can anyone explain why I am getting this error and how to get around it? I am using Django 2.1 and python 3.7. Thanks in advance!

django python-3.x django-models

share|improve this question

asked Mar 9 at 1:01

Tank12Tank12

237

class KitSupplies(models.Model):
 supplyName = models.ForeignKey(supplies, on_delete=models.CASCADE)
 vanKit = models.ForeignKey(van_kit, on_delete=models.CASCADE)
 quantity = models.PositiveSmallIntegerField(blank=False)
 def __str__(self):
 return str(self.supplyName)
 class Meta:
 verbose_name_plural = 'Kit Supplies'

class KitSuppliesAdmin(admin.ModelAdmin):
 list_display = ('supplyName', 'vanKit', 'quantity')
 search_fields = ['vanKit']

admin.site.register(KitSupplies, KitSuppliesAdmin)

share|improve this question

asked Mar 9 at 1:01

Tank12Tank12

237

share|improve this question

asked Mar 9 at 1:01

Tank12Tank12

237

asked Mar 9 at 1:01

Tank12Tank12

237

asked Mar 9 at 1:01

Tank12Tank12

237

1 Answer
1

active

oldest

votes

1

So I figured it out, I had to use "search_fields = ['vanKit__van_kit_name']" van_kit_name is the field that held the name of the van kits in the van_kit model that "vanKit" relates to through a Foreign Key. I had to access the Char Field that held the van kit's name in the actual van_kit model.

share|improve this answer

answered Mar 9 at 7:56

Tank12Tank12

237

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072980%2frelated-field-got-invalid-lookup-icontains-django-2-1%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

So I figured it out, I had to use "search_fields = ['vanKit__van_kit_name']" van_kit_name is the field that held the name of the van kits in the van_kit model that "vanKit" relates to through a Foreign Key. I had to access the Char Field that held the van kit's name in the actual van_kit model.

share|improve this answer

answered Mar 9 at 7:56

Tank12Tank12

237

add a comment | 

1

So I figured it out, I had to use "search_fields = ['vanKit__van_kit_name']" van_kit_name is the field that held the name of the van kits in the van_kit model that "vanKit" relates to through a Foreign Key. I had to access the Char Field that held the van kit's name in the actual van_kit model.

share|improve this answer

answered Mar 9 at 7:56

Tank12Tank12

237

add a comment | 

So I figured it out, I had to use "search_fields = ['vanKit__van_kit_name']" van_kit_name is the field that held the name of the van kits in the van_kit model that "vanKit" relates to through a Foreign Key. I had to access the Char Field that held the van kit's name in the actual van_kit model.

share|improve this answer

answered Mar 9 at 7:56

Tank12Tank12

237

share|improve this answer

answered Mar 9 at 7:56

Tank12Tank12

237

answered Mar 9 at 7:56

Tank12Tank12

237

answered Mar 9 at 7:56

Tank12Tank12

237