How can i filter by a no-unique field

1

Hi, i was trying to make an update and filter this by a relation with other tables, but it only let me filter by the field with unique values, is it possible to filter by a no- unique field ?

2

Hello!

Could you send your mutation and schema, please? Just want to make sure that I understand you correctly.

Lada Kokotova | Technical Support Engineer

3

I wanted to filter by a relational field value

Captura de Pantalla 2021-10-13 a la(s) 12.10.39 p. m..png1040×749 37.8 KB
in this case “vehicleID” but it only let me filter by it’s unique values, is it possible to filter by it’s relational field values?

4

Thanks, I’ve got your problem. I’ll give you a full response soon.

Lada Kokotova | Technical Support Engineer

5

Hello!

You can remove “ID” postfix from the name of the table, because your tables ownerID and vehicleD are full-fledged entities.

Here’s an example of mutation for your issue:

query myQuery {
  ownersList(filter: {vehicleTable: 
    {createdAt: 
        {not_equals: "2007-12-25T16:15:30Z"}}}) {
          items {
            id
             vehicleTable {
              createdAt
              id
      }
    }
  }
}

Lada Kokotova | Technical Support Engineer