{"type":"doc","content":[{"type":"paragraph"},{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"section","parameters":{"macroParams":{"_parentId":{"value":"164496254"}},"macroMetadata":{"macroId":{"value":"26f6b087-dd57-4b97-9518-77aecfe95266"},"schemaVersion":{"value":"1"},"title":"Section"}}},"content":[{"type":"paragraph"},{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"legacy-content","text":"","parameters":{"cxhtml":"35%

falseTable of Contents

10px

This feature is only available in Profound UI Version 6 Fix Pack 2.0 and later.

","nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"column","parameters":{"macroParams":{"_parentId":{"value":"164496254"},"width":{"value":"65%"}},"macroMetadata":{"macroId":{"value":"f40db674-a3a0-4708-84ff-4643da643131"},"schemaVersion":{"value":"1"},"title":"Column"}}},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"This feature is only available in Profound UI Version 6 Fix Pack 2.0 and later.","type":"text"}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}],"version":1},"adf":"{\"type\":\"doc\",\"content\":[{\"type\":\"bodiedExtension\",\"attrs\":{\"extensionType\":\"com.atlassian.confluence.macro.core\",\"extensionKey\":\"column\",\"parameters\":{\"macroParams\":{\"_parentId\":{\"value\":\"164496254\"},\"width\":{\"value\":\"65%\"}},\"macroMetadata\":{\"macroId\":{\"value\":\"f40db674-a3a0-4708-84ff-4643da643131\"},\"schemaVersion\":{\"value\":\"1\"},\"title\":\"Column\"}}},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"hardBreak\"}]},{\"type\":\"panel\",\"attrs\":{\"panelType\":\"info\"},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"text\":\"This feature is only available in Profound UI Version 6 Fix Pack 2.0 and later.\",\"type\":\"text\"}]}]},{\"type\":\"paragraph\",\"content\":[{\"type\":\"hardBreak\"}]}]}],\"version\":1}","reason":"A column macro in a rich body macro can't be created or edited in the new editor."}}},{"type":"paragraph"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"This feature allows you to associate pre-configured sets of widget properties with database fields and store them for later use. Database fields can then be dragged onto the design canvas, and the associated widget will be created with the pre-configured properties. This allows you to develop database-driven applications more rapidly, since you don't have to continually set up widget properties for commonly used database fields.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Database Connectivity","type":"text"}]},{"type":"paragraph","content":[{"text":"The Profound UI Visual Designer automatically connects to the local DB2 for IBM i database. The list of schemas (IBM i libraries) that will be available to work with is set using the ","type":"text"},{"text":"Library List ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#008080"}}]},{"text":"button in the ribbon:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":16642,"__fileMimeType":"image/png","width":562,"id":"15f22796-8a42-4d94-9520-467f828d0bb5","collection":"contentId-164496254","type":"file","__fileName":"image2019-3-8 12:3:52.png","height":108}}]},{"type":"paragraph","content":[{"text":"The Profound.js version of the Designer uses the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"database driver ","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"databaseConnections","versionAtSave":"45"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164498952"}},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"specified in the instance configuration file: ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The \"jsonDB\" driver is not supported.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When using the \"IBMi\" driver, the list of schemas (IBM i libraries) that will be available to work with is set using the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"pathlist","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"linkType":"page","contentTitle":"pathlist","versionAtSave":"27"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164495828"}},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" setting in the instance configuration file.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For other database drivers, any schemas the user has permission to will be available to work with.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Browsing the Database","type":"text"}]},{"type":"paragraph","content":[{"text":"The Database tab in the Designer's left side panel has a tree that allows you to browse through the configured database's schemas, tables within each schema, and columns within each table.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":14869,"__fileMimeType":"image/png","width":313,"id":"1b3359c8-8308-41fd-ac58-a54496740928","collection":"contentId-164496254","type":"file","__fileName":"image2019-3-8 13:24:22.png","height":219}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Storing Widget Properties","type":"text"}]},{"type":"paragraph","content":[{"text":"To store widget properties for a database field, right-click on the field in the tree and select ","type":"text"},{"text":"Field Properties ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#008080"}},{"type":"strong"}]},{"text":"to display the Field Properties dialog.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"48a39bc1-f240-45b5-adcf-be9d577be3a2","collection":"contentId-164496254","height":""}}},{"text":" ","type":"text"}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":" ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"","id":"59a3b893-06a6-4e1c-9ea3-18ddc0d3c6f2","collection":"contentId-164496254","height":""}}}]},{"type":"paragraph","content":[{"text":"The Field Properties dialog can store two sets of properties – one for when the database field is output, and one for input. Example scenario: The DB table shown above stores product categories. When the category id field (CATID) is used for input, it should use a drop down box widget that shows the category name (CNAME), but returns CATID to the application.The items in the drop down box should be sorted by category name. To accomplish that, the input properties could be set like this:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":20293,"__fileMimeType":"image/png","width":399,"id":"bf6193bb-44a2-4e79-add4-ba433b3c9b33","collection":"contentId-164496254","type":"file","__fileName":"image2019-3-8 16:32:54.png","height":413}}]},{"type":"paragraph","content":[{"text":"With this set up, the field will be created as a drop down box with the appropriate settings when it's dragged from the Database tree to the Design canvas","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Adding Fields from Database Tree to Design Canvas","type":"text"}]},{"type":"paragraph","content":[{"text":"To add a field from the Database tree to the Design canvas, use the radio buttons in the Database tab toolbar to select the desired preset, and drag the field onto the Design canvas.The widget will be set up with the pre-configured properties.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start"},"content":[{"type":"media","attrs":{"__fileSize":35997,"__fileMimeType":"image/png","width":586,"id":"9eab002b-632f-4dc2-b9a5-890cf78d8e61","collection":"contentId-164496254","type":"file","__fileName":"image2019-3-8 16:42:44.png","height":220}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Default Presets","type":"text"}]},{"type":"paragraph","content":[{"text":"Default presets will be used for fields that have no saved properties. The default presets can be configured with the ","type":"text"},{"text":"default input properties","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Default Input Properties","versionAtSave":"7"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164496001"}}]},{"text":" and ","type":"text"},{"text":"default output properties","type":"text","marks":[{"type":"link","attrs":{"__confluenceMetadata":{"isRenamedTitle":true,"linkType":"page","contentTitle":"Default Output Properties","versionAtSave":"4"},"href":"https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/pages/164498015"}}]},{"text":" configuration options.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Storage of Field Properties","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Profound UI Designer stores database field properties in DB2 for i table DATABASE_REPOSITORY (system name PUIDBREPO) in the Profound UI product installation library.","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Profound.js Designer stores database field propertise in file 'database_properties.json' in the Profound.js installation directory.","type":"text"}]}]}]}],"version":1}