Hello,
is there a way to find all reports that use a certain column name? We need to change a calculation for all reports that use column "abc", don't want to open every single report and look in generated sql.
Thanks!
fn4029
The tools menu in Framework Manager has an option to find report dependencies. Select the column in question and then use that tool to find reports referencing it.
The other option is if you have GO! Search, which has the ability to allow searching based on metadata or even data.
SDK can do this as well.
Not exactly what your looking for but the code could be modified from this base sample.
https://www-304.ibm.com/support/docview.wss?uid=swg21374788
I could have sworn I came across a sample that did what you are looking for. I'll edit my post if I find it.
Edit:
Could probably use the column code from thsi one to modify the original sample I posted.
https://www-304.ibm.com/support/docview.wss?uid=swg21373027
Thanks guys! Really appreciate the answers! I will investigate all 3 methods.
fn4029
I think you can search the columns in 'Package.xml' file as well.
Hi
Another way of doing this is to search through the obj tables in the content store. I think CMOBJPROPS7 has a field called spec which si the full xml spec of all reports. You can search this for a particular string (i.e. column name). You will need to join this to CMOBJNAMES on cmid to get the name of the report. I haven't found a way of getting the location of the report but when you have a list of the reports that have the column you're looking for you can search in the portal.
I think this only looks at public folders, anything in a users 'My Folders' won't be covered. Obviously as this is searching the xml spec it isn't very fast but I think it is more accurate than the report dependencies function in FM (unless that has been improved in C10)