Element Connect - Root element, filtering

[Joel Batac]

HI,

 First time EC user here . How do I filter my json file? I only want to display in my jira if it is in approved status 

{
"data": {
"iterateIP": {
"IP": [
{
"name": "ACME Corp",
"shortId": "12345",
"state": {
"id": "approved"
}
},
{
"name": "WACO 123",
"shortId": "abcd3",
"state": {
"id": "cancelled"
}
},

{
"name": "Mickey Mouse Inc",
"shortId": "000314",
"state": {
"id": "open"
}
}
]
}
}
}

I tried this but not working

$.data.iterateIP.IP.*[?(@.id=="approved")]

@Julie d_Antin _Elements_ 

[Sebastian Krzewiński]

Hi @Joel Batac 

Can you share whole configuration of EC field? It will be easier to investigate this.

IMHO you should use $.data.iterateIP.IP[?(@.id=="approved")] but as I said - it will be better when you will share field config (can be a screenshot)

Regards,

Seba

[Joel Batac]

[Joel Batac]

Hi Sebastian, I got it working..

I missed the .state, it should be $.data.iterateIP.IP[?(@state.id=="approved")]

[Joel Batac]

@Sebastian Krzewiński  - is it possible to display name and shortId together?

[Sebastian Krzewiński]

@Joel Batac how do you display data in field? Can you share whole 'edit view' tab?

[Joel Batac]

[Joel Batac]

Sebastian - i think were good, I just mentioned both in the Template

[Joel Batac]

@Sebastian Krzewiński -  another problem/question :) now that we'll want move forward with EC. How do we update old tickets (5000+) that don't have shortid (EC Field) and name(different CF) using issueid?

FYI, shortid and name will be different for each issueid.

[Sebastian Krzewiński]

@Joel Batac Can you tell more what do you want to do?