Can ForeignKey.limit_choices_to work for grandparent choices in Django 1.11?
I am using Django v1.11
I have the following relations:
- SubProject has many Quotation
- Quotation has many QuotationLineItem
- SubProject is many to many with Scope through ScopeInSubProject
- QuotationLineItem belongs to Scope via ForeignKey where the
scope_idis default null
So I like to ensure that when the user does assign a scope value, it's limited to the list of Scope records associated with its grandparent model (SubProject).
For e.g.
- SubProject ABC is associated with Scope A1 and A2.
- A QuotationLineItem is associated with SubProject ABC indirectly via a Quotation record.
- Then when I try to save Scope for this very QuotationLineItem, I cannot save anything other than A1 and A2.
I came across this concept called limit_choices_to, so I was wondering how do I use it in my specific case?
If I don't use this concept, how do I ensure this restriction somehow? Do I write extra validation logic?
django django-models foreign-keys
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
add a comment |
I am using Django v1.11
I have the following relations:
- SubProject has many Quotation
- Quotation has many QuotationLineItem
- SubProject is many to many with Scope through ScopeInSubProject
- QuotationLineItem belongs to Scope via ForeignKey where the
scope_idis default null
So I like to ensure that when the user does assign a scope value, it's limited to the list of Scope records associated with its grandparent model (SubProject).
For e.g.
- SubProject ABC is associated with Scope A1 and A2.
- A QuotationLineItem is associated with SubProject ABC indirectly via a Quotation record.
- Then when I try to save Scope for this very QuotationLineItem, I cannot save anything other than A1 and A2.
I came across this concept called limit_choices_to, so I was wondering how do I use it in my specific case?
If I don't use this concept, how do I ensure this restriction somehow? Do I write extra validation logic?
django django-models foreign-keys
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
add a comment |
I am using Django v1.11
I have the following relations:
- SubProject has many Quotation
- Quotation has many QuotationLineItem
- SubProject is many to many with Scope through ScopeInSubProject
- QuotationLineItem belongs to Scope via ForeignKey where the
scope_idis default null
So I like to ensure that when the user does assign a scope value, it's limited to the list of Scope records associated with its grandparent model (SubProject).
For e.g.
- SubProject ABC is associated with Scope A1 and A2.
- A QuotationLineItem is associated with SubProject ABC indirectly via a Quotation record.
- Then when I try to save Scope for this very QuotationLineItem, I cannot save anything other than A1 and A2.
I came across this concept called limit_choices_to, so I was wondering how do I use it in my specific case?
If I don't use this concept, how do I ensure this restriction somehow? Do I write extra validation logic?
django django-models foreign-keys
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
I am using Django v1.11
I have the following relations:
- SubProject has many Quotation
- Quotation has many QuotationLineItem
- SubProject is many to many with Scope through ScopeInSubProject
- QuotationLineItem belongs to Scope via ForeignKey where the
scope_idis default null
So I like to ensure that when the user does assign a scope value, it's limited to the list of Scope records associated with its grandparent model (SubProject).
For e.g.
- SubProject ABC is associated with Scope A1 and A2.
- A QuotationLineItem is associated with SubProject ABC indirectly via a Quotation record.
- Then when I try to save Scope for this very QuotationLineItem, I cannot save anything other than A1 and A2.
I came across this concept called limit_choices_to, so I was wondering how do I use it in my specific case?
If I don't use this concept, how do I ensure this restriction somehow? Do I write extra validation logic?
django django-models foreign-keys
django django-models foreign-keys
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
asked Nov 23 '18 at 9:01
Kim StacksKim Stacks
4,4022097204
4,4022097204
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53443458%2fcan-foreignkey-limit-choices-to-work-for-grandparent-choices-in-django-1-11%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53443458%2fcan-foreignkey-limit-choices-to-work-for-grandparent-choices-in-django-1-11%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
