Data needs to be stored in line by line

Question

in a paragraph field i will provide input as 
 test1 
 test2 
 test3 
 How this data will be stored in db ,is it will be in line by line as separate string or as a single string

Mike Schmitt · Answer

Even if calling split() and passing in a *literal linebreak* as the delimiter works (i'd say by accident here), i would strongly advise against this approach as it's not going to be very reliable and, as you can guess from the exchange here, might not be copied over correctly by others. 
 Instead just do: " split(local!emails, char(10)) ".

Mike Schmitt · Answer

Here's a similar but alternative approach I just typed up, for what it's worth: 
 a!localVariables(
 local!emailParagraphText,
 
 local!individualEmails: if(
 a!isNotNullOrEmpty(local!emailParagraphText),
 a!forEach(
 split(local!emailParagraphText, char(10)),
 if(a!isNotNullOrEmpty(fv!item), fv!item, {})
 ),
 {}
 ),
 
 local!invalidEmails: a!flatten(a!forEach(
 local!individualEmails,
 if(
 validateemailaddress(fv!item),
 {},
 fv!item
 )
 )),

a!paragraphField(
 label: "emails",
 value: local!emailParagraphText,
 saveInto: {
 a!save(
 local!emailParagraphText,
 clean(save!value)
 )
 },
 validations: {
 if(
 a!isNotNullOrEmpty(local!invalidEmails),
 "Invalid emails entered: " & joinarray(local!invalidEmails, ", "),
 {}
 )
 }
 )
)

Mike Schmitt · Answer

ZAINAB said: will these data also be saved in db as line by line? 
 You're getting ahead of yourself a little bit. None of this will affect how the data is saved to the DB either way, that is completely separate processing that would need to happen later. You should work to understand this step fully before moving on to worrying about the DB structure issues.

Konduru Chaitanya · Answer

Hello Fursat , It is going to save in the same format as a single string.

Mike Schmitt · Answer

If you're entering them all into a single text value like from a paragraph field, then unless you do something additional to that text value, it will all be stored together in one text value of whatever database column you write it to. It's impossible for anyone here to tell you what to do when you don't tell us about what your requirement is, what you're hoping to do with it, etc. Do you have a more experienced appian developer on your team you could talk about this with? 
 Also, once again it's not necessary to make a new thread for every part of the same related subject - this is the third one so far that's related to the same original question, when you could just follow up with other replies on your existing post(s).

Data needs to be stored in line by line

Top Replies