Skip to main content
Solved

What fields can be used on allCards query AdvancedSearch?

  • October 11, 2021
  • 2 replies
  • 635 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:

2 replies

Marcos Carvalho
Pipefy Staff
Forum|alt.badge.img+6
  • Pipefy Staff
  • 55 replies
  • Answer
  • October 13, 2021

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
  • Author
  • Explorer
  • 5 replies
  • October 13, 2021

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