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:
very easy to use:
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
