Laravel eloquent use whereNotIn and Take in relationship data

Question

There is my code :

$course = Course::where('id', $activeCourseId)
        ->with(["blocks.cards" => function($q) use($cardsDueIds) {
            $q->whereNotIn('id', $cardsDueIds);
            $q->take(50);
        },
        "blocks.cards.contexts",
        "blocks.cards.user_contexts",
        "blocks.cards.block.course",
        "blocks.cards.thisUser"])
        ->first();

Course datas are like this :

{
  blocks: [
    0: {
      cards: [
       0: {id: 298736},
       1: {id: 293747}
      ]
    }
    1: {
      cards: [
       0: {id: 1234445}
      ]
    }
  ]
}

I try to get the course with only 50 blocks.cards where blocks.cards.id are not in the $cardsDueIds.

Actually it does not work, with take(50) i get 0 cards and without take(50) i get all cards (but the whereNotIn doesnt work)...

Anyone know how to do this ? Thanks !

can you print $cardsDueIds is this array or not? – Jigar Mar 17 '21 at 13:56 — Jigar, Mar 17 '21 at 13:56

JawadR1 · Accepted Answer · 2021-03-17T12:41:18.817

1

$q->whereNotIn('id', $cardsDueIds)->take(50);

If doesn't work, Refer to this thread.

edited Mar 17 '21 at 12:41

answered Mar 17 '21 at 12:30

JawadR1

379
3
16

Thanks for your answer, sorry but cards is empty with your solution – Tony S Mar 17 '21 at 12:34
Try `limit` instead of `take`. – JawadR1 Mar 17 '21 at 12:39
Sorry, same result with ->limit(50) – Tony S Mar 17 '21 at 12:40

score 0 · Answer 2 · answered Mar 17 '21 at 13:38

0

Please refrase your question (you say twice the same):

Actually it does not work, with take(50) i get 0 cards and with take(50) i get all cards...

answered Mar 17 '21 at 13:38

Kachelle

61
6

Laravel eloquent use whereNotIn and Take in relationship data

2 Answers2