How can I find only products created by user

Questions and Answers
1

Preformatted text``Preformatted text[details=“System Information”]

  • Strapi Version: V4
  • Operating System: Linux
  • Database: MySQL
  • Node Version: 16.14.2
  • NPM Version: 8.7.0
  • Yarn Version:
    [/details]

I modified the controller, but I don’t know how can I select some product in DB by “created_by_id”. I’m trying something like this:

module.exports = createCoreController(‘api::produto.produto’, ({ strapi }) => ({
async findOne(ctx) {
const { user } = ctx.state;
const { id } = ctx.params;
const { query } = ctx;

    const entity = await strapi.service('api::produto.produto').findOne({
           id, query,
           where: {
              'created_by_id': user.id
        }
     });

}));

but this format is not possible… someone got it?

Thanks

2

Could you get it?

3

You can find the answer from my strapi study case.
You also can use findMany and filters, and you will find more solution from strapi docs

2 Likes
4

Hi @LuisAlaguna ! Not yet

5

You are using “filters”, but filters only can be used in find, not in findOne for example. I need to put something like a middleware. Example: GavinXue only can modify products created by him, so in the request, I need verify if the user_id is the same of created_by_id.

6

But you can use filter with findOne.

7

You can use db query API findOne as LuisAlaguna mentioned before. If you want use EntityService api, you can get the population result, then estimate the equation between query user and created user.

8

image
image693×1176 106 KB

Sorry by the image, but new users can post only 1 picture.

9

This topic can be closed!
I found here: Get userinfo from createdBy and updatedBy v4 - #4 by Leonardo_Assef the solution! Thanks.