• Anonymous
  • Login
  • Register



XPages Multi Select Dialog Control - Feature Request: Allow choice of @DbLookup or @DbColumn to populate picklist


To do above I added a "key" string and "type" combobox property (choices: @DbLookup, @DbColumn) to the ccMultiSelectDialog control, then hacked away at the repeat control's Javascript thusly:
//May need to expand for also incoming Array etc
//However API allows manual creation/insertion

var thisDB=@DbName();

if(compositeData.serverName!="" && compositeData.serverName!=null){
thisDB[0]=compositeData.serverName;
}
if(compositeData.dbName!="" && compositeData.dbName!=null){
thisDB[1]=compositeData.dbName;
}

if(compositeData.viewName!=""){
if(compositeData.type!="" && compositeData.type!=null){
if(compositeData.type=="@DbLookup" && compositeData.key!="" && compositeData.key!=null){
return @Unique(@Explode(@DbLookup(thisDB,compositeData.viewName,compositeData.key,compositeData.column),","));}
else{
return @Unique(@Explode(@DbColumn(thisDB,compositeData.viewName,compositeData.column),","));}
}
else{
return @Unique(@Explode(@DbColumn(thisDB,compositeData.viewName,compositeData.column),","));}
}
else{
return "";
}

It works, however is not very elegant. I'm sure you can devise something much better.

Also, it would be a nice addition to handle the situation of no values retrieved from the @DbColumn/@DbLookup.

Thanks for the control, Steve !! -- I'd been hunting for something just like this.



Taken Actions by Owners

No actions have been taken yet.


In this field you can enter the actual request.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.
In this field owners can describe what they have done or want to do.

You can use the rich text editor for rich text formating. You can also enter HTML to embed objects, e.g. to embed a YouTube video or a screenshot of the project. In this case use '[' and ']' to mark the passthrough HTML as such.

Please note that the first time you use the new UI your description is converted from rich text to MIME. You might want to copy and paste the raw plain text from the old UI in the new UI so that you don't loose information.