{"type":"doc","content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"button-handy","parameters":{"macroParams":{"blank":{"value":"true"},"color":{"value":"#0052CC"},"name":{"value":"Send Feedback"},"link":{"value":"https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=Custom+fields+support+SIL+script+-+793280566"},"width":{"value":"auto"}},"macroMetadata":{"macroId":{"value":"3e75d2b6-a825-4f59-a505-a6e1c5df121d"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://handy-macros.stiltsoft.net/img/macros/handy-button.svg"}}],"title":"Handy Button"}}}}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ee3683e2-21ac-4adf-9390-55369e6f13f6"},"schemaVersion":{"value":"1"},"title":"Excerpt"}},"localId":"25f515eb-fd35-4c74-aa5b-c9badb2e7d61"},"content":[{"type":"paragraph","content":[{"text":"A useful tool for getting the most support for Jira Product Discovery.","type":"text"}]}]},{"type":"layoutSection","marks":[{"type":"breakout","attrs":{"mode":"wide"}}],"content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"This script is designed to discover the custom field ID’s of the Product Discovery fields that are seeming hidden in the product. The script will attempt to create ","type":"text"},{"text":"SIL aliases","type":"text","marks":[{"type":"link","attrs":{"href":"https://appfire.atlassian.net/wiki/spaces/PSJC/pages/496206057"}}]},{"text":" for these fields so that they may be used normally in the future scripts.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"What it does","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Part A: Finding the custom fields","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 1: Dynamically search","type":"text"}]},{"type":"paragraph","content":[{"text":"This step will find all the Product Discovery projects and get the all the ideas from each project. Then it loops through every idea and gets the custom fields used in that submission. The idea being that the field needs to be populated to get the information returned, by searching every issue it has a high probability of finding all the fields.","type":"text"}]},{"type":"paragraph","content":[{"text":"The nice part about this step is that if Atlassian adds any new fields they will automatically be picked up automatically without modifying the script.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 2: Static/heuristic search","type":"text"}]},{"type":"paragraph","content":[{"text":"In the event that custom fields are not populated this step uses a predefined list of supported custom fields to search for the field ID.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1655,"alt":"image-20240227-222447.png","id":"d4dffb78-1eff-4742-b057-49fcd06be931","collection":"contentId-793280566","type":"file","height":690}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Notice the progress and output from the script is displayed in the console tab at the bottom of the ","type":"text"},{"text":"SIL Manager","type":"text","marks":[{"type":"link","attrs":{"href":"https://appfire.atlassian.net/wiki/spaces/PSJC/pages/490996983"}}]},{"text":" (image above). The output from each step is marked.","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Part B: Creating the SIL aliases","type":"text"}]},{"type":"paragraph","content":[{"text":"Now that the script has retrieved all the IDs for the custom fields, the next step is to create the SIL aliases. The alias name is dynamically generated using camel case. So, for example, if the custom field name is “Idea short description” the camel case alias would be","type":"text"},{"text":" ideaShortDescription","type":"text","marks":[{"type":"em"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1608,"alt":"image-20240227-222405.png","id":"1916820b-59c9-42aa-91b4-d11f901e12fb","collection":"contentId-793280566","type":"file","height":659}}]},{"type":"paragraph","content":[{"text":"In the event that an alias can not be created, an error message is displayed in the output with a link to the documentation about how to ","type":"text"},{"text":"create the alias manually","type":"text","marks":[{"type":"link","attrs":{"href":"https://appfire.atlassian.net/wiki/spaces/PSJC/pages/496206151"}}]},{"text":". The exact code that should be used to create the alias manually is also displayed in the output. However, the main reason that such an error occurs is that the alias already exists so the first step should be to verify if the alias is already in the sil.aliases file.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"What to watch out for","type":"text"}]},{"type":"paragraph","content":[{"text":"The script adds the new aliases directly to the sil.asliases file. On some rare occasions a line break may be missing from the end of the last line which will cause new lines to bump up against the last existing line (see the image below). This usually only occurs when someone manually deletes the line break. Since the aliases are combined they are not formed correctly and will not work as indented. It is a good idea to check this file after running the script.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":760,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1920,"alt":"image-20240227-222720.png","id":"01437a23-2e05-4d29-b522-f751b2364d97","collection":"contentId-793280566","type":"file","height":911}}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"There are some other things to watch out for that are described in the","type":"text"},{"text":" known limitations","type":"text","marks":[{"type":"link","attrs":{"href":"https://appfire.atlassian.net/wiki/spaces/PSJC/pages/797638671"}}]},{"text":" page. It is important to review this material as well.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Code","type":"text"}]},{"type":"paragraph","content":[{"text":"To run this code:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a new file in the SIL Manager (right click on a folder)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Copy and paste the code below into the new file","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the green run button at the top of the SIL Manager","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Watch it go!","type":"text"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"This script was written in such a way that it will work on anyone's Jira Cloud instance and with any Product Discovery fields that it can find. Because of this the code is much longer than it really needs to be, the SIL language is much easier then the code below may make it appear.","type":"text"}]}]},{"type":"expand","attrs":{"title":"SIL script to enable custom field support for Jira Product Discovery"},"content":[{"type":"codeBlock","content":[{"text":"struct _pdField {\n string name;\n string id;\n string alias;\n}\n\nfunction camelCase(string name) {\n string [] words = split(name, \" \");\n string cc = toLower(words[0]);\n \n for(int x=1; x\" + proj + \"\", true);\n dots += \".\";\n for(string issue in selectIssues(\"project = \" + proj, 100)) {\n for(string af in arrayKeys(getIssueFields(issue, true))) {\n if(startsWith(af, \"custom\")) {\n string name = getCustomFieldNameById(af);\n allPDFields[name] = {name, af, camelCase(name)};\n }\n }\n }\n }\n}\n\nrunnerLog(\"Dynamic scan complete, \" + trim(size(allPDFields)) + \" fields found in scan.\", true);\nrunnerLog(\"

\", true);\n\n//--new section--\n\nrunnerLog(\"\");\nrunnerLog(\"Starting heuristic search of Jira Product Discovery fields:\", true);\n\nstring [] knownFields = \"Category|Customer segments|Documents|Goal|Idea archived|Idea archived on|Idea short description|Product Area|Rank|Request participants|Roadmap|Teams\";\nint added = 0;\n\nfor(string k in knownFields) {\n _pdField test = allPDFields[k];\n \n if(isNull(test.name)) {\n allPDFields[k] = {k, null, camelCase(k)};\n runnerLog(k);\n added ++;\n }\n}\n\nrunnerLog(\".\", true);\nrunnerLog(\"..\", true);\nrunnerLog(\"...\", true);\nrunnerLog(\"Heuristic scan complete, \" + trim(added) + \" field(s) found in scan.\", true);\nrunnerLog(\"

\", true);\n\n//--new section--\n\nrunnerLog(\"\");\nrunnerLog(\"Creating SIL aliases for Jira Product Discovery fields:\", true);\nint success_count = 0;\nint error_count = 0;\n\nfor(_pdField f in arrayStructSort(allPDFields,\"name\")) {\n boolean result = admAddCustomFieldAlias(f.name, f.alias);\n \n if(result) {\n runnerLog(\"Success: SIL alias created for \\\"\" + f.name + \"\\\": \" + f.alias + \"\", true);\n success_count ++;\n } else {\n string message = \"Error: The SIL alias for \" + f.name + \": \" + f.alias + \" was not able to be created for an unknown reason.\";\n message += \" It's possible this occured because the alias already exists.\";\n if(isNotNull(f.id)) {\n message += \" The SIL alias for will need to created manually. See this page for instructions.\";\n message += \" Insert the following text into the sil.aliases file:\";\n message += \"

\" + f.alias + \"=\" + f.id + \"

\";\n error_count ++;\n }\n runnerLog(message, true);\n }\n}\n\nrunnerLog(\"Done! \" + trim(success_count) + \" SIL aliases were created with \" + trim(error_count) + \" errors.\", true);","type":"text"}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"paragraph","content":[{"text":"Contents","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"2"},"outline":{"value":"false"},"style":{"value":"none"},"type":{"value":"list"},"printable":{"value":"false"}},"macroMetadata":{"macroId":{"value":"8dd5f14e-c513-4391-b799-684fe5cdc0be"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"ed64ed06-ef9c-45dc-8826-3c540680dcb7"}}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.ecosystem","extensionKey":"fc909b09-b512-4c31-a844-dd855b0e6aae/db1c8759-c7e5-4e80-9022-d19e47b0e2b0/static/macro","text":"Peacock","parameters":{"localId":"945d5b6b-d432-45da-9875-0fe4cf232cc2","extensionId":"ari:cloud:ecosystem::extension/fc909b09-b512-4c31-a844-dd855b0e6aae/db1c8759-c7e5-4e80-9022-d19e47b0e2b0/static/macro","extensionTitle":"Peacock"},"localId":"051c59cb-02cf-4ac4-9d91-bd8e0fd207e2"}}],"version":1}

Browser not supported