xpages adding @formula in list

3
votes

There is a client notes application and in its main form, there is a dialogList having this formula: ( C21331:312321C is, actually, the replica ID, in this example it's just a random number )

_view := "vw1";
_vieww :="vw1";



x :=@Sort(@Unique ( @DbColumn( "" : "NoCache" ; C21331:312321C; _view; 1 ) );[Ascending]);
y :=@Unique ( @DbColumn( "" : "NoCache" ; @DbName ; _vieww ; 1));

y:x

How to use thee above code in my combobox computed values? I tried:

    var _view = "vw1";
    var _vieww= "vw2"; 

    db = new Array(@Sort(@Unique ( @DbColumn( "" : "NoCache" , C21331:312321C, _view, 1 ) );[Ascending]);

    db1 = new Array(@Unique ( @DbColumn( "" : "NoCache" ; @DbName ; _vieww ; 1)));

   db:db1

How can I achieve this functionalty in xpages? Thanks for your time.

1
xpages

1 Answers

4
votes

Use .sort() to sort an array (@Sort is not implemented in SSJS) and .concat() to concatenate two arrays or an array and a string:

var a = [].concat(@Unique(@DbColumn( ... ))).sort();
var b = @Unique(@DbColumn( ... ));
return a.concat(b);