{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"paragraph","content":[{"text":"The Delete-statement is used to delete items from Perfion. An example is shown here:","type":"text"}]},{"type":"paragraph","content":[{"text":"XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"Query\": {\n \"Delete\": { },\n \"From\": { \"id\": \"Product\" },\n \"Where\": {\n \"Clauses\": [\n { \"Clause\": { \"id\": \"Material\", \"operator\": \"=\", \"value\": \"Stainless Steel\" } }\n ]\n }\n }\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"The above query will delete all items of base feature ‘Product’, where the ‘Material’ equals ‘Stainless Steel’. More elaborate clauses can be created. There will be more on where-clauses later.","type":"text"}]},{"type":"paragraph","content":[{"text":"Be careful when doing deletes. The below query will delete all products (that is, items of base feature product):","type":"text"}]},{"type":"paragraph","content":[{"text":"XML:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"JSON:","type":"text"}]},{"type":"codeBlock","content":[{"text":"{\n \"Query\": {\n \"Delete\": { },\n \"From\": { \"id\": \"Product\" },\n }\n}","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" The delete statement supports the timezone-attribute/property the exact same way the update-statement does. ","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":"3478a1b4-3bc1-438b-ad20-e920fe0fb9f9"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"ddf56312-36e9-42c2-b884-cc0b66fd105d"}}]}]}],"version":1}

Browser not supported