{"id":425,"date":"2023-10-31T07:20:06","date_gmt":"2023-10-31T06:20:06","guid":{"rendered":"http:\/\/www.pierre-vincent.com\/memosap\/?p=425"},"modified":"2023-10-31T07:20:06","modified_gmt":"2023-10-31T06:20:06","slug":"cpi-ds-queries-synthax","status":"publish","type":"post","link":"http:\/\/www.pierre-vincent.com\/memosap\/2023\/10\/31\/cpi-ds-queries-synthax\/","title":{"rendered":"CPI-DS Queries & synthax"},"content":{"rendered":"\n

|| – Concatener des chaines – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS<\/p>\n\n\n\n

ltrim(table.champ,0) – Left trim du caract\u00e8re en param\u00e8tre – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS<\/p>\n\n\n\n

Like + % – Filtrer sur un d\u00e9but de chaine avec % comme caract\u00e8re g\u00e9n\u00e9rique : MARC.DISPO like ‘R5%’<\/p>\n\n\n\n

<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

|| – Concatener des chaines – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS ltrim(table.champ,0) – Left trim du caract\u00e8re en param\u00e8tre – ‘EXT_’ || ltrim(MARC.MATNR,0) || ‘_’ || MARC.WERKS Like + % – Filtrer sur un d\u00e9but de chaine avec … Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,7],"tags":[],"class_list":["post-425","post","type-post","status-publish","format-standard","hentry","category-dev-tech-interface","category-ibp"],"_links":{"self":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/comments?post=425"}],"version-history":[{"count":1,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":426,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/posts\/425\/revisions\/426"}],"wp:attachment":[{"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.pierre-vincent.com\/memosap\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}