Skip to main content
Solved

Get the late cards from a sprecific pipe using GraphQL

contato1705
Forum|alt.badge.img

Hey everyone! I’m trying to get all the late cards from a specific pipe. At the moment, i’m using this code here, that gives me all the cards from the pipe and then, on my editor, i filter the late ones:

{allCards(pipeId: XXXXXXXX, first: 50) 
  {pageInfo {
    hasNextPage
    endCursor
  }
    edges {
      node {
        id
        late
        current_phase{
          id}
      }
    }
  }
}

 

Is there a way that i can get only the late cards? Like a request that only returns the late cards, an their respectives id and current phase?

Best answer by marcosmelo

contato1705 wrote:

Hey everyone! I’m trying to get all the late cards from a specific pipe. At the moment, i’m using this code here, that gives me all the cards from the pipe and then, on my editor, i filter the late ones:

{allCards(pipeId: XXXXXXXX, first: 50) 
  {pageInfo {
    hasNextPage
    endCursor
  }
    edges {
      node {
        id
        late
        current_phase{
          id}
      }
    }
  }
}

 

Is there a way that i can get only the late cards? Like a request that only returns the late cards, an their respectives id and current phase?



Hello, @contato1705 

The following code fetches the specified phase and returns only late cards

Check if its helps

 

{

    phase(id: "xxxxxxxxxx") {
    name
    cards {
        edges {
          node {
            id
            title
            late
           
            }
          
            }
          }
        }
      }
    

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

6 replies

marcosmelo
Forum|alt.badge.img+18
  • marcosmelo
  • Pipefy Legend
  • 1465 replies
  • Answer
  • March 13, 2023
contato1705 wrote:

Hey everyone! I’m trying to get all the late cards from a specific pipe. At the moment, i’m using this code here, that gives me all the cards from the pipe and then, on my editor, i filter the late ones:

{allCards(pipeId: XXXXXXXX, first: 50) 
  {pageInfo {
    hasNextPage
    endCursor
  }
    edges {
      node {
        id
        late
        current_phase{
          id}
      }
    }
  }
}

 

Is there a way that i can get only the late cards? Like a request that only returns the late cards, an their respectives id and current phase?



Hello, @contato1705 

The following code fetches the specified phase and returns only late cards

Check if its helps

 

{

    phase(id: "xxxxxxxxxx") {
    name
    cards {
        edges {
          node {
            id
            title
            late
           
            }
          
            }
          }
        }
      }
    

Marcos Melo
genietim
Lucas Democh
Lais Laudari
7 people like this
  • genietim
    genietim
  • Lucas Democh
    Lucas Democh
  • Lais Laudari
    Lais Laudari
  • Ezequiel Souza
    Ezequiel Souza
  • V
    vicente-lemes
  • Leandro Almeida
    Leandro Almeida
  • contato1705
    contato1705
genietim
Forum|alt.badge.img+12
  • genietim
  • Pipefy Legend
  • 412 replies
  • March 14, 2023

The answer by @marcosmelo does not do what you want, @contato1705 . It only lists the cards of a specific phase, without limit on whether they are late or not.

What should be possible instead is to use the https://api-docs.pipefy.com/reference/queries/#allCards allCards query with the filter, where you filter for the date.

I currently do not have the necessary tools available, but I will add another answer later with the actual query I would suggest.

Lucas Democh
Lais Laudari
Ezequiel Souza
6 people like this
  • Lucas Democh
    Lucas Democh
  • Lais Laudari
    Lais Laudari
  • Ezequiel Souza
    Ezequiel Souza
  • V
    vicente-lemes
  • marcosmelo
    marcosmelo
  • contato1705
    contato1705
marcosmelo
Forum|alt.badge.img+18
  • marcosmelo
  • Pipefy Legend
  • 1465 replies
  • March 14, 2023

Thanks for contributing, @genietim !

Marcos Melo
Lucas Democh
Ezequiel Souza
V
3 people like this
  • Lucas Democh
    Lucas Democh
  • Ezequiel Souza
    Ezequiel Souza
  • V
    vicente-lemes
genietim
Forum|alt.badge.img+12
  • genietim
  • Pipefy Legend
  • 412 replies
  • March 14, 2023

As promised, here an example query using the advanced search to query to the due date:

 

query {
    allCards(pipeId: <yourPipeId>, filter: {
        field: "due_date",
        operator: lte,
        value: "2023-03-14T00:00:00-02:00"
    }) {
        edges {
            node {
                id title late
                fields {
                    name
                    value
                }
            }
        }
    }
}

 

that should solve your problem, no?

Lucas Democh
Lais Laudari
V
4 people like this
  • Lucas Democh
    Lucas Democh
  • Lais Laudari
    Lais Laudari
  • V
    vicente-lemes
  • marcosmelo
    marcosmelo
genietim
Forum|alt.badge.img+12
  • genietim
  • Pipefy Legend
  • 412 replies
  • March 14, 2023

(thank you too, @marcosmelo , sorry if my answer was a bit too dismissive as I realise now, and sorry if I understood something wrong anyway)

Lucas Democh
Lais Laudari
Ezequiel Souza
5 people like this
  • Lucas Democh
    Lucas Democh
  • Lais Laudari
    Lais Laudari
  • Ezequiel Souza
    Ezequiel Souza
  • V
    vicente-lemes
  • marcosmelo
    marcosmelo
marcosmelo
Forum|alt.badge.img+18
  • marcosmelo
  • Pipefy Legend
  • 1465 replies
  • March 14, 2023

Don't worry, @genietim. 

Tks!!

Marcos Melo
genietim
Lucas Democh
Ezequiel Souza
4 people like this
  • genietim
    genietim
  • Lucas Democh
    Lucas Democh
  • Ezequiel Souza
    Ezequiel Souza
  • V
    vicente-lemes

Reply


Terms & ConditionsCookie settings

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