| contentAdfStringified | {"type":"doc","version":1,"content":[{"type":"table","content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Plugin:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"qnpxv7zq5i","extensionKey":"short-text","name":"content:space","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Question:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"35cb9wsr2h","extensionKey":"short-text","name":"page:title","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Answer:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"paragraph","parameters":{"id":"f86t9ehkin","extensionKey":"paragraph","name":"kbAnswer","isRequired":false,"Type":"area","atlassian-macro-output-type":"BLOCK"},"layout":"default"}}]}]}]}]} |
|---|
| fieldGroupName | migrated |
|---|
| fieldGroupId | dti0ewrpmn |
|---|
| excerpt | Plugin: Classic Connector for Salesforce & Jira Question: How Do I Resolve "MALFORMED_QUERY" or "QUERY_TOO_COMPLICATED"? Answer: The problem happens when the SOQL generated by the Connector violates the following Salesforce rules: MALFORMED_QUERY: SOQL statements cannot query more than 10000 characters QUERY_TOO_COMPLICATED: Query is either selecting too many fields or the filter conditions are too complicated These issues are solved by enabling the Optimize Query to Remote System (Only query fields mapped, limited details sent to JIRA) . (See Image 1.) Image 1: Enabling the Optimize Query to Remote System To enable Optimize Query to Remote System: Go to Administration > Add-ons > Mappings Click Configure Expand the Settings menu Click Enable on the far right of Optimize Query to Remote System IF after you have performed the previous steps, you still receive this error message: MALFORMED_QUERY: SOQL statements cannot query more than 35 different parent types Then you will have to start unchecking fields from the Read Access column in your credential account that you use for the Connector setup in JIRA. (See Image 2.) Image 2: Unchecking fields in Visibility column To uncheck fields from the Read Access column: Log in to Salesforce.com Go to Administration Setup > Profiles > {Profile Name} Then under Field-Level Security > {object name} (e.g. Account, Case, Contact, etc.) > click View On the Field-Level Security for profile page that appears, click Edit In the Read Access column, uncheck all entries with Field Types that appear more than 35 times (e.g., Lookup, Phone, etc.) After uncheck all entries with Field Types that appear more than 35 times. Please clear the cache with the following steps. Method 1: Reconfigure authentication JIRA -> Add-ons -> Left panel under Cloud Connectors , click Connections -> Your Connection -> Click on the Application Link associated -> Your Application Link -> Configure Authentication -> Disable Reconfigure Authentication *Note*: Please remember to append your security token at the end of your password. Method 2: Re-caching within JIRA JIRA -> Add-ons -> Left panel under Cloud Connector , click Mappings -> Your Mapping -> Configure -> Click on the Click Here link |
|---|
| propertyKeys | ["net.customware.confluence.plugin.scaffolding__dti0ewrpmn__data_0_5kl8e5fgzj"] |
|---|
|