{"id":4370,"date":"2014-09-03T09:58:45","date_gmt":"2014-09-03T14:58:45","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=4370"},"modified":"2014-09-03T11:06:10","modified_gmt":"2014-09-03T16:06:10","slug":"atg-printing-items-in-a-giftlist","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2014\/09\/03\/atg-printing-items-in-a-giftlist\/","title":{"rendered":"ATG &#8211; printing items in a giftlist"},"content":{"rendered":"<p>What is below will print all SKU&#8217;s in a giftlist for a given profile&#8230;<\/p>\n<pre>\r\nSQL> select g.catalog_ref_id, stock_level, s.display_name\r\n  2    from core.dcs_giftitem g, core.dcs_inventory i, cata.dcs_sku s\r\n  3    where id in (select giftitem_id\r\n  4                   from core.dcs_giftlist_item o\r\n  5                   where giftlist_id in (select giftlist_id\r\n  6                                           from core.dcs_user_wishlist\r\n  7                                           where user_id = '**hidden_id**'))\r\n  8      and g.catalog_ref_id = i.catalog_ref_id\r\n  9      and s.sku_id = i.catalog_ref_id;\r\n\r\nCATALOG_REF_ID  STOCK_LEVEL DISPLAY_NAME\r\n--------------- ----------- ----------------------------------------\r\n0502742                 452 EXPRESS LIP GLOSS\r\n9444005                  44 SNAKESKIN PRINT HALTER SLIP DRESS\r\n9508537                  19 CLASSIC POINTED TOE RUNWAY PUMP\r\n9293184                 134 DRAWSTRING SIDE STRIPE TRACK PANT\r\n8681883                 598 CROPPED MESH INSET GRAPHIC TEE - AZTEC\r\n2285635                  41 NEP KNIT BASEBALL TEE\r\n8686010                 235 BELL SLEEVE LACE TRAPEZE TOP\r\n7413048                 245 BORDER PRINT RUFFLED MAXI DRESS\r\n8311199                  53 SCUBA AND CAT GRAPHIC MINI SKIRT\r\n9508848                  64 HIGH HEELED PUMP\r\n2285628                  10 NEP KNIT BASEBALL TEE\r\n9129304                  20 LOW RISE ANKLE ROLLED BOYFRIEND JEAN\r\n\r\n12 rows selected.\r\n\r\nSQL>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>What is below will print all SKU&#8217;s in a giftlist for a given profile&#8230; SQL> select g.catalog_ref_id, stock_level, s.display_name 2 from core.dcs_giftitem g, core.dcs_inventory i, cata.dcs_sku s 3 where id in (select giftitem_id 4 from core.dcs_giftlist_item o 5 where giftlist_id&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2014\/09\/03\/atg-printing-items-in-a-giftlist\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[37,38],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4370"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=4370"}],"version-history":[{"count":6,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4370\/revisions"}],"predecessor-version":[{"id":4376,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/4370\/revisions\/4376"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=4370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=4370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=4370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}