Count, Distinct & Distinct with query
Count
👉 Get count of rows in database which satisfy our query.
✅ List of Feature
⚡️ Body payload structure is same for all database.
⚡️ Find join feature supported in count API.
⚡️ User applied condition in count API.
⚡️ Number of operator support.
⭐ Supported Operator ⭐
⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like
Distinct [GET API]
👉 Get distinct data from the table for a given field on ascending or descending order.
⭐ Params ⭐
👉 field ▸ Retrieve the fields based on the user's needs.
👉 order ▸ Sort data in ascending or descending order.
⭐ Query Params ⭐
👉 find ▸ User can retrieve data using find object value.
✅ List of Feature
⚡️ Body payload structure is same for all database.
⚡️ Find object supported in distinct API.
⚡️ N number of combinations should be supported in distinct.
⭐ Supported Operator ⭐
⚡️ $in
⚡️ $nin
⚡️ $and
⚡️ $or
⚡️ $eq
⚡️ $ne
⚡️ $ne
⚡️ $gt
⚡️ $gte
⚡️ $lt
⚡️ $lte
⚡️ $like
Distinct with query [POST API]
👉 Get distinct data from the table for a given field on ascending or descending order.
⭐ Params ⭐
👉 field ▸ Retrieve the fields based on the user's needs.
👉 order ▸ Sort data in ascending or descending order.
⭐ Body ⭐
👉 User can retrieve data using find object value.
✅ List of Feature