Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Element Connect - Root element, filtering

Joel Batac
Contributor
July 7, 2022

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_ 

 

1 answer

0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 7, 2022

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
Contributor
July 8, 2022

image.png

Joel Batac
Contributor
July 8, 2022 edited

Hi Sebastian, I got it working..

 

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

 

Like • Sebastian Krzewiński likes this
Joel Batac
Contributor
July 8, 2022

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

Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 10, 2022

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

Joel Batac
Contributor
July 11, 2022

Capture.PNG

Joel Batac
Contributor
July 11, 2022

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

Joel Batac
Contributor
July 11, 2022 edited

@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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 13, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

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
AUG Leaders

Upcoming Jira Events