Format questions on filters in MetadataStructure
I am able to set a filter using this:
MetadataFilterItem mfi = queryBuilder.MetadataLoadingOptions.MetadataFilter.Add();
mfi.ObjectTypes = MetadataType.Table;
mfi.Object = "%foo%";
queryBuilder.MetadataStructure.MetadataFilter = new MetadataFilter() { mfi };
queryBuilder.MetadataStructure.Refresh();
Although the result works, I would like to make some improvements:
1) How can I display the filter text ("%foo%") in the filter box above the tree?
2) The tables that pass the filter are expanded. How can I collapse them?
3) Once the filter is applied I see the matching tables and then the main DB node which still contains same tables. Is there a way to display just the above ones or just the ones below ?
Additionally and OT: is there a way to format code with a fixed width font when posting to this forum? I looked but could not find anything related to this. I know that I can write my post as HTML code, but I was looking for a quicker way, if at all available.
Thank you,
SM
Hello, Simon.
1. There is no way to display to end-user metadata filters that were defined programmatically.
2. We'll investigate this problem and will fix it if it's a bug in the next build. ("The tables that pass the filter are expanded."). Anyway, we'll let you know about results.
3. Please remove the following line from your code to get rid of the main DB node after search results:
queryBuilder.MetadataStructure.MetadataFilter = new MetadataFilter() { mfi };