Yes Dhruv, Your explanation is correct.
{api_id:1} definition is for retrieving the only selected fields from the collection, i have around 30 fields defined, i would only need 10 out of them. I am adding whole original query below:
entityS = await strapi.query(‘subscriptions’).model.find({$and:[{enterprise_id:ctx.query.enterprise_id},{$or:[{subscription_status:‘ToBeSubscribed’},{subscription_status:‘ToBeUnsubscribed’}]}]},{
api_id:1,
consumer_id:1,
plan_id:1,
section_id:1,
subscription_requested_date:1,
unsubscription_requested_date:1,
consumption_start_date: 1,
consumption_end_date:1,
approved_date:1,
rejected_date:1,
subscription_status:1,
subscription_processed_by:1,
unsubscription_processed_by:1,
//Below fields added for Admin history list
api_type:1,
comment:1
});