Could you please tell me the query..
one hash file is being used by how many jobs in a project.
thanks in advance
\
hash query
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Nobody answered since the post was marked as "resolved". This is not easy, since hashed files can be utilized by name or by path. If all references are by name or all uses of the hashed file are done by using the same metadata columns then one can search from within the tool. Otherwise a project export to a .dsx or .xml file and subsequent text search of the document might give the best results.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Another possibility is the 'List all files and tables' tool available on Chuck Smith's website. I adapted it to write to a database table so the results can be easily queried.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers