Styjun

Are athletes' college degrees discounted by employers and graduate school admissions?

Does PC weight have a mechanical effect?

Boss making me feel guilty for leaving the company at the end of my internship

100-doors puzzle

Print the phrase "And she said, 'But that's his.'" using only the alphabet

How do I say what something is made out of?

Is fission/fusion to iron the most efficient way to convert mass to energy?

Co-worker is now managing my team. Does this mean that I'm being demoted?

Can artificial satellite positions affect tides?

Nth term of Van Eck Sequence

Converting 3x7 to a 1x7. Is it possible with only existing parts?

What things do I only get a limited opportunity to take photos of?

How long would it take for sucrose to undergo hydrolysis in boiling water?

Difference between "drift" and "wander"

Do legislators hold the right of legislative initiative?

Looking for an iPhone app for working out chess problems

My players want to use called-shots on Strahd

What is the context for Napoleon's quote "[the Austrians] did not know the value of five minutes"?

Can an open source licence be revoked if it violates employer's IP?

I sent an angry e-mail to my interviewers about a conflict at my home institution. Could this affect my application?

How many times to repeat an event with known probability before it has occurred a number of times

...and then she held the gun

Why can't we feel the Earth's revolution?

Threading data on TimeSeries

How to set limit first than create where query?

How to retrieve POST query parameters?How to store Node.js deployment settings/configuration files?How to create an HTTPS server in Node.js?How to get GET (query string) variables in Express.js on Node.js?How can I set NODE_ENV=production on Windows?How can I get the full object in Node.js's console.log(), rather than '[Object]'?node.js sequelize: multiple 'where' query conditionsnode how to create a directory if doesn't exist?How to retrieve query data output from Dynamodb using Node.jsSequelize add limit to query

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

1

I m making some project in which i have to do searching.

i have tried using limit and where query together but the priority of where is above limit so first it will do where query than set limit but i want to set limit first. let limit=4 so first i want to take 4 entries from sql and after that i want to apply where query

