Option to include/exclude comments in search
Here is an example of a search of what is returned if I search the following text "acftfltinfo"
FROM Test.DBO.VWFLTINFO3 (NOLOCK)
-- From acftfltinfo Removed
where SchdDepDate>= @FromDate
But this code has been updated to the new view, If I was able to exclude comment text out of my search then this text would not return. I would I
to exclude this object because I do not care about it.
Also for the most part the view dependencies does not work for all case since it will only look in the current database and also does not work most of the time. It will miss which objects that are depend on [VWFLTINFO3] and bring back nothing becuase it is in a different datatbase. But Red-Gate Search works great. I also use the Red-Gate SQL Doc also for this process. Also with the Search will also show the code and I can click on the item and it brings the item into a new window for changes.
Also lets just say I'm looking for the text 'DELETE ITEM' in all databases.
If that text was in a comment block it will find that object.
For example would be returned, which is ok and good.
WHERE item = 'DELETE ITEM'
Object that I would like to exclude:
But search will still return this code also.
WHERE item = 'WORK FOUND' ----'DELETE ITEM'
I know there are a lot of suggesting covering a lot of topics, but the community asks about the status of a suggestion more than once, and two+ years go by without any response from Redgate, you have to wonder if they are even reading these or care about our feedback.
Is this going to be implemented at some point in the future? Is it under consideration? It was first posted over 6 years ago. It has over 300 votes. I would think that would deserve some kind of comment from Redgate.
Why has this still not been implemented? Is there an ETA?
Matt Bolton commented
Sometimes I want to search within comments only, so a selection of searching within:
* Excluding Comments
* Comments only
would be great.
any ETA when this will be done?
Ludvig Derning commented
Why not add regex(regular expression search).
This could then be achieved as a sideffect.
Arge M commented
I also would like to be able to identify easier/ filter the results that are part of commented code.