{"type":"doc","content":[{"type":"layoutSection","marks":[{"type":"breakout","attrs":{"mode":"wide"}}],"content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Overview","type":"text"}]},{"type":"paragraph","content":[{"text":"The Perfion Query syntax and all its possibilities are described in the following sections. The Perfion Query can be defined in either XML or JSON format. All examples are shown in each version.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"A simple example","type":"text"}]},{"type":"paragraph","content":[{"text":"Below is a very simple example of what a Perfion Query could look like. The query is defined to return data for the 3 features ItemNumber, Image and Description in the English language for Products that have value 1600 in PowerW.","type":"text"}]},{"type":"paragraph","content":[{"text":"XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n \n \n \n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"Query\": {\n \"Select\": {\n \"languages\": \"EN\",\n \"Features\": [\n { \"id\": \"ItemNumber\" },\n { \"id\": \"Image\" }, \n { \"id\": \"Description\" },\n ]\n },\n \"From\": [ \n { \"id\": \"Product\" }\n ],\n \"Where\": {\n \"Clauses\": [ \n { \"Clause\": { \"id\": \"PowerW\", \"operator\": \"=\", \"value\": \"1600\" } }\n ]\n }\n }\n}\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Below is an example of what the results from the above query could look like:","type":"text"}]},{"type":"paragraph","content":[{"text":"XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n \n \n \n\n \n TE717209RW\n 5fd1e0be-56bd-407f-bce8-6e6d35f1e792\n Siemens TE717209RW is a beautiful piano black fully automatic espresso machine from Siemens EQ7 series. With just a tap you make cappuccino, latte, espresso or coffee.\n\nThis model has the smart and practical \"My Coffee\" function so you can configure the relationship between milk and espresso in your drink - you could choose up to 80% coffee, so you have extra power and heat your milk drink!\n\nThe grinder automatically adjusts itself to the coffee blend you use. And the individual programming ensures that up to 6 people can have their own coffee profile, where each button is programmed after the personal wishes.\n \n \n TE806201RW\n 004ede8a-592a-4466-90ae-f5f97aa117dc\n EQ8 series espresso machines in a class by itself, with a beautiful stainless steel design and an intelligent heating system: sensoFlow-ensuring system constant brewing temperature and thus guarantees maximum enjoyment espresso every time.\n\nSiemens EQ8 also the smart aroma double shot mode makes extra strong coffee less bitter because the machine grinds and brews twice with 19 bar.\n\nFurthermore ensures EQ8 an exclusive convenience through OneTouch Feature creamCleaner, cup warmer, lighting and insulated milk container.\n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"Data\": {\n \"totalExecutionTime\": \"00:00:00.0882522\",\n \"Features\": [\n { \"name\": \"Image\", \"id\": 105, \"language\": \"EN\", \"caption\": \"Image\", \"group\": \"All\", \"dataType\": \"Image\" },\n { \"name\": \"Description\", \"id\": 148, \"language\": \"EN\", \"caption\": \"Description\", \"group\": \"All\", \"dataType\": \"Text\" },\n { \"name\": \"Product\", \"id\": 100, \"language\": \"EN\", \"caption\": \"Product\", \"group\": \"All\", \"dataType\": \"String\" }\n ],\n \"Items\": [\n { \"featureId\": 100, \"featureName\": \"Product\", \"id\": 853, \"parentId\": 0, \"brand\": \"Normal\", \"order\": 0,\n \"Values\": [\n { \"featureId\": 100, \"featureName\": \"Value\", \"seq\": 0, \"modifiedDate\": \"2016-07-12T11:01:22.93\", \"value\": \"TE717209RW\" },\n { \"featureId\": 105, \"featureName\": \"Image\", \"seq\": 0, \"modifiedDate\": \"2019-11-27T09:09:56.437\", \"string\": \"MCSA00992759_SE_K_12_KV7_EQ7_TE717209RW_picture_KF1_coffeemachine_ENG_230215_def_(48).jpg.jpg\", \"fileSize\": 18967, \"fileModifiedDate\": \"2019-11-27T09:09:50.123\", \"width\": 300, \"height\": 300, \"widthDpi\": 48, \"heightDpi\": 48, \"value\": \"5fd1e0be-56bd-407f-bce8-6e6d35f1e792\" },\n { \"featureId\": 148, \"featureName\": \"Description\", \"language\": \"EN\", \"seq\": 0, \"modifiedDate\": \"2017-11-23T13:48:44.45\", \"value\": \"Siemens TE717209RW is a beautiful piano black fully automatic espresso machine from Siemens EQ7 series. With just a tap you make cappuccino, latte, espresso or coffee.\\r\\n\\r\\nThis model has the smart and practical \\\"My Coffee\\\" function so you can configure the relationship between milk and espresso in your drink - you could choose up to 80% coffee, so you have extra power and heat your milk drink!\\r\\n\\r\\nThe grinder automatically adjusts itself to the coffee blend you use. And the individual programming ensures that up to 6 people can have their own coffee profile, where each button is programmed after the personal wishes.\" }\n ]\n },\n { \"featureId\": 100,\"featureName\": \"Product\", \"id\": 858,\"parentId\": 0, \"brand\": \"Normal\", \"order\": 0, \"createdDate\": \"2016-07-12T11:15:10.52\", \"modifiedDate\": \"2020-04-21T14:59:11.317\", \n \"Values\": [\n { \"featureId\": 100, \"featureName\": \"Value\", \"seq\": 0, \"modifiedDate\": \"2016-07-12T11:15:18.887\", \"value\": \"TE806201RW\" },\n { \"featureId\": 105, \"featureName\": \"Image\", \"seq\": 0, \"modifiedDate\": \"2019-11-27T09:09:56.437\", \"string\": \"MCSA01088244_SE_K_12_KV8_EQ8_TE806201RW_picture_KF1_machine_ENG_120615_def_(48).jpg.jpg\", \"fileSize\": 36135, \"fileModifiedDate\": \"2019-11-27T09:09:50.17\", \"width\": 452, \"height\": 480, \"widthDpi\": 48, \"heightDpi\": 48, \"value\": \"004ede8a-592a-4466-90ae-f5f97aa117dc\" },\n { \"featureId\": 148, \"featureName\": \"Description\", \"language\": \"EN\", \"seq\": 0, \"modifiedDate\": \"2016-07-12T11:50:54.053\", \"value\": \"EQ8 series espresso machines in a class by itself, with a beautiful stainless steel design and an intelligent heating system: sensoFlow-ensuring system constant brewing temperature and thus guarantees maximum enjoyment espresso every time.\\r\\n\\r\\nSiemens EQ8 also the smart aroma double shot mode makes extra strong coffee less bitter because the machine grinds and brews twice with 19 bar.\\r\\n\\r\\nFurthermore ensures EQ8 an exclusive convenience through OneTouch Feature creamCleaner, cup warmer, lighting and insulated milk container.\" }\n ]\n }\n ]\n }\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"The result always starts with the Metadata about the returned features followed by all the actual data","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Result Metadata","type":"text"}]},{"type":"paragraph","content":[{"text":"The first part of the result always contains a section called , that contains all the metadata about the returned features, such as:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"2b8c2fa5-c4e6-491d-81bb-a2bcd8787ccd"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"id","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The unique ID of the feature.","type":"text"}]},{"type":"paragraph","content":[{"text":"In queries both the feature name and ID can be used.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The unique Name of the feature","type":"text"}]},{"type":"paragraph","content":[{"text":"In queries both the feature name and ID can be used.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Language","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"Indicates the language of the values of the other attributes in the Xml-element.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Caption","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The caption to precede the value on e.g. a web page, in a catalog or other output.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"captionAlternative","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"An alternative caption.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Unit","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The unit of the value of the feature.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Abbr","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The abbreviation (could be used instead of the caption in some situations).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Group","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The Information Group the feature belongs to.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"groupOrder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The Order of the Information Group as they are defined in Perfion","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"viewGroup","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The View Group the feature belongs to (if defined in Perfion)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"viewGroupOrder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The Order of the View Group as they are defined in Perfion","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"dataType","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The Perfion DataType of the feature (string, number, date, text, image, file, query, table).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"viewOrder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"The Order of appearance of the features.","type":"text"}]},{"type":"paragraph","content":[{"text":"Important: This is a first seen order of appearance. Each item in the result-set may have a different viewOrder defined in Perfion. The viewOrder at this level is set by inspecting each item until all columns have an order.","type":"text"}]},{"type":"paragraph","content":[{"text":"This viewOrder is relevant when several Items must be shown together on a list.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[226.0]},"content":[{"type":"paragraph","content":[{"text":"Form","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[855.0]},"content":[{"type":"paragraph","content":[{"text":"A value indicating the form/nature of the feature, which can be either of: ‘Simple’: A simple feature containing only its own base values.","type":"text"}]},{"type":"paragraph","content":[{"text":"‘Complex’: The feature is extended with a configuration of additional features (e.g. a Product with many features, or a Designer with additional features).","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Result Data","type":"text"}]},{"type":"paragraph","content":[{"text":"All the rest of the elements in the Xml contains the actual data. In the above example the enclosing elements are named since the returned items are of the feature type Product, as specified by the element in the Perfion Query.","type":"text"}]},{"type":"paragraph","content":[{"text":"The enclosing Item elements always contain the following attributes:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"70ac7538-d0e7-4da7-9828-d32e98d9d4d9"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"id","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[890.0]},"content":[{"type":"paragraph","content":[{"text":"The unique ID of the item.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"parentId","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[890.0]},"content":[{"type":"paragraph","content":[{"text":"The ID of the parent Item (when in a hierarchy). 0 if it has no parent.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Brand","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[890.0]},"content":[{"type":"paragraph","content":[{"text":"The brand of the Item (can be either: Virtual, Normal, CatalogRoot or Brand).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Order","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[890.0]},"content":[{"type":"paragraph","content":[{"text":"The Order of the Item as defined on the Item itself for its own purpose (e.g. when ordering the Sections on the left side or defining a special order of Items in a Lookup for their own purpose). For features that do not allow ‘","type":"text"},{"text":"Custom Ordering","type":"text","marks":[{"type":"underline"}]},{"text":"’ the Order will always be 0.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"childCount","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[890.0]},"content":[{"type":"paragraph","content":[{"text":"The number of child items that have this Item as their parent.","type":"text"}]},{"type":"paragraph","content":[{"text":"Optional","type":"text","marks":[{"type":"underline"}]},{"text":": Only included with Select option ‘","type":"text"},{"text":"IncludeChildCount","type":"text","marks":[{"type":"underline"}]},{"text":"’ specified.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The feature value elements contained within the elements may contain the following attributes:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"fa5a781c-9bae-4d93-99e0-6609b3c94273"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[202.0]},"content":[{"type":"paragraph","content":[{"text":"id","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[879.0]},"content":[{"type":"paragraph","content":[{"text":"The unique ID of the item. For features defined as ‘","type":"text"},{"text":"Selectable","type":"text","marks":[{"type":"underline"}]},{"text":"’ (i.e. Lookup values).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[202.0]},"content":[{"type":"paragraph","content":[{"text":"Language","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[879.0]},"content":[{"type":"paragraph","content":[{"text":"The language of the value of the Xml-element (for features defined as ‘","type":"text"},{"text":"Localizable","type":"text","marks":[{"type":"underline"}]},{"text":"’.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[202.0]},"content":[{"type":"paragraph","content":[{"text":"Seq","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[879.0]},"content":[{"type":"paragraph","content":[{"text":"The sequence of the values, for features defined to ‘","type":"text"},{"text":"Allow Multiple","type":"text","marks":[{"type":"underline"}]},{"text":"’ and ‘","type":"text"},{"text":"Sortable","type":"text","marks":[{"type":"underline"}]},{"text":"’ values. The sequence is 0 for all other feature values.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[202.0]},"content":[{"type":"paragraph","content":[{"text":"relatedOrder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[879.0]},"content":[{"type":"paragraph","content":[{"text":"This order appears on a feature value element when the specific feature in its definition includes ‘","type":"text"},{"text":"Sortable Related Items","type":"text","marks":[{"type":"underline"}]},{"text":"’. The order indicates how the enclosing Item is ordered in relation to the feature (e.g. the order of a Product Item within a certain Section).","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[202.0]},"content":[{"type":"paragraph","content":[{"text":"viewOrder","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[879.0]},"content":[{"type":"paragraph","content":[{"text":"The order in which the features for an Item should appear (as defined in the Item Configuration where features can be ordered individually for different Categories or groupings of Products or Items).","type":"text"}]},{"type":"paragraph","content":[{"text":"Features included explicitly by the Query are ordered as defined in the Query, followed by all other features according to their order as defined by the feature Configuration.","type":"text"}]},{"type":"paragraph","content":[{"text":"Optional","type":"text","marks":[{"type":"underline"}]},{"text":": Only included with Select option ‘","type":"text"},{"text":"IncludeFeatureViewOrder","type":"text","marks":[{"type":"underline"}]},{"text":"’ specified.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Furthermore, for Image and File features the following attributes are used:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"ac8d66aa-f140-45ca-9a10-e744c3eb6de8"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[242.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[839.0]},"content":[{"type":"paragraph","content":[{"text":"Used to hold the filename of the image or file.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[242.0]},"content":[{"type":"paragraph","content":[{"text":"fileSize","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[839.0]},"content":[{"type":"paragraph","content":[{"text":"The file size in bytes.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[242.0]},"content":[{"type":"paragraph","content":[{"text":"fileModifiedDate","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[839.0]},"content":[{"type":"paragraph","content":[{"text":"The date when the file was last modified.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The Boolean data type returns \"True\" and \"False\" as values. For the two-state mode, it only returns \"True\" since the false is represented as Null in the system.","type":"text"}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f42e007f-a197-4d66-ac7e-0b9c46424763"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"722dc78a-e043-42b2-8453-ad9aa4b84d0f"}},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"Read more:","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"all":{"value":"true"}},"macroMetadata":{"macroId":{"value":"13c7c989371332400e7ad79301c6bf3e"},"schemaVersion":{"value":"2"},"title":"Child pages (Children Display)"}},"localId":"4912c667-1f0e-4739-ab8a-73e6cec81b8a"}}]}]},{"type":"paragraph"}],"version":1}

Browser not supported