No, I mean for the purposes of writing scripts. I figured out all your custom fields are located in the userfield table. So for example, I added a field (field10) which is a Yes or No field. If field is "Yes", then I want to know the users email address. So I'd use a query like this:
select email from userfield uf, user u where field6 = 'Yes' and u.userid = uf.userid;
Hope this helps someone else.
|