I need to get the users full name (First Name Last Name) and email address. In my brief Mongoose experience, this is the first time that I've needed to read information from an IDO that wasn't surfaced in a grid or combo box. I want to verify that what I'm doing is the best approach. Note that I'm using the Cloud version of Mongoose.
It appears that when we need to read information from an IDO that we add a Secondary collection. I need to read the Secondary collection to get values that I can populate in the Primary collection. I just want to make sure what I'm doing is the best approach.
There is an IDO named "UserNames". This IDO has a property named "UserDesc" and another property named "DerPrimaryEmailTypeEmail". It appears that these fields contain the users full name and email address.
There is an expression named "USERNAME()". This expression gives me the Username.
This is what I did. I want to know if this is the best approach.
- Created a Static component to hold the UserName named hdnUserName
- Binding Type = Expression
- Binding = USERNAME( )
- Hidden = true
- Added a Secondary Collection. The IDO is "UserNames"
- Permanent Filter Expression = "Username = FC(hdnUserName)"
- Added Event Handler "StdFormInitCompleted"
- Collection Refresh on the Secondary Collection
Please let me know if the approach I'm doing is the best way to get the user information. I also want to make sure my understanding of Secondary Collections is correct. It appears that anytime we want to get data from an IDO that doesn't have a parent-child relationship to the Primary Collection. Then we should use a Secondary Collection.
Thanks for your help.