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.
Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.