{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Configuring what attributes/columns can be edited requires the use of ","type":"text"},{"text":"parameter ","type":"text","marks":[{"type":"code"}]},{"text":"elements in an ","type":"text"},{"text":"edit:config","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"}]},{"type":"paragraph","content":[{"text":"A parameter represents a column of an entity.","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"custom.edit"}},"macroMetadata":{"macroId":{"value":"f0752a3c650c2ee28f680fdab106bb2b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"4b7fb84e-b543-4606-856d-5dd5b3a55ab8"}},{"text":"In the following ","type":"text"},{"text":"custom.edit","type":"text","marks":[{"type":"code"}]},{"text":" config a single parameter (","type":"text"},{"text":"id=\"description\"","type":"text","marks":[{"type":"code"}]},{"text":") is added which only allows for the display and editing of the ","type":"text"},{"text":"description ","type":"text","marks":[{"type":"strong"}]},{"text":"column in the ","type":"text"},{"text":"graffiti","type":"text","marks":[{"type":"code"}]},{"text":"entity.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n\n\n \n graffiti\n Grafitti (custom)\n true\n Report graffiti for removal\n \n Description\n textarea\n description\n false \n \n \n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Saving the ","type":"text"},{"text":"custom.edit","type":"text","marks":[{"type":"code"}]},{"text":" configuration, reloading the client and selecting the ","type":"text"},{"text":"Grafitti (custom)","type":"text","marks":[{"type":"strong"}]},{"text":" configuration from the ","type":"text"},{"text":"Edit","type":"text","marks":[{"type":"strong"}]},{"text":" tab’s pulldown will display the following.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":281,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":281,"id":"6de3e984-760c-4f90-85b7-bbb6d04d640c","collection":"contentId-2698085721","type":"file","height":319}},{"type":"caption","content":[{"text":"Custom Edit","type":"text"}]}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" value can be case sensitive depending on the underlying database. For example, a column called \"DESCRIPTION\" may not be the same as \"description\". For PostgreSQL graffiti table’s columns are all defined in lower case so all ","type":"text"},{"text":"","type":"text","marks":[{"type":"code"}]},{"text":"values should be in lowercase.","type":"text"}]},{"type":"paragraph","content":[{"text":"What happens to all the columns in the table that are not referenced by parameters in the edit configuration (no value is created by Weave for them)?","type":"text"}]},{"type":"paragraph","content":[{"text":"As long as an underlying column is declared as allowing ","type":"text"},{"text":"NULL","type":"text","marks":[{"type":"strong"}]},{"text":" values, any create action will succeed. If a column is declared ","type":"text"},{"text":"NOT NULL","type":"text","marks":[{"type":"strong"}]},{"text":" and does ","type":"text"},{"text":"not","type":"text","marks":[{"type":"strong"}]},{"text":" have an associated parameter for which a value is defined, the create action will fail (because Weave will attempt to write a NULL value to that column).","type":"text"}]},{"type":"paragraph","content":[{"text":"Though the ","type":"text"},{"text":"id","type":"text","marks":[{"type":"strong"}]},{"text":" column (","type":"text"},{"text":"id serial not null primary key","type":"text","marks":[{"type":"strong"}]},{"text":") is not referenced or displayed by the ","type":"text"},{"text":"custom.edit","type":"text","marks":[{"type":"code"}]},{"text":"edit configuration, any create action will succeed because the database will automatically supply the value from the sequence associated with the column.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":760.0,"localId":"b69398d5-193a-49a6-af0d-1004acb9b201"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"<< Previous","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/WUG/pages/2698085550"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","marks":[{"type":"alignment","attrs":{"align":"end"}}],"content":[{"text":"Next >>","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/WUG/pages/2698085887"}}]}]}]}]}]}],"version":1}

Browser not supported