Is there a way to select multiple values in a List of Values (LOV) field in IFS Cloud—not a Lookup or Enumeration field—so that the selected values are saved in the format Value1;Value2;Value3, and stored as a single string?
I'm looking for a solution where users can choose more than one option from a LOV, and have the values saved as a semicolon-separated string. Any guidance on whether this is possible would be appreciated.
Thank you in advance.
Yes, it is possible to do that. Here is an example of how it may look like:
However you should be a bit careful about performance. If you have a need to join with that field or find all records which has one of the values set it will be hard to get good performance.
If you want to look at the example above it is from CRM module:
CrmCustomerHandling.projection:
It is the multiselect on the attribute in the entity definition that enables to select more than one:
attribute AccountType Lookup(CrmAccountType) {
fetch = "Crm_Cust_Info_API.Get_Account_Type_Db(customer_id)";
multiselect = =true];
}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.