How to only get category from a categorized view using @picklist?

HCL Domino Domino Forum
1

Hi,I have a categoried view with the first column sorting with categorized, now on my form, I have a button using @picklist to only get the categories from the first column, after I got one or more categories, then load the selected categories to a Category field on the form.

Anybody has any solution how to do it? I just can not only show the unique categories on the view of picklist window from frist place.

Thanks a lot for any help,

2

Subject: How to only get category from a categorized view using @picklist?

if you only want to display catogories in the picklist why do you use @picklist?

You can use a listbox (@prompt) with multiple selection enabled. Use @unique and @dbcolumn to get only unique values from the category column of the view and display them in the listbox.

BN

3

Subject: RE: How to only get category from a categorized view using @picklist?

Hi Basir,Thanks a lot for help,

Yes, using @dbcolumn with @unique in a combobox solves the problem, but the the lookup view must select the option of “Categorized in the flat version after R5” property in order to show all categories and sub-categories.

Thanks again,