{"id":2652,"date":"2019-11-26T16:01:45","date_gmt":"2019-11-26T14:01:45","guid":{"rendered":"https:\/\/portal.winmentor.ro\/wme\/?page_id=2652"},"modified":"2019-11-26T16:01:46","modified_gmt":"2019-11-26T14:01:46","slug":"coloane-suplimentare","status":"publish","type":"page","link":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/","title":{"rendered":"Coloane suplimentare"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>Pentru a ajunge la butonul Coloane suplimentare apasati butonul din \nimaginea de mai jos. <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" src=\"\/Images\/139.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">din partea de jos a listei.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Listele WME sunt create initial cu un numar limitat \nde coloane (campuri).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In functie de specificul de activitate sunt \nnecesare de multe ori si alte coloane existente in baza de date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceste coloane se pot adauga de catre \nutilizator prin alegere dintr-o lista de coloane posibile si se numesc \ncoloane suplimentare.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">macheta de descriere a coloanelor suplimentare \neste ca in imaginea de mai jos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In lista din stanga sunt afisate toate tabele \ndisponibile care sunt legate de lista curenta, iar cu DubluClick se pot \ntransfera aceste campuri in grila de coloane suplimentare afisata in dreapta \nimaginii.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" src=\"\/Images\/29.PNG\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;Denumire coloana&#8221; nu poate fi modificat si \neste specific listei curente. &#8220;Alias&#8221; este o denumire de camp mai accesibila si \npoate fi schimbat cu orice nume unic, desi in majoritatea cazurilor nu e \nnecesar. Ceea ce e important in grila este coloana \u201cDisplay\u201d, care reprezinta \nnumele sub care vei regasi coloana in lista.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dupa descrierea coloanelor suplimentare, la \napasarea butonului OK, lista se inchide automat si e necesar sa realegeti \noptiunea din meniu pentru a genera o lista cu noile coloane active.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In partea dreapta sunt predefinite cateva \nsabloane pentru functii SQL care pot fi aplicate coloanelor \nselectate:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>AN: \nExtrage anul dintr-o coloana de tip data \n<\/li><li>LUNA: Extrage luna dintr-o coloana de tip data \n<\/li><li>ZI: \nExtrage ziua dintr-o coloana de tip data <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Numere:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ROUND: Rotunjeste un numar la un numar de zecimale ales \n<\/li><li>ABS: Returneaza valoarea absoluta a unui numar \n<\/li><li>SIGN: Returneaza semnul unui numar <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Sir de caractere (string):<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CONCAT: Concateneaza doua siruri de caractere \n<\/li><li>REPLACE: Inlocuieste doua siruri de caractere cu altul, in coloane \ncaracter \n<\/li><li>SUBSTR: Extragerea unui sir de caractere dintr-o coloana de tip \ncaracter <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Expresii:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CASE: Initializare valori coloana in functie de conditii pentru \nfiecare caz in parte \n<\/li><li>DECODE: Extragerea unui subsir dintr-o coloana caracter \n<\/li><li>NVL: Fixare valoare pentru coloane nule <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Exemplu:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Presupunem ca am adus in lista \u201cStocuri la \nmoment\u201d coloana \u201cStoc minim\u201d din \u201cNomenclatorul de articole\u201d (figura de mai \nsus), adica cu dublu click pe NOBJ.STOCMIN am trecut coloana din \u201cColoane \ndisponibile\u201d in \u201cColoane suplimentare\u201d si dorim sa rotunjim valoarea stocului \nminim din aceasta coloana la doua zecimale.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru aceasta:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>stergem din campul \u201cDescriere expresie pentru coloana\u201d (figura de \nmai sus) textul NOBJ.STOCMIN. \n<\/li><li>apasam butonul \u201cROUND\u201d si observam ca pe ecran a aparut sintaxa \nfunctiei de rotunjire: ROUND(&lt;coloana&gt;, &lt;zecimale&gt;). \n<\/li><li>In \nlocul textului \u201c&lt;coloana&gt;\u201d introducem numele coloanei, in cazul nostru \n\u201cNOBJ.STOCMIN\u201d. \n<\/li><li>In \nlocul textului \u201c&lt;zecimale&gt;\u201d introducem numarul de zecimale la care dorim \nsa rotunjim numarul. Sa zicem 2. \n<\/li><li>In \nfinal vom obtine: <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" loading=\"lazy\" src=\"\/Images\/30.PNG\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Apasati \u201cOk\u201d, salvati modificarile, iar cand deschideti din nou \nlista veti observa ca ultima coloana va fi \u201cSTOCMIN\u201d. <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Butonul Coloane \nvizibile, ordonare si grupare, filtrare deschide \nmacheta cu acelasi nume (prezentata in amanunt in capitolul 4), si care permite \nconfigurarea avansata a continutului listei, prin gruparea acesteia dupa anumite \ncoloane si filtrarea dupa anumite conditii.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In Lista \ngrupurilor sunt aduse din macheta \u201cColoane vizibile, \nordonare si grupare, filtrare\u201d&nbsp; din pagina \u201cOrdonare si grupare\u201d grupurile dupa \ncare este ordonata si grupata lista.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pentru a ajunge la butonul Coloane suplimentare apasati butonul din imaginea de mai jos. din partea de jos a listei. Listele WME sunt create initial cu un numar limitat de coloane (campuri). In functie de specificul de activitate sunt necesare de multe ori si alte coloane existente in baza de date. Aceste coloane se pot [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1867,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"tags":[],"class_list":["post-2652","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Coloane suplimentare - WinMENTOR ENTERPRISE<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Coloane suplimentare - WinMENTOR ENTERPRISE\" \/>\n<meta property=\"og:description\" content=\"Pentru a ajunge la butonul Coloane suplimentare apasati butonul din imaginea de mai jos. din partea de jos a listei. Listele WME sunt create initial cu un numar limitat de coloane (campuri). In functie de specificul de activitate sunt necesare de multe ori si alte coloane existente in baza de date. Aceste coloane se pot [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/\" \/>\n<meta property=\"og:site_name\" content=\"WinMENTOR ENTERPRISE\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-26T14:01:46+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/coloane-suplimentare\\\/\",\"url\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/coloane-suplimentare\\\/\",\"name\":\"Coloane suplimentare - WinMENTOR ENTERPRISE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/#website\"},\"datePublished\":\"2019-11-26T14:01:45+00:00\",\"dateModified\":\"2019-11-26T14:01:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/coloane-suplimentare\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/coloane-suplimentare\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/coloane-suplimentare\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Suport\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Help\",\"item\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/suport\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Coloane suplimentare\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/#website\",\"url\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/\",\"name\":\"WinMENTOR ENTERPRISE\",\"description\":\"WinMENTOR ENTERPRISE: ERP gestiune, contabilitate Romania\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/portal.winmentor.ro\\\/wme\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Coloane suplimentare - WinMENTOR ENTERPRISE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/","og_locale":"en_US","og_type":"article","og_title":"Coloane suplimentare - WinMENTOR ENTERPRISE","og_description":"Pentru a ajunge la butonul Coloane suplimentare apasati butonul din imaginea de mai jos. din partea de jos a listei. Listele WME sunt create initial cu un numar limitat de coloane (campuri). In functie de specificul de activitate sunt necesare de multe ori si alte coloane existente in baza de date. Aceste coloane se pot [&hellip;]","og_url":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/","og_site_name":"WinMENTOR ENTERPRISE","article_modified_time":"2019-11-26T14:01:46+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/","url":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/","name":"Coloane suplimentare - WinMENTOR ENTERPRISE","isPartOf":{"@id":"https:\/\/portal.winmentor.ro\/wme\/#website"},"datePublished":"2019-11-26T14:01:45+00:00","dateModified":"2019-11-26T14:01:46+00:00","breadcrumb":{"@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/coloane-suplimentare\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/portal.winmentor.ro\/wme\/"},{"@type":"ListItem","position":2,"name":"Suport","item":"https:\/\/portal.winmentor.ro\/wme\/suport\/"},{"@type":"ListItem","position":3,"name":"Help","item":"https:\/\/portal.winmentor.ro\/wme\/suport\/help\/"},{"@type":"ListItem","position":4,"name":"Coloane suplimentare"}]},{"@type":"WebSite","@id":"https:\/\/portal.winmentor.ro\/wme\/#website","url":"https:\/\/portal.winmentor.ro\/wme\/","name":"WinMENTOR ENTERPRISE","description":"WinMENTOR ENTERPRISE: ERP gestiune, contabilitate Romania","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/portal.winmentor.ro\/wme\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/2652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/comments?post=2652"}],"version-history":[{"count":1,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/2652\/revisions"}],"predecessor-version":[{"id":2653,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/2652\/revisions\/2653"}],"up":[{"embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/pages\/1867"}],"wp:attachment":[{"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/media?parent=2652"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portal.winmentor.ro\/wme\/wp-json\/wp\/v2\/tags?post=2652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}