$and condition doesn't work with three or more than three fields in springboot mongodb The 2019 Stack Overflow Developer Survey Results Are InWrong ordering in generated table in jpaBest way of invoking getter by reflectionCreate the perfect JPA entityFind MongoDB records where array field is not emptyCheck that Field Exists with MongoDBMongoDB aggregate by field existsQuerying mongo collection by boolean fieldmongodb - counting a non-null field using an indexSpring Boot Failed to Convert JSON to pojo from post request for fields that are not of type stringSome fields not getting parsed/deserialized in JSON in Springboot
Why hard-Brexiteers don't insist on a hard border to prevent illegal immigration after Brexit?
Is "plugging out" electronic devices an American expression?
How come people say “Would of”?
Delete all lines which don't have n characters before delimiter
Resizing object distorts it (Illustrator CC 2018)
Apparent duplicates between Haynes service instructions and MOT
Pokemon Turn Based battle (Python)
What is the meaning of Triage in Cybersec world?
Multiply Two Integer Polynomials
Can you compress metal and what would be the consequences?
Loose spokes after only a few rides
Can a flute soloist sit?
Is a "Democratic" Oligarchy-Style System Possible?
Time travel alters history but people keep saying nothing's changed
Do these rules for Critical Successes and Critical Failures seem Fair?
Why can Shazam fly?
How to type this arrow in math mode?
Button changing it's text & action. Good or terrible?
When should I buy a clipper card after flying to OAK?
Earliest use of the term "Galois extension"?
A poker game description that does not feel gimmicky
The difference between dialogue marks
Which Sci-Fi work first showed weapon of galactic-scale mass destruction?
If a Druid sees an animal’s corpse, can they wild shape into that animal?
$and condition doesn't work with three or more than three fields in springboot mongodb
The 2019 Stack Overflow Developer Survey Results Are InWrong ordering in generated table in jpaBest way of invoking getter by reflectionCreate the perfect JPA entityFind MongoDB records where array field is not emptyCheck that Field Exists with MongoDBMongoDB aggregate by field existsQuerying mongo collection by boolean fieldmongodb - counting a non-null field using an indexSpring Boot Failed to Convert JSON to pojo from post request for fields that are not of type stringSome fields not getting parsed/deserialized in JSON in Springboot
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
@Document(collection = "formtype")
public class FormType
@Id
@Field(value = "id")
private Long formTypeId;
@Field(value = "formtypename")
private String formTypeName;
@Field(value = "isdeleted")
private Boolean isDeleted = false;
//with constructor and getter setter
I have written this query to find out the record of form type in which that formTypeName is not belong to that formTypeId and it's isDeleted is not equal to true.
Writing this query I get value as null even if that record is present.
Please help me out!
@Query(" '$and': [ 'formTypeId':$ne :?0 , formTypeName:'?0' , 'isDeleted':$ne : true ] ") FormType getformTypeToUpdate(Long formTypeId,String formTypeName);
java mongodb spring-boot
edited Mar 8 at 9:46
Prashant Gupta
769520
asked Mar 8 at 9:38
SonalSonal
235
add a comment |
@Document(collection = "formtype")
public class FormType
@Id
@Field(value = "id")
private Long formTypeId;
@Field(value = "formtypename")
private String formTypeName;
@Field(value = "isdeleted")
private Boolean isDeleted = false;
//with constructor and getter setter
I have written this query to find out the record of form type in which that formTypeName is not belong to that formTypeId and it's isDeleted is not equal to true.
Writing this query I get value as null even if that record is present.
Please help me out!
@Query(" '$and': [ 'formTypeId':$ne :?0 , formTypeName:'?0' , 'isDeleted':$ne : true ] ") FormType getformTypeToUpdate(Long formTypeId,String formTypeName);
java mongodb spring-boot
edited Mar 8 at 9:46
Prashant Gupta
769520
asked Mar 8 at 9:38
SonalSonal
235
add a comment |
@Document(collection = "formtype")
public class FormType
@Id
@Field(value = "id")
private Long formTypeId;
@Field(value = "formtypename")
private String formTypeName;
@Field(value = "isdeleted")
private Boolean isDeleted = false;
//with constructor and getter setter
I have written this query to find out the record of form type in which that formTypeName is not belong to that formTypeId and it's isDeleted is not equal to true.
Writing this query I get value as null even if that record is present.
Please help me out!
@Query(" '$and': [ 'formTypeId':$ne :?0 , formTypeName:'?0' , 'isDeleted':$ne : true ] ") FormType getformTypeToUpdate(Long formTypeId,String formTypeName);
java mongodb spring-boot
edited Mar 8 at 9:46
Prashant Gupta
769520
asked Mar 8 at 9:38
SonalSonal
235
@Document(collection = "formtype")
public class FormType
@Id
@Field(value = "id")
private Long formTypeId;
@Field(value = "formtypename")
private String formTypeName;
@Field(value = "isdeleted")
private Boolean isDeleted = false;
//with constructor and getter setter
I have written this query to find out the record of form type in which that formTypeName is not belong to that formTypeId and it's isDeleted is not equal to true.
Writing this query I get value as null even if that record is present.
Please help me out!
@Query(" '$and': [ 'formTypeId':$ne :?0 , formTypeName:'?0' , 'isDeleted':$ne : true ] ") FormType getformTypeToUpdate(Long formTypeId,String formTypeName);
java mongodb spring-boot
java mongodb spring-boot
edited Mar 8 at 9:46
Prashant Gupta
769520
asked Mar 8 at 9:38
SonalSonal
235
edited Mar 8 at 9:46
Prashant Gupta
769520
asked Mar 8 at 9:38
SonalSonal
235
edited Mar 8 at 9:46
Prashant Gupta
769520
edited Mar 8 at 9:46
Prashant Gupta
769520
edited Mar 8 at 9:46
Prashant Gupta
769520
769520
asked Mar 8 at 9:38
SonalSonal
235
asked Mar 8 at 9:38
SonalSonal
235
asked Mar 8 at 9:38
SonalSonal
235
235
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You had ?0 enclosed within simple quotation, that may be misinterpreted by compiler. Also, it seems you only used Long formTypeId parameter for two conditions formTypeId and formTypeName.
Can you try:
@Query(" '$and': [ 'formTypeId': $ne : ?0 , 'formTypeName': ?1 , 'isDeleted': $ne : true ] ")
FormType getformTypeToUpdate(Long formTypeId, String formTypeName);
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so?0means formTypeId and?1means formTypeName
– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
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%2f55060412%2fand-condition-doesnt-work-with-three-or-more-than-three-fields-in-springboot-m%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 had ?0 enclosed within simple quotation, that may be misinterpreted by compiler. Also, it seems you only used Long formTypeId parameter for two conditions formTypeId and formTypeName.
Can you try:
@Query(" '$and': [ 'formTypeId': $ne : ?0 , 'formTypeName': ?1 , 'isDeleted': $ne : true ] ")
FormType getformTypeToUpdate(Long formTypeId, String formTypeName);
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so?0means formTypeId and?1means formTypeName
– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
add a comment |
You had ?0 enclosed within simple quotation, that may be misinterpreted by compiler. Also, it seems you only used Long formTypeId parameter for two conditions formTypeId and formTypeName.
Can you try:
@Query(" '$and': [ 'formTypeId': $ne : ?0 , 'formTypeName': ?1 , 'isDeleted': $ne : true ] ")
FormType getformTypeToUpdate(Long formTypeId, String formTypeName);
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so?0means formTypeId and?1means formTypeName
– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
add a comment |
You had ?0 enclosed within simple quotation, that may be misinterpreted by compiler. Also, it seems you only used Long formTypeId parameter for two conditions formTypeId and formTypeName.
Can you try:
@Query(" '$and': [ 'formTypeId': $ne : ?0 , 'formTypeName': ?1 , 'isDeleted': $ne : true ] ")
FormType getformTypeToUpdate(Long formTypeId, String formTypeName);
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
You had ?0 enclosed within simple quotation, that may be misinterpreted by compiler. Also, it seems you only used Long formTypeId parameter for two conditions formTypeId and formTypeName.
Can you try:
@Query(" '$and': [ 'formTypeId': $ne : ?0 , 'formTypeName': ?1 , 'isDeleted': $ne : true ] ")
FormType getformTypeToUpdate(Long formTypeId, String formTypeName);
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
answered Mar 8 at 15:51
Cristian ColoradoCristian Colorado
1,57821322
1,57821322
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so?0means formTypeId and?1means formTypeName
– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
add a comment |
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so?0means formTypeId and?1means formTypeName
– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
Why to use ?1 and what is the meaning of it in respective query?
– Sonal
Mar 11 at 5:10
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so
?0 means formTypeId and ?1 means formTypeName– Cristian Colorado
Mar 11 at 14:08
You can use that notation to indicate which parameter from your method should spring use to replace in the string, so
?0 means formTypeId and ?1 means formTypeName– Cristian Colorado
Mar 11 at 14:08
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
Yes. Now it is working. Thank You!
– Sonal
Mar 13 at 9:52
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%2f55060412%2fand-condition-doesnt-work-with-three-or-more-than-three-fields-in-springboot-m%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
