{"app":{"id":7,"summary":"Issue Tracker","versions":[19,20,21,52,53],"created_by":"adam186","created_at":"2023-01-31T19:43:45.757Z","votes":0,"approved":true,"apps":["supabase"],"app_type":"openapp","external_embed_url":null,"value":{"grid":[{"3":{"h":1,"w":3,"x":0,"y":0,"id":"a","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":12,"x":0,"y":0,"id":"a","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"a","data":{"id":"a","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Title","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Issues","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"top","horizontalAlignment":"left"}},{"3":{"h":12,"w":3,"x":0,"y":1,"id":"b","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":14,"w":8,"x":0,"y":1,"id":"b","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"b","data":{"id":"b","card":true,"type":"tablecomponent","actionButtons":[{"id":"b_a","card":false,"type":"buttoncomponent","recomputeIds":["bg_0"],"configuration":{"size":{"type":"static","value":"xs","fieldType":"select","optionValuesKey":"buttonSizeOptions"},"color":{"type":"static","value":"red","fieldType":"select","optionValuesKey":"buttonColorOptions"},"label":{"type":"static","value":"Delete","fieldType":"text"},"disabled":{"expr":"false","type":"eval","fieldType":"boolean"}},"componentInput":{"type":"runnable","fields":{"id":{"type":"row","value":null,"column":"id","fieldType":"string"},"auth":{"type":"static","value":"$res:u/user/my_supabase","format":"resource-supabase","fieldType":"object"}},"runnable":{"name":"Delete Issue","type":"runnableByName","inlineScript":{"path":"u/user/issue-tracker/inline-script/Inline Script 0","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth","id"],"properties":{"id":{"type":"string","default":null,"description":""},"auth":{"type":"object","format":"resource-supabase","default":null,"description":""}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.60.0/mod.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport async function main(auth: Resource<\"supabase\">, id: string) {\n  const client = createClient(auth.supabaseUrl, auth.supabaseKey);\n  return await client.from(\"issues\").delete().filter(\"id\", \"eq\", id);\n}","language":"deno"}},"fieldType":"any"}}],"configuration":{"search":{"type":"static","value":"By Component","fieldType":"select","onlyStatic":true,"optionValuesKey":"tableSearchOptions"},"pagination":{"selected":"auto","configuration":{"":{},"auto":{"pageSize":{"type":"static"}}}}},"componentInput":{"type":"runnable","value":[{"id":"794208f5-2735-428a-b4af-b071ff0a2962","status":"PENDING","summary":"Update call-to-action button color","severity":"LOW","created_at":"2023-01-25T16:13:53.244055","description":"The color should be light blue"},{"id":"eaba8d96-e387-4d2d-8494-096e4143b8fa","status":"FINISHED","summary":"Check for SQL injections","severity":"HIGH","created_at":"2023-01-25T16:13:53.244055","description":"Make sure that SQL can not be injected with calls to the backend"}],"fields":{"issues":{"type":"connected","value":null,"fieldType":"array","connection":{"path":"result","componentId":"bg_0"}}},"runnable":{"name":"Shape Data","type":"runnableByName","inlineScript":{"path":"/Shape Data","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["issues"],"properties":{"issues":{"type":"array","items":{"type":"string"},"default":null,"description":""}}},"content":"export async function main(issues: any[]) {\n  return issues?.map((issue) => ({\n    id: issue.id,\n    status: issue.status,\n    severity: issue.severity,\n    created_at: issue.created_at,\n    summary: issue.summary,\n    description: issue.description,\n  }));\n}","language":"deno"}},"fieldType":"array","subFieldType":"object","recomputeOnInputChanged":true}}},{"3":{"h":6,"w":3,"x":0,"y":42,"id":"c","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":7,"w":4,"x":8,"y":1,"id":"c","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"c","data":{"id":"c","card":true,"type":"piechartcomponent","configuration":{"theme":{"type":"static","value":"theme1","fieldType":"select","onlyStatic":true,"optionValuesKey":"chartThemeOptions"},"doughnutStyle":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"type":"runnable","value":{"data":[1,1],"labels":["PENDING","FINISHED"]},"fields":{"issues":{"type":"connected","value":null,"fieldType":"array","connection":{"path":"result","componentId":"bg_0"}}},"runnable":{"name":"Get Status Chart Data","type":"runnableByName","inlineScript":{"path":"/Get Status Chart Data","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["issues"],"properties":{"issues":{"type":"array","items":{"type":"string"},"default":null,"description":""}}},"content":"export async function main(issues: any[]) {\n  if (!issues) {\n    return {\n      labels: [],\n      data: [],\n    };\n  }\n  const values: Record<string, number> = {};\n  issues.forEach(({ status }) => {\n    if (!values[status]) {\n      values[status] = 0;\n    }\n    values[status]++;\n  });\n  return {\n    labels: Object.keys(values),\n    data: Object.values(values),\n  };\n}","language":"deno"}},"fieldType":"object","recomputeOnInputChanged":true}}},{"3":{"h":6,"w":3,"x":0,"y":36,"id":"d","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":7,"w":4,"x":8,"y":8,"id":"d","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"d","data":{"id":"d","card":true,"type":"piechartcomponent","configuration":{"theme":{"type":"static","value":"theme1","fieldType":"select","onlyStatic":true,"optionValuesKey":"chartThemeOptions"},"doughnutStyle":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true}},"componentInput":{"type":"runnable","value":{"data":[1,1],"labels":["LOW","HIGH"]},"fields":{"issues":{"type":"connected","value":null,"fieldType":"array","connection":{"path":"result","componentId":"bg_0"}}},"runnable":{"name":"Get Severity Chart Data","type":"runnableByName","inlineScript":{"path":"/Get Severity Chart Data","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["issues"],"properties":{"issues":{"type":"array","items":{"type":"string"},"default":null,"description":""}}},"content":"export async function main(issues: any[]) {\n  if (!issues) {\n    return {\n      labels: [],\n      data: [],\n    };\n  }\n  const values: Record<string, number> = {};\n  issues.forEach(({ severity }) => {\n    if (!values[severity]) {\n      values[severity] = 0;\n    }\n    values[severity]++;\n  });\n  return {\n    labels: Object.keys(values),\n    data: Object.values(values),\n  };\n}","language":"deno"}},"fieldType":"object","recomputeOnInputChanged":true}}},{"3":{"h":1,"w":3,"x":0,"y":21,"id":"e","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":16,"id":"e","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"e","data":{"id":"e","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Subtitle","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Create New Issue","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"center","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":22,"id":"f","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":17,"id":"f","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"f","data":{"id":"f","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Summary","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":23,"id":"g","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":18,"id":"g","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"g","data":{"id":"g","card":false,"type":"textinputcomponent","softWrap":true,"configuration":{"placeholder":{"type":"static","value":"Type...","fieldType":"text","onlyStatic":true},"defaultValue":{"type":"static","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":24,"id":"h","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":19,"id":"h","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"h","data":{"id":"h","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Description","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":25,"id":"i","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":20,"id":"i","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"i","data":{"id":"i","card":false,"type":"textinputcomponent","softWrap":true,"configuration":{"placeholder":{"type":"static","value":"Type...","fieldType":"text","onlyStatic":true},"defaultValue":{"type":"static","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":26,"id":"j","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":21,"id":"j","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"j","data":{"id":"j","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Created By","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":27,"id":"k","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":22,"id":"k","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"k","data":{"id":"k","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"connected","value":[{"label":"Foo","value":"foo"},{"label":"Bar","value":"bar"}],"fieldType":"array","connection":{"path":"result","componentId":"bg_2"},"subFieldType":"object"},"create":{"type":"static"},"itemKey":{"type":"static","value":"value","fieldType":"text"},"placeholder":{"type":"static"},"defaultValue":{"type":"static"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":28,"id":"l","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":23,"id":"l","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"l","data":{"id":"l","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Assigned To","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":29,"id":"m","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":24,"id":"m","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"m","data":{"id":"m","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"connected","value":[{"label":"Foo","value":"foo"},{"label":"Bar","value":"bar"}],"fieldType":"array","connection":{"path":"result","componentId":"bg_2"},"subFieldType":"object"},"itemKey":{"type":"static","value":"value","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":30,"id":"n","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":25,"id":"n","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"n","data":{"id":"n","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Status","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":31,"id":"o","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":26,"id":"o","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"o","data":{"id":"o","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"static","value":[{"label":"PENDING"},{"label":"WORKED ON"},{"label":"FINISHED"}],"fieldType":"array","subFieldType":"object"},"itemKey":{"type":"static","value":"label","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":32,"id":"p","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":27,"id":"p","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"p","data":{"id":"p","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Severity","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":33,"id":"q","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":4,"x":0,"y":28,"id":"q","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"q","data":{"id":"q","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"static","value":[{"label":"LOW"},{"label":"MEDIUM"},{"label":"HIGH"}],"fieldType":"array","subFieldType":"object"},"itemKey":{"type":"static","value":"label","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":2,"w":3,"x":0,"y":34,"id":"r","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":2,"w":4,"x":0,"y":29,"id":"r","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"r","data":{"id":"r","card":false,"type":"buttoncomponent","softWrap":true,"recomputeIds":["bg_0"],"configuration":{"size":{"type":"static","value":"md","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonSizeOptions"},"color":{"type":"static","value":"blue","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonColorOptions"},"label":{"type":"static","value":"Create Issue","fieldType":"text"},"disabled":{"expr":"false","type":"eval","fieldType":"boolean"},"afterIcon":{"type":"static"},"onSuccess":{"selected":"","configuration":{"":{}}},"beforeIcon":{"type":"static"},"fillContainer":{"type":"static"},"triggerOnAppLoad":{"type":"static"}},"componentInput":{"type":"runnable","fields":{"auth":{"type":"static","value":"$res:u/adam/supabase_issue_tracker","format":"resource-supabase","fieldType":"object"},"status":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"o"}},"summary":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"g"}},"severity":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"q"}},"created_by":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"k"}},"assigned_to":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"m"}},"description":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"i"}}},"runnable":{"name":"Create Issue","type":"runnableByName","inlineScript":{"path":"/Create Issue","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth","summary","description","created_by","assigned_to","status","severity"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null},"status":{"type":"string","default":null},"summary":{"type":"string","default":null},"severity":{"type":"string","default":null},"created_by":{"type":"string","default":null},"assigned_to":{"type":"string","default":null},"description":{"type":"string","default":null}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.60.0/mod.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport async function main(\n  auth: Resource<\"supabase\">,\n  summary: string,\n  description: string,\n  created_by: string,\n  assigned_to: string,\n  status: string,\n  severity: string,\n) {\n  const client = createClient(auth.url, auth.key);\n  return await client.from(\"issues\").insert({\n    summary,\n    description,\n    status,\n    severity,\n    created_by,\n    assigned_to,\n  });\n}","language":"deno"}},"fieldType":"any","recomputeOnInputChanged":true},"verticalAlignment":"top","horizontalAlignment":"right"}},{"3":{"h":1,"w":3,"x":0,"y":13,"id":"s","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":7,"x":5,"y":16,"id":"s","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"s","data":{"id":"s","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Subtitle","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Update Issue","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":14,"id":"t","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":7,"x":5,"y":17,"id":"t","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"t","data":{"id":"t","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Body","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"color: #6e6e6e;","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"${b?.selectedRow?.summary || '(Select a row in the table)'}","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"top","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":15,"id":"u","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":2,"x":5,"y":18,"id":"u","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"u","data":{"id":"u","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Status","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":16,"id":"w","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":2,"x":5,"y":19,"id":"w","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"w","data":{"id":"w","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"static","value":[{"label":"PENDING"},{"label":"WORKED ON"},{"label":"FINISHED"}],"fieldType":"array","subFieldType":"object"},"itemKey":{"type":"static","value":"label","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":1,"w":3,"x":0,"y":17,"id":"x","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":2,"x":7,"y":18,"id":"x","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"x","data":{"id":"x","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Label","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Severity","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":1,"w":3,"x":0,"y":18,"id":"y","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":2,"x":7,"y":19,"id":"y","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"y","data":{"id":"y","card":false,"type":"selectcomponent","softWrap":true,"configuration":{"items":{"type":"static","value":[{"label":"LOW"},{"label":"MEDIUM"},{"label":"HIGH"}],"fieldType":"array","subFieldType":"object"},"itemKey":{"type":"static","value":"label","fieldType":"text"}},"verticalAlignment":"center"}},{"3":{"h":2,"w":1,"x":2,"y":19,"id":"z","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":2,"w":3,"x":9,"y":18,"id":"z","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"z","data":{"id":"z","card":false,"type":"buttoncomponent","softWrap":true,"recomputeIds":["bg_0"],"configuration":{"size":{"type":"static","value":"xs","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonSizeOptions"},"color":{"type":"static","value":"blue","fieldType":"select","onlyStatic":true,"optionValuesKey":"buttonColorOptions"},"label":{"type":"static","value":"Update Issue","fieldType":"text"},"disabled":{"expr":"false","type":"eval","fieldType":"boolean"},"afterIcon":{"type":"static"},"onSuccess":{"selected":"","configuration":{"":{}}},"beforeIcon":{"type":"static"},"fillContainer":{"type":"static"},"triggerOnAppLoad":{"type":"static"}},"componentInput":{"type":"runnable","fields":{"auth":{"type":"static","value":"$res:u/adam/supabase_issue_tracker","format":"resource-supabase","fieldType":"object"},"issue":{"type":"connected","value":null,"fieldType":"object","connection":{"path":"selectedRow","componentId":"b"}},"status":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"w"}},"severity":{"type":"connected","value":null,"fieldType":"string","connection":{"path":"result","componentId":"y"}}},"runnable":{"name":"Update Issue","type":"runnableByName","inlineScript":{"path":"/Update Issue","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth","issue"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null},"issue":{"type":"object","default":null},"status":{"type":"string","default":null},"severity":{"type":"string","default":null}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.60.0/mod.ts\"\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport async function main(\n  auth: Resource<'supabase'>,\n  issue: any,\n  status?: string,\n  severity?: string\n) {\n  if(!(issue && (status || severity))) {\n    return 'Make sure that an issue is selected in the table'\n  }\n  const client = createClient(auth.url, auth.key);\n  await client.from(\"issues\")\n    .update({\n    ...issue,\n    status: status || issue.status,\n    severity: severity || issue.severity,\n  }).filter('id', 'eq', issue.id);\n  return '';\n}","language":"deno"}},"fieldType":"any","recomputeOnInputChanged":true},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":2,"w":2,"x":0,"y":49,"id":"aa","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":6,"x":5,"y":22,"id":"aa","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"aa","data":{"id":"aa","card":false,"type":"textcomponent","softWrap":true,"configuration":{"style":{"type":"static","value":"Subtitle","fieldType":"select","onlyStatic":true,"optionValuesKey":"textStyleOptions"},"copyButton":{"type":"static","value":false,"fieldType":"boolean","onlyStatic":true},"extraStyle":{"type":"static","value":"","tooltip":"CSS rules like \"color: blue;\"","fieldType":"text"}},"componentInput":{"eval":"Number of Issues Created in the Past ${ac.result || 30} Days","type":"template","value":"Hello ${ctx.username}","fieldType":"template"},"verticalAlignment":"bottom","horizontalAlignment":"left"}},{"3":{"h":8,"w":3,"x":0,"y":51,"id":"ab","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":8,"w":7,"x":5,"y":23,"id":"ab","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"ab","data":{"id":"ab","card":true,"type":"barchartcomponent","configuration":{"line":{"type":"static","value":true,"fieldType":"boolean","onlyStatic":true},"theme":{"type":"static","value":"theme1","fieldType":"select","onlyStatic":true,"optionValuesKey":"chartThemeOptions"}},"componentInput":{"type":"runnable","value":{"data":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"labels":["2023-03-14","2023-03-15","2023-03-16","2023-03-17","2023-03-18","2023-03-19","2023-03-20","2023-03-21","2023-03-22","2023-03-23","2023-03-24","2023-03-25","2023-03-26","2023-03-27","2023-03-28","2023-03-29","2023-03-30","2023-03-31","2023-04-01","2023-04-02","2023-04-03","2023-04-04","2023-04-05","2023-04-06","2023-04-07","2023-04-08","2023-04-09","2023-04-10","2023-04-11","2023-04-12"]},"fields":{"days":{"type":"connected","value":null,"fieldType":"number","connection":{"path":"result","componentId":"ac"}},"issues":{"type":"connected","value":null,"fieldType":"array","connection":{"path":"result","componentId":"bg_0"}}},"runnable":{"name":"Last Issues Chart Data","type":"runnableByName","inlineScript":{"path":"/Last Issues Chart Data","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["issues"],"properties":{"days":{"type":"number","default":30,"description":""},"issues":{"type":"array","items":{"type":"string"},"default":null,"description":""}}},"content":"export async function main(\n  issues: { created_at: string }[],\n  days: number = 30\n) {\n  if (!issues?.length) {\n    return { data: [], labels: [] };\n  }\n  const dates = [...Array(days)].map((_, i) => {\n    const d = new Date();\n    d.setDate(d.getDate() - i);\n    return d.toISOString().split(\"T\")[0];\n  }).reverse();\n  const issueNumbers = dates.map((date) => {\n    return issues.filter(({ created_at }) => created_at.startsWith(date)).length;\n  });\n  return {\n    data: issueNumbers,\n    labels: dates,\n  };\n}","language":"deno"}},"fieldType":"object","recomputeOnInputChanged":true}}},{"3":{"h":1,"w":1,"x":2,"y":50,"id":"ac","max":{"h":100,"w":3},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"12":{"h":1,"w":1,"x":11,"y":22,"id":"ac","max":{"h":100,"w":12},"min":{"h":1,"w":1},"fixed":true,"draggable":true,"resizable":true,"customDragger":false,"customResizer":false},"id":"ac","data":{"id":"ac","card":false,"type":"numberinputcomponent","softWrap":true,"configuration":{"max":{"type":"static"},"min":{"type":"static"},"step":{"type":"static"},"placeholder":{"type":"static","value":"Days","fieldType":"text","onlyStatic":true},"defaultValue":{"type":"static","value":30,"fieldType":"number"}},"verticalAlignment":"center"}}],"fullscreen":false,"hiddenInlineScripts":[{"name":"Load Issues","fields":{"auth":{"type":"static","value":"$res:u/adam/supabase_issue_tracker","format":"resource-supabase","fieldType":"object"}},"autoRefresh":true,"inlineScript":{"path":"/Load Issues","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.86.0/mod.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport async function main(auth: Resource<\"supabase\">) {\n  const client = createClient(auth.url, auth.key);\n  const { data, error } = await client.from(\"issues\").select();\n  console.log({ data, error })\n  return data;\n}","language":"deno"},"noBackendValue":[{"id":"794208f5-2735-428a-b4af-b071ff0a2962","status":"PENDING","summary":"Update call-to-action button color","severity":"LOW","created_at":"2023-01-25T16:13:53.244055","created_by":"ffb75095-4c17-4470-9b8d-d030737915b5","assigned_to":"81bd5af9-6508-40bc-b5d8-7402b4c61830","description":"The color should be light blue"},{"id":"eaba8d96-e387-4d2d-8494-096e4143b8fa","status":"FINISHED","summary":"Check for SQL injections","severity":"HIGH","created_at":"2023-01-25T16:13:53.244055","created_by":"1fb83481-661f-4c94-addf-1350c9380e20","assigned_to":"92393eeb-5297-400d-8d3b-ba42884a6eef","description":"Make sure that SQL can not be injected with calls to the backend"}],"recomputeOnInputChanged":true},{"name":"Load Users","fields":{"auth":{"type":"static","value":"$res:u/adam/supabase_issue_tracker","format":"resource-supabase","fieldType":"object"}},"autoRefresh":true,"inlineScript":{"path":"/Load Users","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["auth"],"properties":{"auth":{"type":"object","format":"resource-supabase","default":null}}},"content":"import { Resource } from \"https://deno.land/x/windmill@v1.86.0/mod.ts\";\nimport { createClient } from \"https://esm.sh/@supabase/supabase-js@2\";\n\nexport async function main(auth: Resource<\"supabase\">) {\n  const client = createClient(auth.url, auth.key);\n  const result = await client.from(\"users\").select();\n  return result.data;\n}","language":"deno"},"noBackendValue":[{"id":"83411819-4a45-49f4-8769-f7bf5cbb26fe","name":"Theresa Hurley","roles":["MANAGER"]},{"id":"1fb83481-661f-4c94-addf-1350c9380e20","name":"Taliyah Gardner","roles":["MANAGER"]},{"id":"ae26fe2f-ca75-43df-8be8-d5d883ee5268","name":"Ezekiel Ortega","roles":["MANAGER"]},{"id":"ca9ad7a0-bea6-4f66-a0e0-7a62a9f68923","name":"Gia Keller","roles":["MANAGER"]},{"id":"81bd5af9-6508-40bc-b5d8-7402b4c61830","name":"Jefferson Pratt","roles":["DEVELOPER"]},{"id":"d86a7649-2a1c-4f0f-93f6-6f44a473c4dc","name":"Carlo Flores","roles":["DEVELOPER"]},{"id":"92393eeb-5297-400d-8d3b-ba42884a6eef","name":"Arielle Shepherd","roles":["DEVELOPER"]},{"id":"ffb75095-4c17-4470-9b8d-d030737915b5","name":"Caitlin Lucas","roles":["DEVELOPER"]}],"recomputeOnInputChanged":true},{"name":"Get User Selection List","fields":{"users":{"type":"connected","value":null,"fieldType":"array","connection":{"path":"result","componentId":"bg_1"}}},"inlineScript":{"path":"/Get User Selection List","schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":[],"properties":{"users":{"type":"array","items":{"type":"string"},"default":null,"description":""}}},"content":"export async function main(users: undefined | any[]) {\n  if (!Array.isArray(users)) return [];\n  return users.map(({ id, name }) => ({ value: id, label: name }));\n}","language":"deno"},"noBackendValue":[{"label":"Theresa Hurley","value":"83411819-4a45-49f4-8769-f7bf5cbb26fe"},{"label":"Taliyah Gardner","value":"1fb83481-661f-4c94-addf-1350c9380e20"},{"label":"Ezekiel Ortega","value":"ae26fe2f-ca75-43df-8be8-d5d883ee5268"},{"label":"Gia Keller","value":"ca9ad7a0-bea6-4f66-a0e0-7a62a9f68923"},{"label":"Jefferson Pratt","value":"81bd5af9-6508-40bc-b5d8-7402b4c61830"},{"label":"Carlo Flores","value":"d86a7649-2a1c-4f0f-93f6-6f44a473c4dc"},{"label":"Arielle Shepherd","value":"92393eeb-5297-400d-8d3b-ba42884a6eef"},{"label":"Caitlin Lucas","value":"ffb75095-4c17-4470-9b8d-d030737915b5"}],"recomputeOnInputChanged":true}],"unusedInlineScripts":[]},"description":"Read the blog post about how this app was created here: [**Create an Issue Tracker in 15 minutes**](https://docs.windmill.dev/blog/create-issue-tracker-in-15-minutes)","vcreated_at":"2023-04-12T09:45:34.039Z","vcreated_by":"adam186","comments":[]}}