Devart Forums

I'm using TMyMetaData with options columns to show all my tables with columns and definitions. I'm using a filter to select one schema (database), because only one database I want to see. But the filter doesn't work. I even created IndexFieldNames, but it doesn't help.

So how do I filter my data?

If you want to use the Filter property you should set the TMyMetaData.Filtered property to True, like this: Also you can use the Restrictions property to provide one or more conditions restricting the list of objects to be described. This is a better way, because filtering is executed on server.
For example:

I set my filter in the properties in TMyMetaData en set the Filtered to true with no results. But I didn't try the Restrictions, because the help didn't say how to use it.
But I'm going to try it.

It works, thanks.

Another question about restrictions. Is it also possible to excludes things like tables?

You can specify the table to show information for, like this: You can use the TMyMetaData.GetRestrictions method to find out which restrictions are applicable to a certain MetaDataKind.