I’d like to query the ofUser table to get a specific user. But, the wrinkle is that I need to specify an alternate id, for example a Student ID. There are two problems I have here; of course, let me know if you see more!
First, I’m not sure where to store this additional column Student ID. I could modify the ofUser table (yuck!). I’ve also looked at ofUserProp table with some interest.
Second, if I happen to use something like ofUserProp, how do I populate the Student ID easily. I know I can write SQL for a bulk import. But, I expected to find somplace within the Openfire Admin console where I could add items to the ofUserProp table. Am I missing anything?
Thanks for any suggestions/help.