Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How can you import multiple values against an object reference?

Liesa Pugsley
Liesa Pugsley October 17, 2017

Using Insight for jira. 

I have an SQL Database import. I have multiple entries for the same ID.
 So I have a User ID and then I have multiple roles for them. For example,
 User ID   Role
 Anne      Assistant
 Anne      Receptionist
 Bob        Gardener

I have an object reference on the object I am importing to a Roles object. How can I get multiple roles to appear in the imported object. If I was performing this as a CSV I would use || (2 pipes) . What do I use for SQL?

Answer
Watch
Like Be the first to like this
378 views

1 answer

0 votes
Alexander Sundström
Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
October 18, 2017

If the cardinality is correct (i.e more than one, at least 2 in this case), the imports takes care of this by default. 

Try it out and let us know if it works.

Best Regards
Alexander

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events