Can I use a count(*) function in a dm_query object?

I have a user that just wants a simple count of the number of documents we're pushing to our intranet, which we do based on certain parameters, such as security level. He's going to want to monitor it, so basically once a week or whatever, he wants to check it.

I'm trying to figure out a simple way for him to get that number without me having to run the DQL for him or teach him how to access DQL and run it himself. I thought I could just create a dm_query object that he could access through Webtop and it would give him the number, but it doesn't seem to work. I can get a list of the attributes that way, but when I use the count function I just get a result screen with a blank document object. If I try to open it I get an error.

Is there a way to do this? I hate to have to write a whole Crystal Report for something so basic.

Find more posts tagged with

Comments

christopher.imes

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility. Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right. Then search for: "Documentum" and select the very first result that appears. This will relocate it to the Developer Network space of the Documentum community.

Documentum

msroth

Bummer that dm_query and dm_smart_list won't support the count(*) function. I'm not sure they did in the Desktop Client either. Off the top of my head I would suggest writing a simple job that creates the report or emails the results once a week. You could also create a simple WDK component to do the same, that way your user can pick something from a menu and have the results in real-time.

SarmaP

I agree with Scott's idea of writing a small reporting component that user can invoke on-demand.

I implemented a similar reporting functionality where-in user supervisors (users in a specific role group) will be able to see this menu item and when clicked, it opens a window with lot of reporting options (date ranges, user selection,group selection etc). Once the criteria is selected, a dynamic report is generated and shown on screen with an option to export/email.

I think this process lets your users to generate stats for whatever range they are looking for, not only for previous week or day.

It takes a little effort but worth it.

-Sarma.

elboukhari

HI,

in addition to the previous suggestion & depending on the user background you can just redirect your user to read the report of the dm_StateOfDocbase
please note that this job run by default everyday at 20h45 unless it has bees disabled

Otman

jklawrence

Thanks to everyone for your suggestions.

Julien.Fontaine

May be you also should optimize your request :

select count(r_object_id) from dm_document !