Best practice for getting user information

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
1. Binding Type = Expression
2. Binding = USERNAME( )
3. Hidden = true
Added a Secondary Collection. The IDO is "UserNames"
1. Permanent Filter Expression = "Username = FC(hdnUserName)"
Added Event Handler "StdFormInitCompleted"
1. 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.

Find more posts tagged with

Accepted answers

tdickens

@bradley

Thanks for catching the double quotes. That was the problem.

All comments

BradleyBrown

Depending on your needs, what you're doing may be a bit overkill. If all you need to do is grab these values once, then a LoadCollection form event handler will work.

Note, here I am assigning the IDO property values to variables. You can just as easily assign them to components or other IDO properties.

tdickens

@Bradley B,

Thanks for suggesting using the LoadCollection form event. That's exactly what I needed.

Should I execute the LoadCollection in the StdFormInitCompleted event handler? That works and seems like a good place. But there may be a better way to execute the LoadCollection form event.

Also, I could not get the Filter to work using the expression like you showed. My filter on the LoadCollection was this:

UserNames( FILTER(Username = "USERNAME( )") MOV() SONON() SETV(vFullUserName=UserDesc,vEmail=DerPrimaryEmailTypeEmail) )

But that filter gives me an error when I run the form. It says "Invalid column name" with the value returned from USERNAME().

The only way I could get the filter to work was by setting up a hidden field and using that in the filter. Like this:

UserNames( FILTER(Username = FC(hdnUserName)) MOV() SONON() SETV(vFullUserName=UserDesc,vEmail=DerPrimaryEmailTypeEmail) )

BradleyBrown

The beauty of it being a form event is that you can fire it at any time when you need it. In general, if you only need to fire it once, I would agree StdFormInitCompleted or StdFormPredisplay would be good events to put this one into.

Are those double quotes around USERNAME() in your filter? Those need to be single quotes, the same as you would use if you were writing a sql query. Otherwise, I don't see why your filter shouldn't work.

tdickens

@bradley

Thanks for catching the double quotes. That was the problem.

Copyright © 2025 Infor. All rights reserved.