and more in a single search tool across platforms. Read the announcement here. |
12/21/2023 08:58 PM
Hi,
we have dynamic attribute(company) created as multiselect. In ARS form, it showing that attribute as drop down.
Requirement: Company attribute dropdown values wanted to show up as check box in the drop box so that user can select multiple companies or all from the drop down.
Can you advise how to achieve.
Please note all companies are created as entitlement type
12/21/2023 11:21 PM
Please share query and form screenshot
12/22/2023 06:58 AM
Thank you for the response. Highlighted in yellow color where I am looking for check box .
Dynamic Attribute-
select CONCAT(c1.customproperty1, ' : ',REPLACE(c1.Description,',',';')) as ID from customer c, users u ,customer c1 where u.userkey=${requestee} and u.jobcode=c.customproperty20 and c.customerkey = c1.parentcustomer and u.employeetype = 'employee' and c1.customproperty19 in('Open','Pre-Opening') and c1.customproperty1 not in ( '.' , '-','') and c1.customproperty1 is not null UNION select CONCAT(c1.customproperty1, ' : ',REPLACE(c1.Description,',',';')) as ID from customer c, users u , customer c1 where u.userkey=${requestee} and u.jobcode=c.customproperty21 and c.customerkey = c1.parentcustomer and u.employeetype = 'employee' and c1.customproperty19 in('Open','Pre-Opening') and c1.customproperty1 not in ( '.' , '-','') and c1.customproperty1 is not null UNION select CONCAT(c1.customproperty1, ' : ',REPLACE(c1.Description,',',';')) as ID from customer c, users u ,customer c1 where u.userkey=${requestee} and u.jobcode=c.customproperty20 and c.customproperty2 = c1.customproperty17 and c.customproperty3 in ('L', 'M', 'O') and u.employeetype = 'owner' and c1.customproperty19 in('Open','Pre-Opening') and c1.customproperty1 not in ( '.' , '-','') and c1.customproperty1 is not null UNION select CONCAT(c1.customproperty1, ' : ',REPLACE(c1.Description,',',';')) as ID from customer c, users u , customer c1 where u.userkey=${requestee} and u.jobcode=c.customproperty21 and c.customproperty3 in ('L', 'M', 'O') and c.customproperty2 = c1.customproperty17 and u.employeetype = 'owner' and c1.customproperty19 in('Open','Pre-Opening') and c1.customproperty1 not in ( '.' , '-','') and c1.customproperty1 is not null UNION select CONCAT(c.customproperty1, ' : ',REPLACE(c.Description,',',';')) as ID from customer c, users u where u.userkey=${requestee} and c.customproperty3 in ('L', 'M', 'O') and u.employeetype in ('Associate', 'Consultant' ) and c.customproperty1 not in ( '.' , '-', '')and c.customproperty1 is not null and c.customproperty19 in('Open','Pre-Opening')
12/22/2023 10:12 AM
so based on TakeCustomer Property Checklist - Company Entitlement type will be selected ? if yes share entitlement type configuration
01/09/2024 02:26 PM
Pls ignore the ent type choice as it is missing few conditions.
We have above query with that dynamic attribute configurations, we can see below drop down with multi select.
Requirement: Need check box for each item (with the option single item select and select all check box)
12/22/2023 11:19 AM
Yes. entitlement type is standard.
12/22/2023 11:29 AM
12/26/2023 05:58 PM
You need to store dynamic attribute value in entitlements customproperty
entitlement type- Requestable entitlements in ARS config - you need to add filter
ev.customproperty1 IN (${DANAME})
01/09/2024 02:54 PM
Pls ignore the ent type choice as it is missing few conditions.
We have above query with that dynamic attribute configurations, we can see below drop down with multi select.
Requirement: Need check box for each item (with the option single item select and select all check box)
01/09/2024 06:06 PM
You can use request option as table