58
Views
14
Comments
Solved
String_Split display each record in the database as split value

Hi everybody,

I am a newbie in outsystems. I would like to ask something about string_split function, i am little confused in using it.

I am only getting one record, i cannot display all the records as split value, it only return one record value. I am retrieving the value of the Tour Highlights field, here's how it looks:


 I am only getting the last value. How could i be able to get all the value of the record and display it as split? I've read some post, that it is need to be done in logic, how can i do that? i'm sorry i'm not that familiar with outsystems yet. Can someone help me do it? better if you could give an example. 


Thank You. I hope someone could help.

Rank: #89
Solution

laurence De Ocampo wrote:

Tushar Panpaliya wrote:

Can you attach the oml for this. Will look into it and revert.

Hi Tushar ,

  This is the oml.


Hi laurence,

You are using String_Split function inside expression and expression is accept only text type data and string split return Text record list thats why you are getting this error .

Do One thing create a WebBlock and pass this list current  value in webblock as input parameter.

Use string split in web block and show this is here and use this WB in list record .

Find attched demo oml hope this will help you.


Regards

Rahul Sahu


StringSplitDemo.oml

Champion
Rank: #42

Can you quickly post a snip of your current logic here. would be easier to suggest a solution on the same lines instead of working out form scratch.  

Champion
Rank: #42

Can you attach the oml for this. Will look into it and revert.

Rank: #237

laurence De Ocampo wrote:

Hi everybody,

I am a newbie in outsystems. I would like to ask something about string_split function, i am little confused in using it.

I am only getting one record, i cannot display all the records as split value, it only return one record value. I am retrieving the value of the Tour Highlights field, here's how it looks:


 I am only getting the last value. How could i be able to get all the value of the record and display it as split? I've read some post, that it is need to be done in logic, how can i do that? i'm sorry i'm not that familiar with outsystems yet. Can someone help me do it? better if you could give an example. 


Thank You. I hope someone could help.

Hi,

String_Split must be used as an action either in screen action or in any other action since it returns a list of text, which you may want to iterate or perform some logic based on that. Here you are using String_Split at the screen as the expression which is not correct and will not show the desired result as you want to see. 

Is it really require to have value in a database like you are keeping(a/b/c/d) ?, I don't know what use case you are trying to build maybe you are trying to explore the string_split function.


Thanks,

Sachin 

Rank: #89

Hi Laurence,

You need to filter on aggreagte based on ID . aggregate return record based on ID .


Regards

Rahul Sahu

Rank: #89

Welcome Laurence,

Glad to help you.


Regards

Rahul Sahu