Our membership team has requested that I change the default creditee type for when a membership gets assigned from one customer to another. This conversation came up once before and according to our team, I did find a way to change the default designation. The dropdown lists the options in alphabetical order by description, but it always defaults to the second option when they want it defaulting to the first option. I can't for the life of me figure out how I did it, or even if I did manage to change it before. I can't find any documentation on it either.
Could you use the Trace function to see where it is calling when you click the drop down? That might give you a clue on where to look.
I did try that, and it just runs a simple SELECT query pulling from the TR_CREDITEE_TYPE table, and there is no order by clause in the query, so by default it should order by the primary key right? So the client itself must be doing something to re-order them in the dropdown menu and decide what the default option should be, but I can't seem to figure out from the log viewer how that is decided.
Does the "default" creditee type in the dropdown have the credit_membership_ind column set to Y? Maybe that is the first alphabetically with that setting. Effectively, the query would be:
select description from TR_CREDITEE_TYPE where inactive = 'N' and credit_membership_ind = 'Y' ;
Hmm, when I do a select * with the same where clause, it sorts the same way. By id, not alphabetically by description.
Look here: It might control the dropdown sort.
This isn't related to this issue, but I don't have a creditee option for dropdown code 211. That is printed, unprinted, both in our system?
Yeah, after reading a bit more, I think that is more of a parameter dropdown in reports. Scratch that idea.