How can i generate an Excel report on folder/Database level.

Posted by Anjana Nehra

Posted on Mon, 01/23/2012 - 10:26 in Professional ARIS

I want to generate a report from a folder level or databse level , I know how to generate report from a model and i want to get all roles in this report , which are available in this database. Please give your valuable comments. Thanks

15.5k

by karthikeyan balasubramanian

Posted on Mon, 01/23/2012 - 13:29

Hi Anjana,

When creating a new report, Select the context as "Database".

//In code, define the below line globally for running the report on the selected database,

var oDB = ArisData.getActiveDatabase();

//Inside your search function , find the total objects ,array length and print the output,

var objs=oDB.Find(Constants.SEARCH_OBJDEF,43); // 43 is the type num of your search object.

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

Print the objs[i].Name(g_nloc) for Search object.

Hope this information will help you to design the required database report

by Anjana Nehra Author

Posted on Tue, 01/24/2012 - 09:57

Hi Karthikeyan,

Thanks but its not working, the below mention code is for model and its working fine but i have tried for group its not working showing error. In line 7 .model is a symbol name, what does it mean??

1.function getModelSelection() {

  2. var oSelectedModels = ArisData.getSelectedModels();

   3. if (oSelectedModels.length == 0) {



      4. var oSelectedObjOccs = ArisData.getSelectedObjOccs();

        5. if (oSelectedObjOccs.length > 0) {

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

           7.      oSelectedModels.push(oSelectedObjOccs[i].Model());

        8.     }

          9. oSelectedModels = ArisData.Unique(oSelectedModels);

       10. }

    11. }

    return oSelectedModels;

}

by karthikeyan balasubramanian

Posted on Tue, 01/24/2012 - 10:35

Hi Anjana,

Try using the below basic code to list all the OU type object from the database.Create a new report with context as "Database" and use the below code,

// Code to list all OU object in database

var oDB = ArisData.getActiveDatabase();

var g_outfile=null;

var g_nloc=Context.getSelectedLanguage();

function main()

{

    var objs=oDB.Find(Constants.SEARCH_OBJDEF,43);

    var g_ooutfile = Context.createOutputObject();

    g_ooutfile.DefineF("REPORT2", getString("TEXT6"), 14, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0, 21, 0, 0, 0, 1);

    g_ooutfile.BeginTable(100, Constants.C_GREY_80_PERCENT, - 1, 8, 0);

    g_ooutfile.TableRow();

    g_ooutfile.TableCell("Name", 15, getString("TEXT1"), 9, 0, getTableCellColor_Head(), 0, 145, 0);

    g_ooutfile.TableCell("Type", 15, getString("TEXT1"), 9, 0, getTableCellColor_Head(), 0, 145, 0);

    g_ooutfile.TableCell("Group", 15, getString("TEXT1"), 9, 0, getTableCellColor_Head(), 0, 145, 0);

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

{

            g_ooutfile.TableRow();

            g_ooutfile.TableCell(objs[i].Name(g_nloc), 15, getString("TEXT1"), 10, 0, Constants.C_WHITE, 0, 136, 0);

            g_ooutfile.TableCell(objs[i].Type(), 15, getString("TEXT1"), 10, 0, Constants.C_WHITE, 0, 136, 0);

            g_ooutfile.TableCell(objs[i].Group().Path(g_nloc), 15, getString("TEXT1"), 10, 0, Constants.C_WHITE, 0, 136, 0);

    }

    g_ooutfile.EndTable("", 250, getString("TEXT1"), 12, 0, - 1, 0, 136, 0);

    g_ooutfile.WriteReport();

}

main()