Hello < Ryan> I created model called `List` and `Activity` ` Prisma #orm-help

Hello <@UESADRKMY> I created model called `List` a...

Jemin Kothari

10/22/2021, 7:29 AM

Hello @Ryan I created model called

List

and

Activity

Copy code

model List {
 id   Int             @id @default(autoincrement())
 Activity             Activity[]
 @@map("list")
}

model Activity {
 id             Int          @id @default(autoincrement())
 status         String
 list_id        Int
 List           List        @relation(fields: [list_id], references: [ID])
 @@map("activity")
}

Jemin Kothari

10/22/2021, 7:31 AM

Now I need to new column called listDoneActivity so created extend type like below

Copy code

export const ListDoneActivity = extendType({
    type: 'List',
    definition(t) {
      t.field('listDoneActivity', {
        type: nonNull('Int'),
        args: {
            filter: intArg(),
          },
        async resolve(parent: any, args, ctx: Context) {
            console.log('parent', parent)
            console.log('args', args)
        return parent.Activity.filter(
              (item) => item?.status                === 'Done')?.length
        },
      })
    },
  })

Jemin Kothari

10/22/2021, 7:31 AM

Now I need to apply filtering on the List that I need only those records which has

listDoneActivity

> 2

Jemin Kothari

10/22/2021, 7:31 AM

So how can I achieve this @Ryan?

Jemin Kothari

10/22/2021, 9:11 AM

@Ahmed

Ahmed

10/22/2021, 10:51 AM

@Jemin Kothari if you using the prisma select plugin please take a look to this example in paljs docs https://paljs.com/plugins/select#filter

Ahmed

10/22/2021, 10:53 AM

you can add a new extends type and use the default fields but you need to add the original file

Activity

to default fields because maybe frontend asking for the other one extends on this one put not this one this mean will get an error

Jemin Kothari

10/22/2021, 10:53 AM

Yes, but now I need to filter on this new extended type

Jemin Kothari

10/22/2021, 10:54 AM

Now I need to apply filtering on the List that I need only those records which has

listDoneActivity

> 2

Ahmed

10/22/2021, 10:57 AM

ok now you have your filter here

args.filter

and you can use easily here

Copy code

parent.Activity.filter(
              (item) => item?.status                === 'Done')?.length

Jemin Kothari

10/22/2021, 10:59 AM

Copy code

let doneCount = parent.Activity.filter(
              (item) => item?.status                === 'Done')?.length
return doneCount  > args.filter ? doneCount : null

3 Views

Open in Slack

Previous Next