Remove comma between digits of a number (123,456; 345,789)

I am querying data and getting all the desired data  from DB.

And Ids are one of them.
Now I need to move these data from expression rule to process model after doing required changes in the rule.

These Ids are like {123456, 345789, 567890, 120078}.


I stored them in map like map(id: {123456, 345789, 567890,120078}).


But when I am trying to extract these Ids from the map using indexing  and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}. 

Kindly help me to get my Ids as they are without these unnecessary commas

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    That is just the matter of visual representation in Appian. Your values are fine. And when you display values to the user, you can use the text() function to create your visual representation as required.

  • Hi Stefan, I really appreciate your answer.


    Actually I need to query data from another table using queryRecordType().

    And these Ids are used as filter values.

    Because of these comma, system is treating these numbers as 3 digit numbers instead of 6 digit number. So I am not getting  desired data from the table. So I need these Ids in their original condition

    I hope you get the issue now.


    Kidnly assist me.

  • 0
    Certified Lead Developer
    in reply to rajesh0001

    Where do you get these IDs from and what data type is that?

    The issue here is that I just have no idea what you are doing. It could be that you somewhere turn some numerical values into a list of strings or a single string.

    To be able to identify the issue, I need more details.

    When re-reading your sentence

    But when I am trying to extract these Ids from the map using indexing and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}.

    A PV of type list of integer is good. The visual representation is also good. This is just the way Appian visualises numbers in process monitoring.

    So my question is. Do you observe any actual issue? Or do you only wonder about the visual presentation of these number?

Reply
  • 0
    Certified Lead Developer
    in reply to rajesh0001

    Where do you get these IDs from and what data type is that?

    The issue here is that I just have no idea what you are doing. It could be that you somewhere turn some numerical values into a list of strings or a single string.

    To be able to identify the issue, I need more details.

    When re-reading your sentence

    But when I am trying to extract these Ids from the map using indexing and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}.

    A PV of type list of integer is good. The visual representation is also good. This is just the way Appian visualises numbers in process monitoring.

    So my question is. Do you observe any actual issue? Or do you only wonder about the visual presentation of these number?

Children