searching/filtering objects

New to the forum, so apologies of this has been answered before.  Is there a way to filter by a particular owner of objects in the object tree?  For example, if I only want to show objects own by dbo, and then that would negate me prefixing my searches for an object name with dbo.

Parents Reply
  • Sybase ASE,  I've dabbled with it, and I'm not quite getting it right.  As far as I can see, I think I'd need to define 2 profiles. What I would like is one for me, which will only list DBO owned objects (tables, views etc). Then a general one, which would have the details for all users.  Does that sound about right, and doable?

Children
  • Yes, you will need two connections files as stated.  The with the filter you will need add the filters for "ALL" the object types.  See the screenshot attached

  • Hi Lisa, Thanks again. I'm getting close.  If I filter as you suggest I can restrict everything to just dbo.* which is fine.  However, ideally I'd like the owner (dbo) to be at the end of the object name (dbo) or not seen at all.  That way I can search for objects by name only without worrying about prefixing with the owner.

    I tried playing about with schema groupings and Display, but when I do that I lose all my objects.  I tried filter with a mask of +*(dbo) but that didn't work.  I really appreciate your help getting me this far.

  • Hello,

    Can you please send me a screenshot of your object tree with the objects you are referring to so I can create a test scenario to match.  

    Thanks!

    Lisa

  • Hopefully you can see that.  As you can see the view names are prefixed with dbo.

    Which is great, I want only those, but I'd prefer them without the prefix to allow me to search on name only.

    Thanks again for your help.

  • Hello,

    Please try this.  First go to Server Properties Advanced and set the Display and Schema Server grouped as indicated in the first Advanced Screenshot.  Then go to Filters and take off the filters, as indicated in the second screenshot filters display screenshot.  Then in the Third screenshot Tree display you should see the results that just give the name and not the schema.name combination.