I am building a URL in LPL, which is using a concatenation of a fixed string with 5 parameter references. I am having issues with 2 out of 5: for one of the periods, I am getting {2}, rather than 2, is there a command to CHAR, or change this field to a character? Secondly, the other field is a numeric representation of a status, which I need to translate into another value, almost like with a CASE statement in SQL: when field A is 1, make it N, and so forth (it happens to be the JE status). What are my options for 1 and 2? I assume having a customized business class and doing the translation for 2 would work, but it would mean multiple pairings for a single value, which I assume is not allowed. Like, 1 cannot mean NORMAL and N, in the same class. Can I add a derived field that inherits the value from status, and has a different set of values for states?
