{"id":440,"date":"2013-02-09T11:53:38","date_gmt":"2013-02-09T09:53:38","guid":{"rendered":"https:\/\/blog.avxt.fr\/?p=440"},"modified":"2020-01-04T00:00:33","modified_gmt":"2020-01-03T22:00:33","slug":"master-data-services-excel-add-in-query-updater","status":"publish","type":"post","link":"https:\/\/blog.avxt.fr\/fr\/master-data-services-excel-add-in-query-updater\/","title":{"rendered":"Master Data Services : outil de mises \u00e0 jour de requ\u00eates Excel"},"content":{"rendered":"<p>Hi<\/p>\n<p>This small tool allows you to Load, Edit, and save MDS queries with operators that are not available in current mds add-in<br \/>\n<a href=\"https:\/\/blog.avxt.fr\/wp-content\/uploads\/2013\/02\/232951.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-464\" src=\"https:\/\/blog.avxt.fr\/wp-content\/uploads\/2013\/02\/232951-300x202.jpg\" alt=\"232951\" width=\"300\" height=\"202\" srcset=\"https:\/\/blog.avxt.fr\/wp-content\/uploads\/2013\/02\/232951-300x202.jpg 300w, https:\/\/blog.avxt.fr\/wp-content\/uploads\/2013\/02\/232951.jpg 336w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nyou can download the source code (.Net C# 4.0 Client Profile, VS2010) of my tool here (FREE) <a title=\"HERE\" href=\"https:\/\/blog.avxt.fr\/MDS2012ExcelQueryToolSource.zip\">HERE<\/a><br \/>\nOR<\/p>\n<p><a href=\"https:\/\/github.com\/xavave\/MDS2012ExcelQueryTool\">https:\/\/github.com\/xavave\/MDS2012ExcelQueryTool<\/a><\/p>\n<p>OR<br \/>\nbinary only: <a title=\"HERE\" href=\"https:\/\/blog.avxt.fr\/MDS2012ExcelQueryTool.zip\">HERE<\/a><\/p>\n<p>very easy to use:<\/p>\n<p>Load your already generated query<\/p>\n<p>then choose a new Operator and edit the criteria<\/p>\n<p>and then save the updated query<\/p>\n<p>you can use all these operators:<br \/>\n[Description(\u00ab\u00a0\u00a0\u00bb)] NotSpecified,<br \/>\n[Description(\u00ab\u00a0=\u00a0\u00bb)] IsEqual,<br \/>\n[Description(\u00ab\u00a0&lt;&gt;\u00a0\u00bb)] IsNotEqual,<br \/>\n[Description(\u00ab\u00a0LIKE\u00a0\u00bb)] Like,<br \/>\n[Description(\u00ab\u00a0NOT LIKE\u00a0\u00bb)] NotLike,<br \/>\n[Description(\u00ab\u00a0&gt;\u00a0\u00bb)] GreaterThan,<br \/>\n[Description(\u00ab\u00a0&lt; \u00ab\u00a0)] LessThan, [Description(\u00ab\u00a0&gt;=\u00a0\u00bb)] GreaterThanOrEqual,<br \/>\n[Description(\u00ab\u00a0&lt; =\u00a0\u00bb)] LessThanOrEqual,<br \/>\n[Description(\u00ab\u00a0MATCH\u00a0\u00bb)] Matches,<br \/>\n[Description(\u00ab\u00a0NOT MATCH\u00a0\u00bb)] NotMatches,<br \/>\n[Description(\u00ab\u00a0REGEX\u00a0\u00bb)] ContainsPattern,<br \/>\n[Description(\u00ab\u00a0NOT REGEX\u00a0\u00bb)] NotContainsPattern,<br \/>\n[Description(\u00ab\u00a0IS NULL\u00a0\u00bb)] IsNull,<br \/>\n[Description(\u00ab\u00a0IS NOT NULL\u00a0\u00bb)] IsNotNull,<br \/>\n[Description(\u00ab\u00a0IN\u00a0\u00bb)] In,<br \/>\n[Description(\u00ab\u00a0NOT IN\u00a0\u00bb)] NotIn,<br \/>\n[Description(\u00ab\u00a0DIRECT DECENDANTS\u00a0\u00bb)] DirectDecendants,<br \/>\n[Description(\u00ab\u00a0ALL DECENDANTS\u00a0\u00bb)] AllDecendants,<\/p>\n<p>More info on <a title=\"SQL MDS 2012 MSDN BLOG\" href=\"http:\/\/social.msdn.microsoft.com\/Forums\/en-US\/sqlmds\/thread\/fdb64488-a459-43c0-be96-08344c70fbc9\" target=\"_blank\" rel=\"noopener noreferrer\">sql mds 2012 MSDN blog<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Hi This small tool allows you to Load, Edit, and save MDS queries with operators that are not available in current mds add-in you can download the source code (.Net C# 4.0 Client Profile, VS2010) of my tool here (FREE) HERE OR https:\/\/github.com\/xavave\/MDS2012ExcelQueryTool OR binary only: HERE very easy to \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/blog.avxt.fr\/fr\/master-data-services-excel-add-in-query-updater\/\"> Continue reading <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-440","post","type-post","status-publish","format-standard","hentry","category-mds"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/comments?post=440"}],"version-history":[{"count":14,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/440\/revisions"}],"predecessor-version":[{"id":919,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/posts\/440\/revisions\/919"}],"wp:attachment":[{"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/media?parent=440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/categories?post=440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.avxt.fr\/fr\/wp-json\/wp\/v2\/tags?post=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}