Help Me Please in my report

Ahmed Alnasasrah on July 28, 2010

Hi every body i want to create a new report & i hope to help me thats report give me a multi table like thats :

- 1st Table contains DataBase and user and all information about my database informations

- 2nd Table contains all model Name and Type(Value added chain,OC,...) And Description

- 3rd Table Contains all Objects Name and Type (Function,Event .....) and Description

- 4th Table Contains The Graph of My Project (Process Chart or Diagram )

=== Finaly i hope to add Header and Footer with my logo

===and help me to modify my table to add new attribute

regards.

Tags: #arisreportscripting; #tutorial

Bookmark

Notify Moderator

10 Replies

Eva Klein on July 28, 2010 - 13:26

Hi,

check out the ARIS scripting tutorials, here you can find the answer of the most of your questions:-).

Regards,

Eva

or register to reply.

Notify Moderator

Ahmed Alnasasrah Author on July 28, 2010 - 13:36

thanks Ms. Eva Klein but i am checking it before and i am try to create it and i am faild on it

if u can help more

this my code >>>>

    var oOutput = Context.createOutputObject();     // Output object
    var nLocale = Context.getSelectedLanguage();    // Selected database language
    //===============logo======

    //=========================
    //=======Information Table===================================================================
   
	oOutput.OutputLn("Report Test", "Arial", 40, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0);
    oOutput.OutputLn("Jordan Islamic Bank", "Arial", 20, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0);
   
    //===============================================================================
    //Build Table
    //ROW +++++ Header Of Table
    oOutput.BeginTable(100, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0);        
    oOutput.TableRow();  
    oOutput.TableCell("Model name", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    oOutput.TableCell("Object name", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    oOutput.TableCell("Id", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    oOutput.TableCell("Description", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    //=================================================
    oOutput.TableCell("New", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    oOutput.TableCell("Object Type", 15, "Arial", 10, Constants.C_BLACK, Constants.C_LIGHT_YELLOW, 0, Constants.FMT_BOLD | Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
     
    var aModels = ArisData.getSelectedModels();     // Array of selected models
    for (var i = 0; i < aModels.length; i++) {          
        var oModel = aModels[i];                    // Current model
        var sModelName = oModel.Name(nLocale);      // Name of current model
        var sModelID = getAttributeValue(oModel, Constants.AT_ID);      // ID of current model
        var sModelDesc = getAttributeValue(oModel, Constants.AT_DESC);  // Description of current model  
       
        oOutput.TableRow();  
        oOutput.TableCell(sModelName, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        oOutput.TableCell("", 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        oOutput.TableCell(sModelID, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        oOutput.TableCell(sModelDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        //======================
        oOutput.TableCell(sModelDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        oOutput.TableCell(sModelDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
        
        //=========================
        
        var aObjDefs = oModel.ObjDefList();         // All object definitions that have occurrences in the model
        for (var j = 0; j < aObjDefs.length; j++) {          
            var oObjDef = aObjDefs[j];              // Current object definition
            var sObjName = oObjDef.Name(nLocale);   // Name of current object
            var sObjID = getAttributeValue(oObjDef, Constants.AT_ID);       // ID of current object
            var sObjDesc = getAttributeValue(oObjDef, Constants.AT_DESC);   // Description of current object  
           // var sObjtype = getAttributeValue(oObjDef, Constants.AT_DESC);
            
            oOutput.TableRow();  
            oOutput.TableCell("", 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            oOutput.TableCell(sObjName, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            oOutput.TableCell(sObjID, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            oOutput.TableCell(sObjDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            //====================
            oOutput.TableCell(sObjDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            oOutput.TableCell(sObjDesc, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
            //====================================
     
        }  
    }
    oOutput.EndTable("", 100, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);
    oOutput.WriteReport();
     
    function getAttributeValue(oItem, nAttrType) {
        var oAttr = oItem.Attribute(nAttrType, nLocale);    // Attribute with the specified type number in the specified language
        var sAttrValue = oAttr.getValue();                  // Content of the attribute
        
        return sAttrValue;
    }

or register to reply.

Notify Moderator

Ahmed Alnasasrah Author on July 28, 2010 - 13:40

if any body have a tutorial in oracle BPM Suite Script (website/pdf/-----anything)

or register to reply.

Notify Moderator

Eva Klein on July 28, 2010 - 14:02

Your report has at the moment the output of one table. But if I understand you in your first post correctly you want to have for every step an own table?

or register to reply.

Notify Moderator

Ahmed Alnasasrah Author on July 28, 2010 - 16:23

yah but i cant add new attribute for my model or object like ... mmm... object type for example and one table not a realy problem but the header and footer thats other a real problem

or register to reply.

Notify Moderator

Eva Klein on July 29, 2010 - 07:32

To add a new attribute for example the name of the model type you have to call the method "Type()":

 var sModelType = oModel.Type();

The method returns you the model name as a string. Then you must only fill in the cell of your table with the new information:

 oOutput.TableCell(sModelType, 15, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, 0, Constants.FMT_LEFT | Constants.FMT_VTOP, 0);

I hope this helps you:-)

or register to reply.

Notify Moderator

Ahmed Alnasasrah Author on July 29, 2010 - 08:38

thanks Eva .

i'am added to my table the model type col. and that's very nice ; but now i hope to help me in :-

- get the object type (event,function,......)

- get model and function path

- get group name and path.

regards :)

or register to reply.

Notify Moderator

Eva Klein on July 29, 2010 - 08:45

You get the name of the object type in the same way like the model type:-)

var sObjType = oObjDef.Type();          //type of current object

Regards, Eva

or register to reply.

Notify Moderator

Ahmed Alnasasrah Author on July 29, 2010 - 09:00

that's ok and i'am try it

and now

- get model and function path

- get group name and path.

:) ia'm vary thankful to u

or register to reply.

Notify Moderator

Baglan Beisenov on June 17, 2014 - 15:37

Hi Eva Klein.

Thank you for your help.

I want to ask you about how to getattibutevalue or constant of "remark and example"

I have all other attribute name

var sObjID = getAttributeValue(ocurrentobjdef1, Constants.AT_ID); ID of current object var sObjDesc = getAttributeValue(ocurrentobjdef1, Constants.AT_DESC); var sObjCreator = getAttributeValue(ocurrentobjdef1, Constants.AT_CREATOR); var sObjLast_Change = getAttributeValue(ocurrentobjdef1, Constants.AT_LAST_CHNG_2);

var sObjRemExample = getAttributeValue(ocurrentobjdef1, Constants.????????????); <------ Here

var sObjTimeOfGeneration = getAttributeValue(ocurrentobjdef1, Constants.AT_CREAT_TIME_STMP); var sObjLast_User = getAttributeValue(ocurrentobjdef1, Constants.AT_LUSER); Could you please help me with this?

or register to reply.

Notify Moderator

Help Me Please in my report

10 Replies

var sObjRemExample = getAttributeValue(ocurrentobjdef1, Constants.????????????); <------ Here

ARIS Roadshow 2025 in Crystal City

PzM Summit Austria

ARIS Roadshow 2025 in Amsterdam

BPM Summit