Skip to main content
Solved

What fields can be used on allCards query AdvancedSearch?

  • October 11, 2021
  • 2 replies
  • 514 views

bernardo-costa

Hi guys, I’ve looked up the documentation but couldn’t find anything specifying which fields are allowed at the AdvancedSearch option for the allCards query.

 

Could you please list them here and/or append to the documentation?

 

Thanks

Bernardo

Best answer by Marcos Carvalho

Hi @bernardo-costa,

 

This AdvancedSearch option can be used just for the “due_date” and “updated_at” fields. 

But in order to do that, you must provide a valid datetime value just like this one: 

"2017-12-18T00:00:00-02:00"

 

Here some code snippets for you:

{
  allCards(pipeId: 12345678, filter: {field: "updated_at", operator: gt, value: "2017-12-18T00:00:00-02:00"}) {
    edges {
      node {
        id
      }
    }
  }
}

 

 

{
  allCards(pipeId: 12345678, filter: {field: "due_date", operator: gt, value: "2017-12-18T00:00:00-02:00"}) {
    edges {
      node {
        id
      }
    }
  }
}

 

 

Hope it helps you :relaxed:

View original
Did this topic help you find an answer to your question?

2 replies

Marcos Carvalho
Pipefy Staff
Forum|alt.badge.img+6

Hi @bernardo-costa,

 

This AdvancedSearch option can be used just for the “due_date” and “updated_at” fields. 

But in order to do that, you must provide a valid datetime value just like this one: 

"2017-12-18T00:00:00-02:00"

 

Here some code snippets for you:

{
  allCards(pipeId: 12345678, filter: {field: "updated_at", operator: gt, value: "2017-12-18T00:00:00-02:00"}) {
    edges {
      node {
        id
      }
    }
  }
}

 

 

{
  allCards(pipeId: 12345678, filter: {field: "due_date", operator: gt, value: "2017-12-18T00:00:00-02:00"}) {
    edges {
      node {
        id
      }
    }
  }
}

 

 

Hope it helps you :relaxed:


bernardo-costa

Thanks, Marcos!

It would be great if you can add the “createdAt” date field to this filter. It would help us better manage cards by creation cohorts.

 

BR,

Bernardo


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings