delete choice lists other than english language

[ChaimaA]

Hello,

how can we remove all choice list associated to the install_status field which are not defined as english. The goal is to keep only english 

Regards 

[SANDEEP DUTTA]

Hi @ChaimaA ,

If a requirement is to return only English related choice for the entire instance without customizing other configurations to query only English.

we can achieve this by the before-query business rule

- Create a business rule on the 'sys_choice' table
- Enable checkbox 'Query'
- set with least order as '1' - to run this business rule first for sys_choice
- No condition needed
- The below script restricts only choices with the English language to return on an instance for everyone. This way any script using sys_choice can query only English language choices and other scripts don't require modifications.

(function executeRule(current, previous /*null when async*/) {

current.addEncodedQuery('languageSTARTSWITHen');

})(current, previous);

From KB: How to restrict only to show specific language choices on instance - Support and Troubleshooting

[ChaimaA]

Hello Sandeep

It 'dosen't work , when i unable checkbow query , all query remove .

[SANDEEP DUTTA]

Hi @ChaimaA ,

This field is not available once you open the form of the business rule, once you click on "Advanced" the "Query" field opens up :

[ChaimaA]

When I save ,it dsappear