How do you select drop-down menu values containing £ symbol (using SIL / Powerscripts)

Question

Hi.

I'm trying to get SIL Powerscripts to update a Jira customfield to specific value from single select drop-down menu which includes "£" symbol ...

e.g. customfield_12201 = "£0" - but this doesn't seem to work.

How do you need to encode the £ symbol to match against value held (or worst case always pick the first first real available value from the menu options - i.e. ignoring the default "none") ???

Wouter Bruinings · Answer

Ah okay.

Have you tried: https://confluence.cprime.io/display/DBCF/FAQ#FAQ-Iexperiencedifficultiesusingspecialcharacters ?

regards,

Wouter

jira-admins@weatherbys.co.uk · Answer

Hi Wouter - thanks for the reply.

The select list does definitely contain "£0" as one of its options (together with a few others values £50, £75, etc).

However, customfield doesn't want to update to these string values - assume the £ symbol is encoded somehow when stored in database?

Whenever you save/reopen the SIL script the £ symbol is replaced by "[]" a broken character (plus, the zero).

Any ideas?

Wouter Bruinings · Answer

Hi Tim,

If £0 is not a value in your select list, that might be the reason it does not update.

Are you trying to replace the value £ by  £0? If yes, wouldn't it be an option to simply replace the £ by £0 in the select list?

Kind regards,

Wouter