We have upgraded our dev environment to 2.2.3 from 2.0.3. After this upgradation we are seeing the Descriptive age elements have moved from left to right position.
Example: Its behaving as the same as below.
Had anyone faced this issue.
Normally will a datatype and it's format be interpreted from the first record of this field and if there are changes (per different sorting or filtering or other script-changes) it could be that the interpretation is different then before. Possible is also that qv had changed the functionalities by the interpretation - maybe there is a note within the release notes.
I think I would load these field in this way:
dual(num(keepchar(AGE, '0123456789')) & '+', num(keepchar(AGE, '0123456789'))) as AGE
but you couldn't do this directly within a SQL statement - you will need a preceeding load or a resident load for it.
Edit: with your new details I wouldn't do the dual() else I would load this field with text().
You can always fix the alignment of a particular field from the document properties. This would change the alignment for Multibox and List box throughout the application
Select Left for both Text and Numbers and that would give you left oriented field.