Hye everyone, I am creating a praise app where on fullname, I wanted to have the recipient fullname instead of recipientemail. Disclamer the fullname in praise table is sender email
This is my relationship btw. Can someone help me to generate the correct name for me and help me to teach how the recipient id can follow the parent table value. Thank you. Below I attached the file of my application.
Yes, you can implement search drop down. It is not saving because you are missing the same basic step again of not capturing the user selection and storing it in the Praise variable that you pass to CreatePraiseWrapper. Attached is updated OML with correct logic.
Hi Hana,
You can achieve this by using joins if you are not aware about joins in outsystems then I would suggest you to go through to reactive course and refered to the below link to know about joins
https://success.outsystems.com/documentation/11/reference/outsystems_language/data/handling_data/queries/supported_join_types/
Regards,
Arun
Hello Hana,
I have tried to help you with the data model on your other post too.
https://www.outsystems.com/forums/discussion/92196/praise-recipient-relationship/
Please try to understand that you need to have your basics on data models and relationship clear before diving into building applications.
Yet trying to help you with your current situation. You want to display the name of recipient, but which recipient? The logic does not know that because it does not get that information as input on the screen and hence to the aggregate
Hope this guides you in right direction!
Is this not sufficient by selecting GetCurrentFullName? I am hoping the relationship that had been establish could help to connect between recipient email from praise table to fullname in recipient table?
No, selecting GetCurrentFullName is not sufficient. Yes there is relationship between two entities, but that would give you all related tuples from both entities when you query data because you did not specify the filters. This might even cause performance issues when you have lots of data in your entities. Here you need just one record for the recipient and to pull that necessary recipient record aggregate must know appropriate filters which would be recipient identifier in your case.
still not working? and the recipient id also not updated. If I update the database manually then the data should be okay,...? meaning my problem is because recipient id is not updated
I am not sure what you mean by update database manually. It seems you are missing some very basic stuff, please share your OML.
I select the dropdown manually because the actual value is 0.
Once I select "Hana" manually only then it will be displayed here. But I want it to be automate instead of me changing it manually
The fullname of recipient from database also cannot be displayed since it is not connected.
Please find attached the updated OMLs. You were not capturing the recipient in your Praise form which is why the join between entities was not returning any data based on your aggregate filter on RecipientID.
is it possible to use search dropdown? if yes why does the database not captured the recipient again? It can displayed the list but not updated the id again...