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.
Yes. Attached is a link to the help file. Let me know if you can see it. If not I will put a screenshot in the post.
Oh welcome by the way!
Thanks for the reply and the welcome Lisa, much appreciated. However, can I bother you for more info. You screenshot lead me part of the way. I've now got a sub-branch of users, which I found in the server properties [Advanced] tab. Under Object Folder, the properties Schema Grouping and Display. However, it looks nothing like the Object Search box you linked to. I know I should RTFM, but there is always so much to do! Your help would be appreciated and perhaps the time saved will allow me to RTFM
I also did not see your part about filtering in "tree" my bad. Yes in the Server properties, Advanced tab should help with that filtering on the tree. I am testing now. See below for the help.
Can you tell me what database you are using?
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?
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.
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.
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.
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.
LIsa, thanks for the valiant effort. The problem is, your solution is nice and tidy and simple in a server with limited number of users creating objects. I have over 400 users all with personally created objects, of which an infuriating number of them have names which come before dbo! If I switch on the schema folder grouping, I get all the users before dbo. I'm not sure which is worse!
I think where I have it just now is better than it was, and I really do appreciate your help getting me there. Unless of course you come up with something else. Thanks again for your help.
Powered by IDERA