Limit API Results & Increment "Views" on those

veggie_89 · June 23, 2023, 6:30pm

System Information

Strapi Version: 4.11.1:
Mac OS 12.6.6:

I’m trying to update my controller to return only 3 results with the lowest views, and then increment the views counter on each of those 3 entities. Would I use pagination to limit results? How can I modify a field (views) on each of the entities on the first page only? Any help is much appreciated!

veggie_89 · June 23, 2023, 9:52pm

I’ve made some headway and discovered I can either use API query parameters:

?pagination[page]=1&pagination[pageSize]=3&sort[0]=Cycles&sort[1]=createdAt%3Aasc

Or I can use the entityService:

let entries = await strapi.entityService.findMany('api::community.community', {
        populate: '*',
        sort: [{ Cycles: 'asc' }, { publishedAt: 'desc' }],
        limit: 2,
      });

I’d rather use the entity service, but it doesn’t return the entities in the same format as super.find(ctx), When I use super find most of the information is placed inside an attributes object, but when I use entityService the information is all placed on the root of the objects which breaks my consuming API. Is there a way to get entityService to output the same format as super.find()?

I noticed the core components used to be viewable in the documentation but now I’m not sure how I can examine the code from the core find() module.

Boegie19 · June 23, 2023, 10:57pm

You can using tranformResponse that should tranform it into the right format

github.com

strapi/strapi/blob/c8d6478ec519888ce0cd754886474c3189efc733/packages/core/strapi/lib/core-api/controller/collection-type.js#L25

    
      
          return {
            /**
             * Retrieve records.
             *
             * @return {Object|Array}
             */
            async find(ctx) {
              const sanitizedQuery = await this.sanitizeQuery(ctx);
              const { results, pagination } = await strapi.service(uid).find(sanitizedQuery);
              const sanitizedResults = await this.sanitizeOutput(results, ctx);
              return this.transformResponse(sanitizedResults, { pagination });
            },
          
          
  /**
             * Retrieve a record.
             *
             * @return {Object}
             */
            async findOne(ctx) {
              const { id } = ctx.params;
              const { query } = ctx;

veggie_89 · June 24, 2023, 4:20am

Thank you so much! That’s exactly what I was looking for!

Reggie