Hi All, I am new to ARIS report, I generated a report for IE data model and the part of report shows as following:
Form Field |
Content Field |
Membership Number |
LDA FundMbrNumber |
Date of Birth |
LDA BirthDate |
Email Address |
LDA Email |
Street Address |
LDA AddressLine1 |
Postcode |
LDA Postcode |
Suburb/Town |
LDA Suburb |
First Name |
LDA GivenName |
Miss/Ms/Mrs/Mr |
LDA NameTitle |
Mobile Phone |
LDA MobileContactNumber |
Surname |
LDA FamilyName |
Telephone (Home) |
LDA HomeContactNumber |
Gender M/F |
LDA Sex |
Membership Category |
LDA FundMbrCategory |
State |
LDA State |
In the model, the order for first column (Form Field) is
Membership Category
Membership Number
Miss/Ms/Mrs/Mr
Date of Birth
Gender M/F
First Name
Surname
Telephone(Home)
Mobile Phone
Email Address
Street Address
Suburb/Town
State
Postcode
We would like to get the report with same order listed in the models. Anyone can advise how to write the code to sort this column?
Thanks in advance!
Hi Jim,
I believe understand you. Try this script which sorts functions occurences by Y position in model:
var g_nLoc = Context.getSelectedLanguage(); var oModels = ArisData.getSelectedModels(); var oOccs = oModels[0].ObjOccListFilter(Constants.OT_FUNC); oOccs = ArisData.sort(oOccs, Constants.SORT_Y, g_nLoc); for (var o = 0; o < oOccs.length; o++){ Dialogs.MsgBox(oOccs[o].ObjDef().Name(g_nLoc) + '\n' + oOccs[o].Y()); }