Age element which has + sign moved from left to right position

[Chanty4u]

Hi All,

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.

18+

65+

          18+

          65+

Had anyone faced this issue.

[Kushal_Chawda]

I think it's downgraded.  How this is calculated?

[Chanty4u]

Hi Kushal,

This is upgraded from 2.0.3 to 2.2.3 version

[Kushal_Chawda]

Sorry misunderstood in hurry. So how it is calculated?

[marcus_sommer]

It looked that the datatype changed from string to numeric. Have you any issue with this change?

- Marcus

[Chanty4u]

Hi Kushal,

It is coming from a table which has a datatype varchar(50).

[Chanty4u]

Few of the elements as string and appear on the left side in the filter pane. And other few are appearing on the right side.These have '+' sign.

[Chanty4u]

Please find the screen shots.

1st screen shot is before upgradation

2nd screen shot is after upgradation

[marcus_sommer]

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().

- Marcus

[sunny_talwar]

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.