How to add condition for a table that is related to other(while joining tables) about crystal HOT 8 CLOSED

Hey! I found the issue,
I just missed placing connectionFilterRelations: true inside graphileBuildOptions.

graphileBuildOptions: {
      connectionFilterRelations: true, // default: false
 }

Adding this worked!

from crystal.

This is more a question for the filter plugin, but something like this:

{
  AAAA(filter: {ab: {isNull: false}, BBBB: { type: { isEqual: "ccdd" } }}) {
    nodes {
      id
      BBBB{
        type
      }
    }
    totalCount
  }
}

You need to turn on relational filters; see: https://github.com/graphile-contrib/postgraphile-plugin-connection-filter?tab=readme-ov-file#connectionfilterrelations

from crystal.

What should be the version of the postgraphile for this filter to work?

This filter is not working in this version
"postgraphile": "^4.13.0",
"postgraphile-plugin-connection-filter": "^2.3.0"

from crystal.

Any release from the last couple years should work; do make sure you read the filter plugins documentation though - especially the part I mentioned above about enabling relational filters.

from crystal.

This is not working for me,

I am getting the above error.

I have added this connectionFilterRelations: true. But still it is not working
Can you please let me know what is causing the issue?

from crystal.

Seems like you’re querying field 🟥🟥🟥🟥 on type 🟥🟥🟥🟥, but that field doesn’t exist. You should use GraphiQL or similar to build your query so it will show you what’s wrong.

from crystal.

This is the query I am using

{
  Users(
    filter: {userName: {equalTo: "raghav"}, Account: {accountStatus: {equalTo: "active"}}}
  ) {
    nodes {
      userName
      Account {
        accountName
        accountId
        accountStatus
      }
    }
    totalCount
  }
}

Error:
"message": "Field "Account"" is not defined by type "UsersFilter".

from crystal.

Great; glad it's working! You should note that this is exactly what I linked you to 3 weeks ago and then referenced again 3 days ago.

from crystal.