Log in to AnswerLog in to Follow
UserImage.jpg
Meletis Kozakidis
35Views
13Comments
Solved
Refresh Screen Using 2 Different Aggregates
Question
Users
Aggregate
Beginner
OutSystems 11

Hello,
first of all im trying to build a Reactive Web App . 
I have 2 different Excels / Aggregates and i want to impliment them in a Dropdown Widget so i'll be able to Refresh the Data on the screen when i choose which Department i want to see and who is in it .

  ( For the sake of the example ill name them Master Data and Supplementary
   Master Data ,  has all the info we need for an Employee , Name/LastName/Surname/Id/Departments and many more .
Supplementary  , has only Departments on it and the reason is because  we have 2 or more employees at the same Department and in Master Data when im trying to use it at dropdown all i get is Duplicated Values .


In conclusion , all i want is to have a connection between those 2 Aggregates or if its possible to remove the duplicates that are being shown at dropdown ( IF we use the MasterData )

                                                          **We are trying not to use any Forge components**

0
0
07 Apr

Hi Meletis,

I have implemented the logic which you want 

here is the oml.....

See solution in context
Test.oml

0
0
08 Apr

Hello again ,
Awesome :D .But as i see it it has x2 Extensions .
1 )HTML2PDF

2nd i cant really find it or dependecies are messed up .
Is there a way to do the logic without using extensions ?
Thats what they are asking to do .


Thanks again ,
 MeL

0
0
08 Apr

Replying to Meletis Kozakidis' comment on 08 Apr 2022 14:22:41

I was using that extension for some other purpose . You can implement same logic without that extension also.

0
0
09 Apr

Replying to Pramod Torase's comment on 09 Apr 2022 04:02:49

Hello and thanks once more for your reply . 

 Im trying to implement the same logic wihtout the extensions but it doesnt work . 

When i use the local Variable DepartmentId ( so it will create a Department Identifier ) and use it as a filter so we will get the Test Value we need , it just doesnt show up any of the values we have entered .
The Table is empty , no value been shown or will be .

Can you help me a bit there


Thanks in advance,
 MeL

0
0
11 Apr

Hi Meletis,

First create a aggregates to select distinct departments from Supplementary. You can use group by department in this aggregates. Bind your dropdown with this aggregates results.

Create second aggregates to select MasterData. Set fetch property as only on demand. Apply Filter in this aggregates to select only one department records. Create a input parameter DepartmentId and used it in filter.

On change of Department dropdown event refresh the MasterData aggregates.


Thanks

Vinod

1
0
07 Apr

Hello Vinod ,
thanks for the fast response and your solution about it .
So its something like this after all . https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Implement_asynchronous_data_fetching_using_Aggregates


Thanks ,
MeL

0
0
07 Apr

Replying to Vinod Patidar's comment on 07 Apr 2022 13:02:17

So Instead of Employees.Id
Ill put Employees.Departments ?

or i connect those 2 aggregates using Entity Diagram ?
So it will be MasterData(Employees) <-- Supplementary(Departments) , so it will create a Departments.Id to MasterData , am i right ? 

0
0
07 Apr

Replying to Vinod Patidar's comment on 07 Apr 2022 13:02:17

Ok , so quick update .
I did follow all the Documentation, swapped the data and still doesnt work .
Im sorry, but im still in JuniorLevel.
Do you require the .oml to help me more?

Thanks in advance ,
MeL

0
0
08 Apr
ForumTest.oml

0
0
08 Apr

Hi Meletis,

I have implemented the logic which you want 

here is the oml.....

Test.oml

0
0
08 Apr

Hello again ,
Awesome :D .But as i see it it has x2 Extensions .
1 )HTML2PDF

2nd i cant really find it or dependecies are messed up .
Is there a way to do the logic without using extensions ?
Thats what they are asking to do .


Thanks again ,
 MeL

0
0
08 Apr

Replying to Meletis Kozakidis' comment on 08 Apr 2022 14:22:41

I was using that extension for some other purpose . You can implement same logic without that extension also.

0
0
09 Apr

Replying to Pramod Torase's comment on 09 Apr 2022 04:02:49

Hello and thanks once more for your reply . 

 Im trying to implement the same logic wihtout the extensions but it doesnt work . 

When i use the local Variable DepartmentId ( so it will create a Department Identifier ) and use it as a filter so we will get the Test Value we need , it just doesnt show up any of the values we have entered .
The Table is empty , no value been shown or will be .

Can you help me a bit there


Thanks in advance,
 MeL

0
0
11 Apr

can you send the latest oml??....I ll check.

0
0
11 Apr

This one is not my main Module but it has the same logic , less information


**EDIT : I connected the Entities inside the Diagram , giving the Employee Entity a DepartmentID ,
then i continued using it as a filter at GetEmployees Aggregate =DepartmentId (variable) to create a new Test Value , but it didnt work either 

ForumTest.oml

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