JS

Hi,

I need to make a report for all changed models in the last 6 months.

It is easily possible to do it with a simple search with "Last change: Within the last 6 months".

 

But, what I am missing:

I would like to see when a model was initially created and who was the creater and the last user.

Also it would be nice to query for "free attributes".

 

Any ideas?

 

thx

by Rupesh Shrestha
Posted on Tue, 02/16/2010 - 22:38

John,

Have you tried using the reporting wizard. The reporting wizard will create the report you are after.

 

Regards,

Rupesh

0
by Volker Eckardt
Posted on Tue, 02/16/2010 - 23:29

In reply to by rupikshma

Hi John,

you should get such a list by utilizing the report wizard. All fields, including custom fields, are in the report wizard available.

Regarding your wish to see only models that have been updated within the previous 30 days, you need to code some JavaScript lines.

Let me quickly explain how to do it:

You have a JavaScript behind your report (right mouse click > Edit Code). Within this code you may have some loops whereas the loop around your models is important:

this usually starts with

// repetition of queried data:

for(var i=0; i<p_aModel1.length; i++) {

right behind you see some lines like

   p_output.TableRow()

   ....

   ....

and below a closing

}

What you need to do is now the following:

Add these lines right after the for loop:

// get today's date

var date = new Date();

// substitute the number of days you want

date.setDate(date.getDate() - 30);

// get the last change date

var lastChangeDate = new Date(p_aModel1[i].Attribute(Constants.AT_LAST_CHNG_2, nLocale).GetValue(false));



// validate if greater, and only then print it

if ( lastChangeDate > date ) {

now keep the code liks:

p_output.TableRow()

....

....

and add one more

}

for the "if", right in front of the existing }.

 

Just run your report now and you should have only models in it listed that have been changed within the previous  30 days.

Hope this covers your question. Let me know if it works for you!

Best Regards

Volker

 

0
by Volker Eckardt
Posted on Wed, 02/17/2010 - 13:18

In reply to by Ian

Hi,

The report wizard pops up automatically when you choose "New > Report" in one of the report groups, within the scripting area.

This wizard guides you along the main information about the report (name, level, criteria etc.).

The ouput is a WYSIWYG representation of your report, and you can add more objects as you require.

Hope this helps.

Regards, Volker

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock