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

[jira-admins@weatherbys.co.uk]

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]

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

[jira-admins@weatherbys.co.uk]

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]

Ah okay. 

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

regards,

Wouter