125
Views
8
Comments
Solved
I want to count and show up to the screen...

this is result, its only show up Booked Case


This is my expression code in check-in count Box



This is my database, i did group this data by count




Thanks so much! 

2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello

I got it, here , You can create 4 Local Variables to show the count, for each instance, or you can use the blocks to do this 

I am attaching you a sample OML to explain you the same -

Sample - https://personal-ejuytnht.outsystemscloud.com/New_Bookings/CheckStatus?_ts=638242880319486561

Thanks
Tousif Khan

New_Bookings.oml
2024-05-15 07-07-20
Thinh Du

Tks you so much!!

2023-10-21 19-42-11
Tousif Khan
Champion

You are welcome :)
I am glad I was able to help you.
Tousif Khan

2021-03-05 13-56-11
Ricardo Pereira
 
MVP

Hi,

You can't do like that. You already have the right aggregate retrieving the correct data. You can create a list where the source is that aggregate, and you place your content inside that list (you can create a block with the card that you already design and pass it the input fields that you want to show, it will create an item for each record of the aggregate, in this case, one for each groupBy) and you pass the fields that you want (line the StatusLabel, Count, what you need).

Hope this can help you.


Best regards,

Ricardo

2024-05-15 07-07-20
Thinh Du

i understand what u say, but in this case, i have to create 4 blocks, right? Any better way?? i mean the short one..

2021-03-05 13-56-11
Ricardo Pereira
 
MVP

Hi,


No, you just need to create one and place inside the list. The list will create how many instances you have in your aggregate.


Hope this can help you!

Best regards,

Ricardo

UserImage.jpg
Puja Rani

Hi,

Looks like your box is not inside a table which is why it is always taking the current value. The aggregate which you showed, do the following steps:

  • Create 4 local variable to hold value of each status type
  • Add On after fetch to that aggregate. Add List filter action for each status type to get value and assign to each local variable
  • Use those local variable in your box to show the value 
2024-05-15 07-07-20
Thinh Du

let me try..

2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello

I got it, here , You can create 4 Local Variables to show the count, for each instance, or you can use the blocks to do this 

I am attaching you a sample OML to explain you the same -

Sample - https://personal-ejuytnht.outsystemscloud.com/New_Bookings/CheckStatus?_ts=638242880319486561

Thanks
Tousif Khan

New_Bookings.oml
2024-05-15 07-07-20
Thinh Du

Tks you so much!!

2023-10-21 19-42-11
Tousif Khan
Champion

You are welcome :)
I am glad I was able to help you.
Tousif Khan

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