Dialog list field, @DbColumn and aliases - FIXED

HCL Domino Domino Forum
1

Hard coded aliases for the selectable values in a dialog list work fine. For example.

Hardware Request | HW

Software Request | SW

Service Request | SVC

Is it possible to do this using @DbColumn? For example.

@DbColumn(“” : “”; “”; “vwemployeesbyid”; 2) | @DbColumn(“” : “”; “”; “vwemployeesbyid”; 1)

This would give a list of aliases like that below.

Bill Jones | 123456

Fred Smith | 654321

etc.

However, I get a formula error when I try this.

FIXED: You need to enclose the pipe in quotes and append as a string. The formula below works as intended. Its probably more efficient to make the value and alias a column in the view (same syntax) and reference that directly though.

@DbColumn(“” : “”; “”; “vwemployeesbyid”; 2) + “|” + @DbColumn(“” : “”; “”; “vwemployeesbyid”; 1)

2

Subject: Dialog list field, @DbColumn and aliases

Hi Andrew

It is very much achievable.

The reason why you are getting a formula error is because you are using “|” symbol as an OR operator.

You need to enclose it in quotes and use list/string concatenation:

@DbColumn(“” : “”; “”; “vwemployeesbyid”; 2) + “|” + @DbColumn(“” : “”; “”; “vwemployeesbyid”; 1)