Requester Additional Fields
We have used query reports previously to extract requester information in to Excel.
The query report below has stopped working since we upgraded recently. I believe that the table containing the additional fiels has now changed but don't know what it's called. Previously the following code extracted everyone with UDF_Char3 = Yes, but now when you update the field that used to be UDF_Char3 (in our case - 'Is Membership Manager') it doesn't appear to be updating in Requester_fields. The user Donna Hall is appearing even though she has Membership Manager set to No.
I have attached the set up of the additional fields, the user, and an extract of column_aliases.
Any assitance you can provide would be appreciated.
SELECT AaaUser.FIRST_NAME 'FullName',DepartmentDefinition.DEPTNAME 'Department',SDUser.JOBTITLE 'JobTitle', AaaContactInfo.EMAILID 'Email',AaaContactInfo.LANDLINE 'Phone',AaaContactInfo.MOBILE 'Mobile' FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID LEFT JOIN DepartmentDefinition ON UserDepartment.DEPTID=DepartmentDefinition.DEPTID LEFT JOIN SiteDefinition ON DepartmentDefinition.SITEID=SiteDefinition.SITEID LEFT JOIN SDOrganization ON SiteDefinition.SITEID=SDOrganization.ORG_ID INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID LEFT JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID LEFT JOIN Requester_fields ON AaaUser.USER_ID = Requester_fields.USERID WHERE ((HelpDeskCrew.TECHNICIANID IS NULL) AND (SDUser.STATUS = 'ACTIVE')) and (Requester_fields.Udf_char3 = 'Yes') and AaaContactInfo.EMAILID like '%@%'
ORDER BY DepartmentDefinition.DEPTNAME