Mixing
Query with two conditions in web2py and SQLFORM.grid
I am using a web2py SQLFORM.grid to show a table named db.Essen, which works perfectly.
Now I want to filter entries using a query, which again works well as follows:
Query = db.Essen.Datum == '2018-12-03'
grid = SQLFORM.grid(Query)
However, I run into problems when trying to combine two conditions in a query such as:
Query = ((db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04'))
grid = SQLFORM.grid(Query)
It seems that only the first condition gets executed, the second condition is simply ignored.
How can I implement queries with two conditions in SQLFORM.grid?
sql web2py
asked Jan 1 at 14:47
tfvtfv
3,25521643
add a comment |
I am using a web2py SQLFORM.grid to show a table named db.Essen, which works perfectly.
Now I want to filter entries using a query, which again works well as follows:
Query = db.Essen.Datum == '2018-12-03'
grid = SQLFORM.grid(Query)
However, I run into problems when trying to combine two conditions in a query such as:
Query = ((db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04'))
grid = SQLFORM.grid(Query)
It seems that only the first condition gets executed, the second condition is simply ignored.
How can I implement queries with two conditions in SQLFORM.grid?
sql web2py
asked Jan 1 at 14:47
tfvtfv
3,25521643
1
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:<Query ("Essen"."Datum" = '2018-12-03')>
– tfv
Jan 2 at 9:47
add a comment |
I am using a web2py SQLFORM.grid to show a table named db.Essen, which works perfectly.
Now I want to filter entries using a query, which again works well as follows:
Query = db.Essen.Datum == '2018-12-03'
grid = SQLFORM.grid(Query)
However, I run into problems when trying to combine two conditions in a query such as:
Query = ((db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04'))
grid = SQLFORM.grid(Query)
It seems that only the first condition gets executed, the second condition is simply ignored.
How can I implement queries with two conditions in SQLFORM.grid?
sql web2py
asked Jan 1 at 14:47
tfvtfv
3,25521643
I am using a web2py SQLFORM.grid to show a table named db.Essen, which works perfectly.
Now I want to filter entries using a query, which again works well as follows:
Query = db.Essen.Datum == '2018-12-03'
grid = SQLFORM.grid(Query)
However, I run into problems when trying to combine two conditions in a query such as:
Query = ((db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04'))
grid = SQLFORM.grid(Query)
It seems that only the first condition gets executed, the second condition is simply ignored.
How can I implement queries with two conditions in SQLFORM.grid?
sql web2py
sql web2py
asked Jan 1 at 14:47
tfvtfv
3,25521643
asked Jan 1 at 14:47
tfvtfv
3,25521643
edited Jan 2 at 9:44
tfv
asked Jan 1 at 14:47
tfvtfv
3,25521643
asked Jan 1 at 14:47
tfvtfv
3,25521643
asked Jan 1 at 14:47
tfvtfv
3,25521643
3,25521643
1
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:<Query ("Essen"."Datum" = '2018-12-03')>
– tfv
Jan 2 at 9:47
add a comment |
1
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:<Query ("Essen"."Datum" = '2018-12-03')>
– tfv
Jan 2 at 9:47
1
1
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:
<Query ("Essen"."Datum" = '2018-12-03')>– tfv
Jan 2 at 9:47
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:
<Query ("Essen"."Datum" = '2018-12-03')>– tfv
Jan 2 at 9:47
add a comment |
1 Answer
1
active
oldest
votes
You must use | for an "or" query (and & for an "and" query):
(db.Essen.Datum == '2018-12-03') | (db.Essen.Datum == '2018-12-04')
See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators.
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
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
});
}
});
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%2f53996393%2fquery-with-two-conditions-in-web2py-and-sqlform-grid%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You must use | for an "or" query (and & for an "and" query):
(db.Essen.Datum == '2018-12-03') | (db.Essen.Datum == '2018-12-04')
See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators.
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
add a comment |
You must use | for an "or" query (and & for an "and" query):
(db.Essen.Datum == '2018-12-03') | (db.Essen.Datum == '2018-12-04')
See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators.
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
add a comment |
You must use | for an "or" query (and & for an "and" query):
(db.Essen.Datum == '2018-12-03') | (db.Essen.Datum == '2018-12-04')
See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators.
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
You must use | for an "or" query (and & for an "and" query):
(db.Essen.Datum == '2018-12-03') | (db.Essen.Datum == '2018-12-04')
See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators.
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
answered Jan 2 at 19:06
AnthonyAnthony
24.1k32051
24.1k32051
add a comment |
add a comment |
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%2f53996393%2fquery-with-two-conditions-in-web2py-and-sqlform-grid%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
1
I think that you just want an OR condition instead of AND : (db.Essen.Datum == '2018-12-03') or (db.Essen.Datum == '2018-12-04')
– GMB
Jan 1 at 15:39
@GMB :-) You are correct, but this was only a typo which originated from simplifying the example. It does not work with 'or' either, but each single conditions works when I delete the other. In the result, only the first condition is shown as query: Query:
<Query ("Essen"."Datum" = '2018-12-03')>– tfv
Jan 2 at 9:47