{"id":5244,"date":"2017-09-03T20:48:22","date_gmt":"2017-09-03T19:48:22","guid":{"rendered":"https:\/\/esperanto.berlin\/?page_id=5244"},"modified":"2017-09-03T22:03:45","modified_gmt":"2017-09-03T21:03:45","slug":"inventory-waren","status":"publish","type":"page","link":"https:\/\/esperanto.berlin\/de\/wp-inventory-klarigo\/mendi-produktojn\/inventory-waren\/","title":{"rendered":"WP Inventory mit DBview"},"content":{"rendered":"<p>Die SQL-Anweisung f\u00fcr\u00a0 <a href=\"https:\/\/wordpress.org\/plugins\/dbview\/\">dbview<\/a>. k\u00f6nnte so aussehen. Aus einer zweiten Tabelle wird die Bezeichnung f\u00fcr die category_id geholt.<br \/>\n<code><br \/>\nSELECT inventory_name AS titolo, inventory_price AS prezo, category_name as kategorio FROM wp_wpinventory_item as item, wp_wpinventory_category as cat WHERE item.category_id = cat.category_id<br \/>\n<\/code><br \/>\nsie wird mit folgendem Shortcode eingebunden. In eckigen Klammern versteht sich&#8230;.<br \/>\n<code>\"<br \/>\ndbview name=\"Warenbestand\" pagesize=3<br \/>\n<\/code><br \/>\nDabei wird nur ein Teil der Datens\u00e4tze geeigt und gebl\u00e4ttert.<br \/>\n<div><!-- http:\/\/wordpress.org\/extend\/plugins\/dbview -->\r\n     <div class='messageHolder'><\/div>\r\n     <div class='dbview autoload' data-name='Warenbestand' data-pagesize='3' ><\/div><\/div>\r\n<\/p>\n<p>Mit verschiedenen SQL-Abfragen kann man die gew\u00fcnschten Listen selbst zusammenstellen.<\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Die SQL-Anweisung f\u00fcr\u00a0 dbview. k\u00f6nnte so aussehen. Aus einer zweiten Tabelle wird die Bezeichnung f\u00fcr die category_id geholt. SELECT inventory_name AS titolo, inventory_price AS prezo, category_name as kategorio FROM wp_wpinventory_item as item, wp_wpinventory_category as cat WHERE item.category_id = cat.category_id sie &hellip; <a href=\"https:\/\/esperanto.berlin\/de\/wp-inventory-klarigo\/mendi-produktojn\/inventory-waren\/\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":20,"featured_media":0,"parent":5214,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"jetpack_shortlink":"https:\/\/wp.me\/Par8jA-1mA","_links":{"self":[{"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/pages\/5244"}],"collection":[{"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/comments?post=5244"}],"version-history":[{"count":13,"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/pages\/5244\/revisions"}],"predecessor-version":[{"id":5263,"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/pages\/5244\/revisions\/5263"}],"up":[{"embeddable":true,"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/pages\/5214"}],"wp:attachment":[{"href":"https:\/\/esperanto.berlin\/de\/wp-json\/wp\/v2\/media?parent=5244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}