How to use paginate data with more than one model? [Adonis 5]

[pk4all]

Hi,
I want to search data with two models Post and User and want to paginate both result.

[melokki]

Hello,
Have you tried something like this?

await User.query()
        .where("name", "LIKE", "%something%")
        .preload("posts", (query) => {
          query.where('title', "LIKE", "%something%");
        }).paginate(request.input('page', 1),10);

[thetutlage]

Why would you merge the data from Users and Posts into one object? If you are looking for relationships, then @melokki has answered it for you

[pk4all]

Yes I need Users and Posts into one object, In my app we perform a search operation from User and post both table. So we need this.

[thetutlage]

I suggest using the database query builder directly and perform the join. Merging results of two models into one is not possible

[pk4all]

I suggest using the database query builder directly and perform the join. Merging results of two models into one is not possible

@thetutlage Okay Thanks a lot for quick reply.