System diagram procedures are currently included in the code coverage results about sqlcover HOT 3 OPEN

Hi @davidlyes,

SQLCover already has the ability to take a filter to exclude specific objects ("sp_.*diagram" would work for you) but there is nothing in the SQLTest ui to allow you to specify anything that can be passed to SQLCover.

I am a bit hesitant to add in specific filters because although you don't want to see these someone else might want to see them.

A half way measure might be to get SQLCover to look in a config file in a known place for additional filters, that way it will work with SQLTest and anywhere else.

So your options are:

1. Don't use the Redgate UI to generate your coverage reports
2. Ask Redgate to include the ability to add a filter as part of their UI
3. Wait for me to implement an additional config file for extra filters - to make sure people didn't get additional filters they didn't know about I would want these displayed on the output somehow so there are a few things to do here. (you would also need Redgate to use the updated version of the dll)

ed

from sqlcover.

Thanks for your quick feedback @GoEddie!

I will go back to RedGate to see if they would be able to implement filters into their UI, since it is something that is already supported by SQLCover.

from sqlcover.

Hi @davidlyes,

SQLCover already has the ability to take a filter to exclude specific objects ("sp_.*diagram" would work for you) but there is nothing in the SQLTest ui to allow you to specify anything that can be passed to SQLCover.

I am a bit hesitant to add in specific filters because although you don't want to see these someone else might want to see them.

A half way measure might be to get SQLCover to look in a config file in a known place for additional filters, that way it will work with SQLTest and anywhere else.

So your options are:

1. Don't use the Redgate UI to generate your coverage reports
2. Ask Redgate to include the ability to add a filter as part of their UI
3. Wait for me to implement an additional config file for extra filters - to make sure people didn't get additional filters they didn't know about I would want these displayed on the output somehow so there are a few things to do here. (you would also need Redgate to use the updated version of the dll)

ed

Hi Ed.
there is no documentation is provided how to filter stored procedures while calculating code coverage if we use SQLCover. it would be great if you show one example for this. thanks in advance.

from sqlcover.