router.post("/****", async function(req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 tblAdmin
 .findAndCountAll()
 .then(data => 
 let pages = Math.ceil(data.count / limit);
 offset = limit * (page - 1);
 tblAdmin
 .findAll( "DESC],
 where: 
 firstName: [Op.like]: "%" + searchKey + "%" 
 
 )
 .then(users => 
 res.status(200).json(
 status: 1,
 message: "Data has been retrieved",
 result: users,
 count: data.count,
 pages: pages
 );
 );
 )
 .catch(err => 
 res.status(500).json(
 status: 0,
 message: "Data is not retrieved from database"
 );
 );
);

If i apply above logic it returns first four data from sql data which matches the where condition but i expect it to return the result of where condition of first four only not the fifth one

node.js sequelize.js

share|improve this question

asked Mar 25 at 2:46

RsKRsK

105

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what do you mean by fifth one?
  
  – Rahul Sharma
  Mar 25 at 4:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You need to do nested query in your FROM so I don't think you can do this with sequelize unless you're okay with using raw queries.
  
  – josephting
  Mar 25 at 5:15
  
  

  
  
  
  

add a comment | 

1

I m making some project in which i have to do searching.

i have tried using limit and where query together but the priority of where is above limit so first it will do where query than set limit but i want to set limit first. let limit=4 so first i want to take 4 entries from sql and after that i want to apply where query

router.post("/****", async function(req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 tblAdmin
 .findAndCountAll()
 .then(data => 
 let pages = Math.ceil(data.count / limit);
 offset = limit * (page - 1);
 tblAdmin
 .findAll( "DESC],
 where: 
 firstName: [Op.like]: "%" + searchKey + "%" 
 
 )
 .then(users => 
 res.status(200).json(
 status: 1,
 message: "Data has been retrieved",
 result: users,
 count: data.count,
 pages: pages
 );
 );
 )
 .catch(err => 
 res.status(500).json(
 status: 0,
 message: "Data is not retrieved from database"
 );
 );
);

If i apply above logic it returns first four data from sql data which matches the where condition but i expect it to return the result of where condition of first four only not the fifth one

node.js sequelize.js

share|improve this question

asked Mar 25 at 2:46

RsKRsK

105

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what do you mean by fifth one?
  
  – Rahul Sharma
  Mar 25 at 4:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You need to do nested query in your FROM so I don't think you can do this with sequelize unless you're okay with using raw queries.
  
  – josephting
  Mar 25 at 5:15
  
  

  
  
  
  

add a comment | 

I m making some project in which i have to do searching.

i have tried using limit and where query together but the priority of where is above limit so first it will do where query than set limit but i want to set limit first. let limit=4 so first i want to take 4 entries from sql and after that i want to apply where query

router.post("/****", async function(req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 tblAdmin
 .findAndCountAll()
 .then(data => 
 let pages = Math.ceil(data.count / limit);
 offset = limit * (page - 1);
 tblAdmin
 .findAll( "DESC],
 where: 
 firstName: [Op.like]: "%" + searchKey + "%" 
 
 )
 .then(users => 
 res.status(200).json(
 status: 1,
 message: "Data has been retrieved",
 result: users,
 count: data.count,
 pages: pages
 );
 );
 )
 .catch(err => 
 res.status(500).json(
 status: 0,
 message: "Data is not retrieved from database"
 );
 );
);

If i apply above logic it returns first four data from sql data which matches the where condition but i expect it to return the result of where condition of first four only not the fifth one

node.js sequelize.js

share|improve this question

asked Mar 25 at 2:46

RsKRsK

105

router.post("/****", async function(req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 tblAdmin
 .findAndCountAll()
 .then(data => 
 let pages = Math.ceil(data.count / limit);
 offset = limit * (page - 1);
 tblAdmin
 .findAll( "DESC],
 where: 
 firstName: [Op.like]: "%" + searchKey + "%" 
 
 )
 .then(users => 
 res.status(200).json(
 status: 1,
 message: "Data has been retrieved",
 result: users,
 count: data.count,
 pages: pages
 );
 );
 )
 .catch(err => 
 res.status(500).json(
 status: 0,
 message: "Data is not retrieved from database"
 );
 );
);

share|improve this question

asked Mar 25 at 2:46

RsKRsK

105

share|improve this question

asked Mar 25 at 2:46

RsKRsK

105

asked Mar 25 at 2:46

RsKRsK

105

asked Mar 25 at 2:46

RsKRsK

105

1 Answer
1

active

oldest

votes

0

Keep the order same for findAndCountAll function. The first function is returning the result in a different order second returning in different.

Instate of .then use await.

router.post("/****", async function (req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 const order = [sortfield );

share|improve this answer

edited Mar 25 at 4:19

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

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%2f55330649%2fhow-to-set-limit-first-than-create-where-query%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Keep the order same for findAndCountAll function. The first function is returning the result in a different order second returning in different.

Instate of .then use await.

router.post("/****", async function (req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 const order = [sortfield );

share|improve this answer

edited Mar 25 at 4:19

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

add a comment | 

0

Keep the order same for findAndCountAll function. The first function is returning the result in a different order second returning in different.

Instate of .then use await.

router.post("/****", async function (req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 const order = [sortfield );

share|improve this answer

edited Mar 25 at 4:19

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

add a comment | 

Keep the order same for findAndCountAll function. The first function is returning the result in a different order second returning in different.

Instate of .then use await.

router.post("/****", async function (req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 const order = [sortfield );

share|improve this answer

edited Mar 25 at 4:19

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

router.post("/****", async function (req, res, err) 1;
 let sortField = req.body.sortField;
 let sortOrder = req.body.sortOrder;
 if (searchKeyword) 
 var searchKey = searchKeyword;
 else 
 var searchKey = "";
 
 const order = [sortfield );

share|improve this answer

edited Mar 25 at 4:19

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319

answered Mar 25 at 4:11

Rahul SharmaRahul Sharma

3,4011319