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")]
@Laura Campbell _Seibert Group_
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sebastian, I got it working..
I missed the .state, it should be $.data.iterateIP.IP[?(@state.id=="approved")]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Joel Batac how do you display data in field? Can you share whole 'edit view' tab?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sebastian - i think were good, I just mentioned both in the Template
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Joel Batac Can you tell more what do you want to do?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.