{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"datasourcedataconnection","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"b35cad0c-70cf-4395-9213-948971a56472"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"datasource","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"ref ","type":"text"},{"text":"urn:com.cohga.server.datasource.jdbc#1.0:datasource","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/weavedocs1/pages/3248838"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"reference to the data source that this data definition should use to generate its data","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"table","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"The name of the table that provides the data","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"key","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"If this data definition is generating data relating to an entity then this is the column name that contains the entities id","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"prefix","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"The prefix value will be inserted into the generated SQL statement immediately after the SELECT, for example DISTINCT","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"trim","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"If ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" the generated SQL will ensure that the id's are compared against a trimmed version of the id stored in the database.","type":"text"},{"type":"hardBreak"},{"text":"This helps with systems like Pathway, where some tables store padded id's","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"keytable","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"An optional database table that will be used to store entity keys temporarily when performing the required SQL to generate the data for this data connection. If this option isn't set then the SQL used to generate the data will create the data in batches, which can cause issues with sorting, optionally you can create a simple two column table, with an index on the userid column, and set this value to the name of this table, then Weave will insert the entity id's into this table temporarily and use this table in a SQL join when generating the data. This will resolve any sorting issues, and is more important if caching is also disabled for the data connection.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"keycolumn","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"The column in ","type":"text"},{"text":"keytable","type":"text","marks":[{"type":"code"}]},{"text":" that contains the entity id, default is ","type":"text"},{"text":"key","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[101.0]},"content":[{"type":"paragraph","content":[{"text":"usercolumn","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[436.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[827.0]},"content":[{"type":"paragraph","content":[{"text":"The column in ","type":"text"},{"text":"keytable","type":"text","marks":[{"type":"code"}]},{"text":" that contains the userid, default is ","type":"text"},{"text":"userid","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"699ffbbc-0d26-4b1f-988a-93afdee16a14"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"Cardinality","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"parameter","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:parameter","type":"text","marks":[{"type":"link","attrs":{"href":"#parameter"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"cache","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.cache#1.0:cache","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/weavedocs1/pages/3248854"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..1","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"from","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:from","type":"text","marks":[{"type":"link","attrs":{"href":"#from"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"where","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:where","type":"text","marks":[{"type":"link","attrs":{"href":"#where"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"sort","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:sort","type":"text","marks":[{"type":"link","attrs":{"href":"#sort"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"join","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:join","type":"text","marks":[{"type":"link","attrs":{"href":"#join"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[114.0]},"content":[{"type":"paragraph","content":[{"text":"options","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[529.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:options","type":"text","marks":[{"type":"link","attrs":{"href":"#options"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[117.0]},"content":[{"type":"paragraph","content":[{"text":"0..1","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Notes","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The cache settings are only used for data source data connections that have a key specified, since it's the key that's used as the cache index","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If no ","type":"text"},{"text":"cache","type":"text","marks":[{"type":"code"}]},{"text":" tag is specified then the data will still be cached, but it will use the default cache configuration, to disable caching you need to set ","type":"text"},{"text":"disable","type":"text","marks":[{"type":"code"}]},{"text":" to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" inside the cache definition (see example below).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"You can completely disable the caching (for all data definitions that don't have cache setting explicitly set) by setting the startup parameter ","type":"text"},{"text":"weave.cache.default","type":"text","marks":[{"type":"code"}]},{"text":" to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" (in startup.cmd, startup.sh and/or weave-service.conf).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If no parameters are specified then the server will generate parameters based on the columns in the underlying table, in this case you should also ","type":"text"},{"text":"not","type":"text","marks":[{"type":"strong"}]},{"text":" include any ","type":"text"},{"text":"from","type":"text","marks":[{"type":"code"}]},{"text":" tags since joins are not currently supported, ","type":"text"},{"text":"where","type":"text","marks":[{"type":"code"}]},{"text":" tags are ok though.","type":"text"}]}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"parameter"}},"macroMetadata":{"macroId":{"value":"c9215961-420a-440a-90f0-0f20b90aac99"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"be1cce4c-f53c-4a5e-a6b5-ed558ed5976c"}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"parameter","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"3d2c6d1b-3a5f-4ce6-82fd-10b2a17ea0d8"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"Default","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"The name of the column within the table that this parameter references (can be an sql function also)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"'string', 'numeric', 'date' or 'url'","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"'string'","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"An indicator of how the data should be displayed on the client","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"lowercase value of column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"A unique identifier for the parameter","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"label","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"\"pretty\" value of column","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"A user displayable label for the column","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"text","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"Only when type is 'url'. Specifies text to be displayed to the user instead of the actual url contents","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"textcolumn","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"Only when type is 'url'. Specifies the column that contains text to be displayed to the user instead of the actual url contents","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"format","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[233.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[59.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[236.0]},"content":[{"type":"paragraph","content":[{"text":"\"date\", \"time\" or \"datetime\"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[828.0]},"content":[{"type":"paragraph","content":[{"text":"When the ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" attribute is ","type":"text"},{"text":"date","type":"text","marks":[{"type":"code"}]},{"text":" this value can force the value to be formatted as as specific date type.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"0f576aa8-2a8f-45c7-8d37-bd1f83a41165"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[547.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"Cardinality","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.0]},"content":[{"type":"paragraph","content":[{"text":"from","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[547.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:from","type":"text","marks":[{"type":"link","attrs":{"href":"#DatasourceDataConnection-from"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[81.0]},"content":[{"type":"paragraph","content":[{"text":"where","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[547.0]},"content":[{"type":"paragraph","content":[{"text":"urn:com.cohga.server.data.database#1.0:where","type":"text","marks":[{"type":"link","attrs":{"href":"#DatasourceDataConnection-where"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[132.0]},"content":[{"type":"paragraph","content":[{"text":"0..n","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Notes","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If no ","type":"text"},{"text":"label","type":"text","marks":[{"type":"code"}]},{"text":" is specified then it will be generated by formatting the ","type":"text"},{"text":"name","type":"text","marks":[{"type":"code"}]},{"text":", unless no ","type":"text"},{"text":"name","type":"text","marks":[{"type":"code"}]},{"text":" is supplied, then it will be generated by formatting the ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Formatting involves converting any _'s to spaces, converting the first letter and any letter after a space to upper case and converting every other letter to lower case, e.g. \"BOMB_DISPOSAL_METHOD\" becomes \"Bomb Disposal Method\"","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Only one of ","type":"text"},{"text":"text","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"textcolumn","type":"text","marks":[{"type":"code"}]},{"text":" should be specified when type is 'url'","type":"text"}]}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"from"}},"macroMetadata":{"macroId":{"value":"b382fa94-f877-4665-ab70-6d0bc6ecc522"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"901796b6-944e-44ff-b313-e870accaf976"}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"from","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"f61debad-5ea3-4b11-9e56-54092ef298ca"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[73.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[69.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[518.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[73.0]},"content":[{"type":"paragraph","content":[{"text":"table","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[69.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[100.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[518.0]},"content":[{"type":"paragraph","content":[{"text":"An additional table to include in the generated SQL","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"where"}},"macroMetadata":{"macroId":{"value":"c1c442eb-2340-488e-a195-cf94e2d9894a"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"eab5b1ce-2035-4fae-9e73-3e6caafb537c"}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"where","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"582dea2d-955c-434c-936d-5bf1ef9b5939"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[119.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[102.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1145.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[119.0]},"content":[{"type":"paragraph","content":[{"text":"clause","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[102.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1145.0]},"content":[{"type":"paragraph","content":[{"text":"An additional clause to include in the generated SQL","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[119.0]},"content":[{"type":"paragraph","content":[{"text":"uppercase","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[93.0]},"content":[{"type":"paragraph","content":[{"text":"boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[102.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1145.0]},"content":[{"type":"paragraph","content":[{"text":"If the clause uses parameter substitution should the value be converted to upper-case before being substituted","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"sort","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"8d8cc119-8dfb-4434-8e59-131b4050cc93"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[147.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[128.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[397.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[147.0]},"content":[{"type":"paragraph","content":[{"text":"parameter","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[128.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[397.0]},"content":[{"type":"paragraph","content":[{"text":"Name of parameter to sort on","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[147.0]},"content":[{"type":"paragraph","content":[{"text":"direction","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[88.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[128.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[397.0]},"content":[{"type":"paragraph","content":[{"text":"ASC or DESC, ASC is default","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"join","type":"text"}]},{"type":"paragraph","content":[{"text":"Only available in 2.5.11 or later","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"properties","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"91238c39-5d6a-4eb2-a1e1-b15d08daee98"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[82.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[71.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[504.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[82.0]},"content":[{"type":"paragraph","content":[{"text":"table","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[71.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[504.0]},"content":[{"type":"paragraph","content":[{"text":"The table to join to","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[82.0]},"content":[{"type":"paragraph","content":[{"text":"on","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[71.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[504.0]},"content":[{"type":"paragraph","content":[{"text":"The clause used to join the table","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[82.0]},"content":[{"type":"paragraph","content":[{"text":"type","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[71.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[504.0]},"content":[{"type":"paragraph","content":[{"text":"The type of join to use","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[82.0]},"content":[{"type":"paragraph","content":[{"text":"clause","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[71.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[103.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[504.0]},"content":[{"type":"paragraph","content":[{"text":"Additional clauses that can be added to the join","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"options","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1800.0,"localId":"e0259ceb-e2bf-4355-874f-8ab7fca09d8c"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"rpad","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"number","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"If the key value needs to be padded with spaces on the right to make it match the database, this specifies the total length of the final padded value.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example rpad = 10 would change a key value from \"value\" to \"value.....\" (where each . is a space).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"lpad","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"number","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"If the key value needs to be padded with spaces on the left to make it match the database, this specifies the total length of the final padded value.","type":"text"}]},{"type":"paragraph","content":[{"text":"For example lpad = 10 would change a key value from \"value\" to \".....value\" (where each . is a space).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"trim","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"If a key value needs to be trimmed of spaces before being used setting this to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":" will cause that to be done.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"maxrows","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"number","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"Limit the number of rows that will be extracted from the database when generating the data.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"failOnSubstitutionError","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"boolean","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"If set to ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":", or not set at all, this flag will force the generation of the data to fail if there is an issue with performing parameter substitution.","type":"text"}]},{"type":"paragraph","content":[{"text":"If this is set to ","type":"text"},{"text":"false","type":"text","marks":[{"type":"code"}]},{"text":" then a where clause that fails parameter substitution will be ignored.","type":"text"}]},{"type":"paragraph","content":[{"text":"The default value for this flag if it is not set is ","type":"text"},{"text":"true","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[194.0]},"content":[{"type":"paragraph","content":[{"text":"timeout","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[111.0]},"content":[{"type":"paragraph","content":[{"text":"number","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[98.0]},"content":[{"type":"paragraph","content":[{"text":"no","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1056.0]},"content":[{"type":"paragraph","content":[{"text":"The number of milliseconds before the SQL should be cancelled. Default 120000, can be disabled by setting to 0, can be changed globally by setting the system property ","type":"text"},{"text":"weave.data.timeout","type":"text","marks":[{"type":"code"}]},{"text":". Also, the system property ","type":"text"},{"text":"weave.data.mimimumtimeout","type":"text","marks":[{"type":"code"}]},{"text":" specifies a minimum value, currently 5000, that if the timeout is set greater than 0 but less than this value it will be increased to be this value.","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"None","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Examples","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Basic data definition where output is based on columns in the underlying table","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"In the following examples the ","type":"text"},{"text":"||","type":"text","marks":[{"type":"code"}]},{"text":" operator is used to concatenate strings, this operator is Oracle specific, and my require using a different operator for other databases, for example ","type":"text"},{"text":"+","type":"text","marks":[{"type":"code"}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Sample data definition with caching parameters explicitly set","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t500\n\t\t\tfalse\n\t\t\t60\n\t\t\t300\n\t\t\ttrue\n\t\t\t20000\n\t\t\tfalse\n\t\t\t120\n\t\t\tLRU\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Sample data definition with caching disabled","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Sample data definition with caching parameters supplied by a cache configuration (so the cache definition can be reused)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t500\n\tfalse\n\t60\n\t300\n\ttrue\n\t20000\n\tfalse\n\t120\n\tLRU\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"A data definition for supplying a list of values (no key is defined), probably for a cascading input parameter for a search","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Another data definition for supplying a list of values, probably for a triple field cascading input parameter for a search","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Set a timeout for a data definition","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\t15000\n\t\t\n\t\n\n\n","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"More on Caching","type":"text"}]},{"type":"paragraph","content":[{"text":"To disable the caching all together you'd do the following","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t...\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"To modify the default caching options","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\t\n\t\t...\n\t\t\n\t\t\tvalue\n\t\t\tvalue\n\t\t\tvalue\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Where the ","type":"text"},{"text":"","type":"text","marks":[{"type":"code"}]},{"text":" you can change are identified at ","type":"text"},{"text":"caching","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/weavedocs1/pages/3248854"}}]}]},{"type":"paragraph","content":[{"text":"You can set the default cache settings with","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tvalue\n\tvalue\n\tvalue\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"and create a cache definition that can be re-used","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tvalue\n\tvalue\n\tvalue\n\n\n\n\t\n\t\t...\n\t\t\n\t\n\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Note that prior to Weave 2.5.18 the default cache setting for a datasource data connection was to cache the information ","type":"text"},{"text":"forever","type":"text","marks":[{"type":"em"}]},{"text":", as of 2.5.18 the data will only be cached for 5 minutes by default.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Using a temporary table","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Using a temporary table","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n","type":"text"}]},{"type":"paragraph","content":[{"text":"This example will utilise a temporary table called ","type":"text"},{"text":"ROADS_SELECTION","type":"text","marks":[{"type":"code"}]},{"text":" which contains two columns ","type":"text"},{"text":"RD_NAME","type":"text","marks":[{"type":"code"}]},{"text":" who's data type matches the ","type":"text"},{"text":"RD_NAME","type":"text","marks":[{"type":"code"}]},{"text":" column in the ","type":"text"},{"text":"ROADS","type":"text","marks":[{"type":"code"}]},{"text":" table, and ","type":"text"},{"text":"UID","type":"text","marks":[{"type":"code"}]},{"text":" which is a varchar column long enough to contain 32 random characters, and there should be an non-unique index on the ","type":"text"},{"text":"UID","type":"text","marks":[{"type":"code"}]},{"text":" column.","type":"text"}]},{"type":"paragraph","content":[{"text":"Note:","type":"text","marks":[{"type":"strong"}]},{"text":" that \"userid\" and \"key\" are the default names for the columns in the temporary table, they can be called anything but if they're not \"userid\" and/or \"key\" then you'd need to set the ","type":"text"},{"text":"keycolumn ","type":"text","marks":[{"type":"code"}]},{"text":"and ","type":"text"},{"text":"usercolumn","type":"text","marks":[{"type":"code"}]},{"text":" values in the data defintiion to match the names of the columns in the temporary table, as has been done above since the column names are actually \"RD_NAME\" and \"UID\" rather than \"userid\" and \"key\". You always need to provide the ","type":"text"},{"text":"keytable","type":"text","marks":[{"type":"code"}]},{"text":" parameter so there's no default for that.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Sorting data","type":"text"}]},{"type":"paragraph","content":[{"text":"You can add tags to specify what column(s) to sort by by default, e.g.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n\t\t\n\t\n","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"New Join Syntax","type":"text"}]},{"type":"paragraph","content":[{"text":"As of Weave 2.5.11 it's possible to specify a table join using join specific tag (rather than having to use ","type":"text"},{"text":"from","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"where","type":"text","marks":[{"type":"code"}]},{"text":" tags).","type":"text"}]},{"type":"paragraph","content":[{"text":"This is done with the ","type":"text"},{"text":"join","type":"text","marks":[{"type":"code"}]},{"text":" tag, which takes 3 parameters, ","type":"text"},{"text":"table","type":"text","marks":[{"type":"code"}]},{"text":" which is required and is the name of the table to join on, ","type":"text"},{"text":"on","type":"text","marks":[{"type":"code"}]},{"text":" which is also required and is the join clause, and finally ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" which isn't required and will specify the join type to use (will default to an inner join).","type":"text"}]},{"type":"paragraph","content":[{"text":"Note that there currently is no checking on the value specified for the ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" parameter, the valid specified for ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" will be placed directly into the generated SQL, so you should ensure that you're using a valid join type for your database (\"inner\", \"left\", \"right\", \"full\", etc).","type":"text"}]},{"type":"heading","attrs":{"level":5},"content":[{"text":"Join syntax example","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\t\n\t\t\n\t\t\tPLANS.ACTIVE=TRUE\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n","type":"text"}]},{"type":"paragraph","content":[{"text":"The above example shows joining the ","type":"text"},{"text":"PLANS","type":"text","marks":[{"type":"code"}]},{"text":" table. Using the previous version of the roadDetails data definition would not return any rows where there was not a match between the ","type":"text"},{"text":"ROADS","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"PLANS","type":"text","marks":[{"type":"code"}]},{"text":" table, using the newer syntax it's possible to generate SQL that will return rows from ","type":"text"},{"text":"ROADS","type":"text","marks":[{"type":"code"}]},{"text":" even if there is no match in the ","type":"text"},{"text":"PLANS","type":"text","marks":[{"type":"code"}]},{"text":" table.","type":"text"}]},{"type":"paragraph","content":[{"text":"Note that the above configuration for the ","type":"text"},{"text":"plan","type":"text","marks":[{"type":"code"}]},{"text":" parameter is not currently smart enough to generate a value value for ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]},{"text":", since it does not take into account the fact that the ","type":"text"},{"text":"PLANS.PLAN_CODE","type":"text","marks":[{"type":"code"}]},{"text":" value will be ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" if there is no matching row in the ","type":"text"},{"text":"PLANS","type":"text","marks":[{"type":"code"}]},{"text":" table. The ","type":"text"},{"text":"column","type":"text","marks":[{"type":"code"}]},{"text":" attribute should be updated to use the appropriate SQL syntax for your database to check for a a ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" value and handle it accordingly (i.e. generate a link to a \"no plan available\" page).","type":"text"}]},{"type":"paragraph","content":[{"text":"The SQL generated for the previous version (using ","type":"text"},{"text":"from","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"where","type":"text","marks":[{"type":"code"}]},{"text":" tags) would be of the form:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"SELECT columns\nFROM primary_table, secondary_table\nWHERE primary_table.column = secondary_table.column","type":"text"}]},{"type":"paragraph","content":[{"text":"Using a ","type":"text"},{"text":"join","type":"text","marks":[{"type":"code"}]},{"text":" tag (without a ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" specified) the SQL generated would be of the form:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"SELECT columns\nFROM primary_table JOIN secondary_table ON primary_table.column = secondary_table.column","type":"text"}]},{"type":"paragraph","content":[{"text":"If the ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":" were specified as \"left\" then the SQL generated would be of the form:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"SELECT columns\nFROM primary_table left JOIN secondary_table ON primary_table.column = secondary_table.column","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported