47
Views
2
Comments
Solved
How to depend the value of data in one column from another column
Service Studio Version
11.53.14 (Build 61243)


I want the HasStock column to depend on the stock column. if stock is > 0 then HasStock = true, else false. But I cannot find how to put expression on data.

Please provide a visual explanation.

Thank you.

UserImage.jpg
Saurabh Shivananda Prabhu Chimulkar
Solution

Hi Rhyz,

Use the Calculated Attribute feature of Aggregate if you want to deduce some value based on existing columns of a Table. There is a Add New Attribute link in the list of columns insdie an aggregate (right most end). Use that to define your calculated attribute.

Will suggest you to go through the training material available in OutSystems:

https://www.outsystems.com/training/courses/132/advanced-aggregates/


OutSystems Documentation reference:

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Create_a_Calculated_Attribute_in_an_Aggregate


2021-08-12 05-19-40
Shubham Janbandhu
Solution

Hi Rhyz Dela Cruz,

Create new attribute HasStock and give value Product.Stock > 1

ex-

Instead of Keys.Number you can use Product.Stock. And use this Calculated attribute on Screen.

Good Day!

Regards,

Shubham


UserImage.jpg
Saurabh Shivananda Prabhu Chimulkar
Solution

Hi Rhyz,

Use the Calculated Attribute feature of Aggregate if you want to deduce some value based on existing columns of a Table. There is a Add New Attribute link in the list of columns insdie an aggregate (right most end). Use that to define your calculated attribute.

Will suggest you to go through the training material available in OutSystems:

https://www.outsystems.com/training/courses/132/advanced-aggregates/


OutSystems Documentation reference:

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Create_a_Calculated_Attribute_in_an_Aggregate


2021-08-12 05-19-40
Shubham Janbandhu
Solution

Hi Rhyz Dela Cruz,

Create new attribute HasStock and give value Product.Stock > 1

ex-

Instead of Keys.Number you can use Product.Stock. And use this Calculated attribute on Screen.

Good Day!

Regards,

Shubham


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