Question

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

Forum|Forum|2 years ago
September 23, 2023
12 replies
0 views

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

shikhat

Hi , Not sure exactly how configuration is done but maybe you can try to take PV of type map (multiple) and try to save the values, If Input is of map type and pv integer , you might face type mismatch issue

R

rajeshkumarj0001Author

Hi Shikha, 1st of all, thanks for your response.
Actually map contains multiple keys and each key refers to different kind of values. One of these keys refers to these Ids which are list of number interger type

stefanhelzle0001

Brainy

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.

R

rajeshkumarj0001Author

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.

stefanhelzle0001

Brainy

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.