Search this space

Live demo

Want to see a live demo and learn what this Connector can do? Join our jam sessions!

Page tree

If you are looking for documentation for the new Salesforce & JIRA Cloud Connector, click here.

Skip to end of metadata
Go to start of metadata

Introduction


The connector provides a JQL function for advanced users to make sophisticated queries for issues in JIRA based on the remote objects that issues are associated with.

The function will determine which connection to query if you have multiple connections configured in your system.

For example, if you run a query on a Salesforce object, the lookup will take place for the Salesforce connection it is configured for.

Syntax


remoteObjects(field, value) OR
remoteObjects(field1, comparator1, value1, field2, comparator2, value2, ...)

The first syntax style is used for quick queries and defaults to a comparator of "LIKE".

The second syntax style is for more complex queries with other comparators and multiple "AND" conditions. If you want to build your query using multiple "OR" conditions, you can make use of the in-built JQL feature to "OR" multiple queries using the "remoteObjects" function.

See the Examples section for examples of each case.

Supported Fields


For a list of field names within a Salesforce object, please see the Salesforce.com Standard Objects documentation.

Supported Salesforce Comparators


=

!=

>

>=

<

<=

IN

NOT IN

LIKE

~

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

For more information on comparators, view the Atlassian Documentation on Advanced searching - operators reference.

Date Field Expressions

If comparing to specific dates, Salesforce is very particular about the format of the date string.

See: Date Formats and Date Literals on Salesforce.com.

Examples


These examples feature custom field names that are auto-generated when you create new mappings.

 

Find issues associated with Salesforce Users with an email address ending with "servicerocket.com"
"Salesforce.com User Reference" in remoteObjects("Email", "like", "servicerocket.com")
Find issues associated with Salesforce Cases related to "Acme Company"
"Salesforce.com Case Reference" in remoteObjects("Account.Name", "Acme Company")
Find issues associated with Salesforce Opportunity amount values between "10000" and "50000"
"Salesforce.com Opportunity Reference" in remoteObjects("Amount", ">", "10000", "Amount", "<", "50000")
Find issues associated with Salesforce Opportunities with a close date before, and including, 31st December 2011
"Salesforce.com Opportunity Reference" in remoteObjects("CloseDate", "<=", "2011-12-31")
Find issues associated with Salesforce Cases owned by "Fred Smith" or "Jane Doe"
"Salesforce.com Case Reference" in remoteObjects("Owner", "Fred Smith") OR "Salesforce.com Case" in remoteObjects("Owner", "Jane Doe")
Page Contents

  • No labels