Need Logic -- reactive outsystem

How to insert multiple Records of static entity  into single column of entity and how to show in table ?

Suppose i have static entity with records -C#,Sql, Java, F#

these four records id i need in my employee entity column and show in comma seperated into single column of table .

Refer attached screenshot -output

outsystemlogic.png

When you insert this, this will just be text, as I understand, you need to save those to a single column, just go to Manage Dependencies, search "text" then use "string_build" this will need a list input, then it will generate a string base on the list, you can set what will be the separator. I'm not sure why do you need to do it like that, as you can use a junction table to create a many to many relationship.

Hi Sangam,

Store the data as per your database diagram and while display use SQL widget to write custom query to display comma separated values . Please refer below post 

https://www.outsystems.com/forums/discussion/78313/combine-the-values-in-one-row-when-exporting-outsystems-11/

Best Regards

Devendra



Hi Sangam.


U can store the multiple id's in a single column if you make use of JSON Serialize Please Refer below link

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Implementing_Logic/Logic_Tools/JSON_Serialize

Hi Sangam,

To store multiple static values in your Employee entity, you have to create column with 'text' type and to store it, just add all static values like this : Entities.Expertise.C# + "," + Entities.Expertise.CSS  etc. Now you can directly show this text data into your screen table.

Sanjay

Hi Sangam,

The way you are saving the data is correct only, while displaying the data you can write the below SQL query to fetch the data of Employee along with comma-separated expertise.

Output:

Note - You need to create the structure something like this to get output from the SQL query.

 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.