{"type":"doc","content":[{"type":"heading","attrs":{"level":3},"content":[{"text":"JQL Syntax","type":"text"}]},{"type":"paragraph","content":[{"text":"lookup(","type":"text"},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}}]},{"text":", ","type":"text"},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}}]},{"text":", ","type":"text"},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]},{"text":", ","type":"text"},{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}}]},{"text":", )","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"Parameter","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"

","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"The lookup table name","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"The column name to perform the lookup","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"The value used to perform the lookup","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"The column name to return if there is any matching row","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[667.0]},"content":[{"type":"paragraph","content":[{"text":"The mode for returning values","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"first","type":"text","marks":[{"type":"strong"}]},{"text":" will return the first matching value","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"last","type":"text","marks":[{"type":"strong"}]},{"text":" will return the last matching value","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"all","type":"text","marks":[{"type":"strong"}]},{"text":" will return all the matching value","type":"text"}]}]}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Supported Operators","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"IN","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"NOT IN","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"=","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"!=","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"<","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":">","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"<=","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":">=","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"IS","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"IS NOT","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"WAS","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"WAS IN","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"WAS NOT","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"WAS NOT IN","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"text":"CHANGED","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[45.33]},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"center"}}],"content":[{"type":"emoji","attrs":{"id":"atlassian-cross_mark","text":":cross_mark:","shortName":":cross_mark:"}}]}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"An Example","type":"text"}]},{"type":"paragraph","content":[{"text":"Using the example from ","type":"text"},{"type":"inlineCard","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Support multiple categories for Jira Project","versionAtSave":"6"},"url":"https://akeles.jira.com/wiki/spaces/LOOKUP/pages/1781825668"}},{"text":", if there is a Lookup Table named ","type":"text"},{"text":"Project Category Table ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}},{"type":"strong"}]},{"text":"with 3 columns (","type":"text"},{"text":"Project Name","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0747a6"}},{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Project Key","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Category","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]},{"text":")","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"#b3d4ff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Project Name","type":"text","marks":[{"type":"textColor","attrs":{"color":"#0747a6"}},{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#abf5d1","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"Project Key","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"#fff0b3","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"Category","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph","content":[{"text":"Remarks","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Customer Service project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"CS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"BUSINESS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" project CS belongs to Business category","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Customer Service project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"CS","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"CUSTOMER","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Development project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"DEV","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"BUSINESS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" project DEV belongs to Business category","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Framework Development project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"FRAM","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"CUSTOMER","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Framework Development project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"FRAM","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"INTERNAL","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"QA project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"QA","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"BUSINESS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" project QA belongs to Business category","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"background":"#deebff","rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"QA project","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#e3fcef","rowspan":1,"colwidth":[97.0]},"content":[{"type":"paragraph","content":[{"text":"QA","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#fffae6","rowspan":1,"colwidth":[84.0]},"content":[{"type":"paragraph","content":[{"text":"INTERNAL","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[379.0]},"content":[{"type":"paragraph"}]}]}]},{"type":"paragraph","content":[{"text":"The lookup JQL function ","type":"text"}]},{"type":"codeBlock","content":[{"text":"project in lookup(\"Project Category Table\", \"Category\", \"Business\", \"Project Key\", \"all\")","type":"text"}]},{"type":"paragraph","content":[{"text":"will be translated to ","type":"text"}]},{"type":"codeBlock","content":[{"text":"project in (CS, DEV, QA)","type":"text"}]},{"type":"paragraph","content":[{"text":"For reference,","type":"text"}]},{"type":"table","attrs":{"layout":"default"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"Parameter","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"Value in Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"

","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"The lookup table name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"Project Category Table","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"The column name to perform the lookup","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"Category","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff991f"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"The value used to perform the lookup","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"BUSINESS","type":"text","marks":[{"type":"textColor","attrs":{"color":"#6554c0"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"The column name to return if there is any matching row","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"Project Key","type":"text","marks":[{"type":"textColor","attrs":{"color":"#006644"}},{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[244.0]},"content":[{"type":"paragraph","content":[{"text":"The mode for returning values","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"first","type":"text","marks":[{"type":"strong"}]},{"text":" will return the first matching value","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"last","type":"text","marks":[{"type":"strong"}]},{"text":" will return the last matching value","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"all","type":"text","marks":[{"type":"strong"}]},{"text":" will return all the matching values in the table","type":"text"}]}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[384.0]},"content":[{"type":"paragraph","content":[{"text":"all","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"If you use","type":"text"}]},{"type":"codeBlock","content":[{"text":"project in lookup(\"Project Category Table\", \"Category\", \"Business\", \"Project Key\", \"first\")","type":"text"}]},{"type":"paragraph","content":[{"text":"it will be translated to ","type":"text"}]},{"type":"codeBlock","content":[{"text":"project in (CS)","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Learn More ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}},{"type":"strong"}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use lookup() function to ","type":"text"},{"type":"inlineCard","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Support multiple categories for Jira Project","versionAtSave":"6"},"url":"https://akeles.jira.com/wiki/spaces/LOOKUP/pages/1781825668"}},{"text":" ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use lookup() function to ","type":"text"},{"type":"inlineCard","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Support mapping between Product Owner and Jira Project","versionAtSave":"2"},"url":"https://akeles.jira.com/wiki/spaces/LOOKUP/pages/2371977229"}},{"text":" ","type":"text"}]}]}]}],"version":1}