MetaDataFilterItem - Can this filter fields? E.g I have a table [User] with a field [password] which I wish to hide.

Answered

Comments

3 comments

  • Hello,

    Please replace your code with the following:

    MetadataFilterItem metaFilter;
    metaFilter = qbQuery.MetadataLoadingOptions.MetadataFilter.Add();
    metaFilter.Exclude = true;
    metaFilter.Object = "User";
    metaFilter.Field = "Password";

    metaFilter.CaseSensitive = false;
    0
    Comment actions Permalink
  • If you want to hide the "Password" field from all tables, comment out the "metaFilter.Object = ..." line. The metaFilter.ObjectTypes property works for database objects (Tables, Views, Procedures, Synonyms).
    0
    Comment actions Permalink
  • Avatar
    Acusoft Software
    Thank you, that works a treat. 

    0
    Comment actions Permalink

Please sign in to leave a comment.