Working on health insurance project ,having Database issue
Application Type
Reactive

and I also want to appear username after hello  in below screenshot

unable to add data in database manually 

sharing oml for reference

HealthCare.oml

Hey @Pooja Ganvir ,

Thanks for the oml. Can you please tell what was the error that appeared when you clicked 'view error report?

Also, you have 2 mandatory foreign keys, 'InsuranceID' and 'SumInsuredID' in the Applicant table. Did you create these records first?

Also, if you want the user name to appear without having records for FamilyMembers table, you should change the aggregate filter from FamilyMembers.CreatedBy = GetUserId() to User.Id = GetUserId(), since the user won't have records associated to FamilyMembers .

Hope this helps!

Solution

Thank You So much @Laura Fidalgo 

I will share you the error report

Any time @Pooja Ganvir !

So that error shows that is something wrong with the foreign key to the Insurance table. You need to first create the records on your static entities that have foreign keys in the Applicant table, publish, and then you can create the Applicant record with those ids, or make them non mandatory

Any time @Pooja Ganvir !

So that error shows that is something wrong with the foreign key to the Insurance table. You need to first create the records on your static entities that have foreign keys in the Applicant table, publish, and then you can create the Applicant record with those ids, or make them non mandatory

Hey @Pooja Ganvir ,

Thanks for the oml. Can you please tell what was the error that appeared when you clicked 'view error report?

Also, you have 2 mandatory foreign keys, 'InsuranceID' and 'SumInsuredID' in the Applicant table. Did you create these records first?

Also, if you want the user name to appear without having records for FamilyMembers table, you should change the aggregate filter from FamilyMembers.CreatedBy = GetUserId() to User.Id = GetUserId(), since the user won't have records associated to FamilyMembers .

Hope this helps!

Solution

Thank You So much @Laura Fidalgo 

I will share you the error report

Any time @Pooja Ganvir !

So that error shows that is something wrong with the foreign key to the Insurance table. You need to first create the records on your static entities that have foreign keys in the Applicant table, publish, and then you can create the Applicant record with those ids, or make them non mandatory

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