Skip to content
Master Data Services Excel Add-in Query updater - This small tool allows you to Load, Edit, and save MDS queries with operators that are not available in current mds add-in
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore
LICENSE
README.md

README.md

MDS2012ExcelQueryTool

Master Data Services Excel Add-in Query updater - This small tool allows you to Load, Edit, and save MDS queries with operators that are not available in current mds add-in http://legacy.averbouch.biz/master-data-services-excel-add-in-query-updater/

Load your already generated query

then choose a new Operator and edit the criteria

and then save the updated query

you can use all these operators: [Description(“”)] NotSpecified, [Description(“=”)] IsEqual, [Description(“<>”)] IsNotEqual, [Description(“LIKE”)] Like, [Description(“NOT LIKE”)] NotLike, [Description(“>”)] GreaterThan, [Description(“< “)] LessThan, [Description(“>=”)] GreaterThanOrEqual, [Description(“< =”)] LessThanOrEqual, [Description(“MATCH”)] Matches, [Description(“NOT MATCH”)] NotMatches, [Description(“REGEX”)] ContainsPattern, [Description(“NOT REGEX”)] NotContainsPattern, [Description(“IS NULL”)] IsNull, [Description(“IS NOT NULL”)] IsNotNull, [Description(“IN”)] In, [Description(“NOT IN”)] NotIn, [Description(“DIRECT DECENDANTS”)] DirectDecendants, [Description(“ALL DECENDANTS”)] AllDecendants,

More info on sql mds 2012 MSDN blog

You can’t perform that action at this time.