Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,586
Community Members
 
Community Events
165
Community Groups

Conditionally set a boolean field in an InSight CSV import

Greg Popp I'm New Here Jun 17, 2022

I'm trying to create an import attribute mapping for an object that contains a boolean field. If  the imported data field is set to the string "manifest" I want to set the boolean field in the object to true, and if it's set to anything else, I want it to be set to false. Is there a way to do this? Possibly with a regular expression?
I've tried using this simple regex:

manifest

But that results in the one record that has the field set to "manifest" to be set to false, and all the other objects have that field as "No Value". Then I tried to negate the regex:

.*(?<!manifest)$

But that always results in the field being set to false in every object, even when the imported data is the string "manifest".

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

158 views 1 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you