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.
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.
- Remote Object Link
- Multi Remote Object Link
- Remote System Reference (an accompanying read-only custom field of type "Remote System Reference" is automatically created for you to display the information from Salesforce in the Jira issues.)
For a list of field names within a Salesforce object, please see the Salesforce Standard Objects documentation.
Supported Salesforce comparators
For more information on the supported 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.
These examples feature custom field names that are auto-generated when you create new mappings.