getCount when using take

[shellking4]

I have a behavior in typeorm lately. Here is my query :

            queryBuilder.where("ticket.code ILIKE :code", { code: `%${searchString}%` })
                .orWhere("ticket.encryptedCode ILIKE :encryptedCode", { encryptedCode: `%${searchString}%` },)
                .orWhere("payment.transaction ILIKE :transaction", { transaction: `%${searchString}%` },)
                .orWhere("payment.caissier ILIKE :cashier", { cashier: `%${searchString}%` },)
                .orWhere("gate.number ILIKE :gateNumber", { gateNumber: `%${searchString}%` },);
        }))
            .skip(skip)
            .take(dataLength)
            .getManyAndCount();

const dataCount = query[1]

I expect to have dataCount === dataLength but it's not the case. Instead the number of elements selected by the query before applying take is returned. Is this the way it works or what is going on in here ?

[iJhefe]

"getCount" doesnt consider the parameters "take" and "skip"

[rubber-bird]

As mentioned on previous response you can count those which you need without take or skip, because these functions in query builder is generated it omits these clauses. you can select those which you need and then use length method of returned array.

[shellking4]

Thank y'all for your replies. It is something I really didn't know of. It was seeming so weird to me. Now that I know I'll be careful next time

[shellking4]

As mentioned on previous response you can count those which you need without take or skip, because these functions in query builder is generated it omits these clauses. you can select those which you need and then use length method of returned array.

Thank you @rubber-bird. This is what I did finally. Thank you very much