Creating agent with selection input

I am creating an agent to fit in this workflow:1. Select documents

  1. Run agent

2.1 Select multiple keywords from a list based on existing keywords.

2.2 Update selected documents with selected keywords.

Is there an easy way to get data from a categorized view and select from these? My view only has one column, Keyword, and that is categorized.

If I open my normal input field used in form it seems so easy, just a Dialog box with “@DbColumn(”“; “”; “(Keywords)”; 1)”.

I have tried the following solutions:

  • PickListStrings, It can taka a database view as input, although it seems like I get one row for each entry in view, so it’s showing the categories ok, but it has a lot of empty rows as well.

  • Prompt, This one can take a list as input and then select from it, is there an easy way of extracting all unique keywords and use them as input? I would prefer just to enter a dbcolumn in some way.

/Magnus

Subject: Creating agent with selection input

Can you not use the @DBColumn lookup in the prompt?, e.g.

list := @Unique(@Trim(@DbColumn(“”; “”; “(Keywords)”; 1)));

@Prompt([OKCANCELLISTMULT]; “Select Keyword/s”; “Select one or more keywords.”; “”; list)

Should work unless I’m missing something

Cheers

Peter