Hi all.

We have updated our SDP distribution from 7611 to 8110.

We are using custom UDF field (UDF_LONG1) in requester table.

After this update we're unable to see this data while searching requesters.

I found, that after update all data from Requester_Fields.UDF_LONG1 were copied into Requester.ATTRIBUTE_301 field during update.

Now RequesterDef.do page is working with new configuration and uses Requester.ATTRIBUTE_301 instead of old Requester_Fields.UDF_LONG1. But if we run SearchRequester.do?fromModule=WorkOrder&startsWith= we can't see content of this field. I found that SearchRequester is not including newly created fields Requester.ATTRIBUTE_301 and Requester.ATTRIBUTE_302 in select clause.

Here is sample query, generated by SearchRequester.do page.

SELECT AaaUser.USER_ID,AaaUser.FIRST_NAME "FullName",AaaLogin.DOMAINNAME "Domain",AaaLogin.NAME "LoginName",AaaContactInfo.EMAILID "Email",
DepartmentDefinition.DEPTNAME "Department",DepartmentDefinition.SITEID,SDOrganization.NAME "Site",AaaContactInfo.LANDLINE "Phone",
SDUser.JOBTITLE "JobTitle",SDUser.EMPLOYEEID "EmployeeID",HelpDeskCrew.TECHNICIANID "TechID",Requester_Fields.USERID,Requester_Fields.UDF_LONG1,
Requester_Fields.UDF_LONG2,Requester_Fields.UDF_LONG3,Requester_Fields.UDF_LONG4,Requester_Fields.UDF_CHAR1,Requester_Fields.UDF_CHAR2,
Requester_Fields.UDF_CHAR3,Requester_Fields.UDF_CHAR4,Requester_Fields.UDF_CHAR5,Requester_Fields.UDF_CHAR6,Requester_Fields.UDF_CHAR7,
Requester_Fields.UDF_CHAR8,Requester_Fields.UDF_CHAR9,Requester_Fields.UDF_CHAR10,Requester_Fields.UDF_CHAR11,Requester_Fields.UDF_CHAR12,
Requester_Fields.UDF_DATE1,Requester_Fields.UDF_DATE2,Requester_Fields.UDF_DATE3,Requester_Fields.UDF_DATE4 FROM AaaUser INNER JOIN SDUser
ON AaaUser.USER_ID=SDUser.USERID LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON
AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID 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 LEFT JOIN
HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID LEFT JOIN Requester_Fields ON SDUser.USERID=Requester_Fields.USERID LEFT JOIN
AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID WHERE  ((BINARY SDUser.STATUS = 'ACTIVE') AND (AaaUser.FIRST_NAME LIKE 'a%'))  ORDER BY 2 LIMIT 0,100

And this one is generated by RequesterDef.do page

SELECT CI.CIID "CI_CIID",CI.CIID "VIEWRELATIONSHIPS",CI.CINAME,CI.CREATEDDATE,CI.LABEL,CI.LASTMODIFIED,CI.LIFECYCLEGROUPIDENTIFIER,CI.VERSION,
CIType.TYPENAME,Requester.ATTRIBUTE_301,Requester.ATTRIBUTE_302,ImpactDefinition_IMPACTID.NAME "IMPACTID",AaaContactInfo.EMAILID,SDUser.JOBTITLE,
AaaContactInfo.MOBILE,AaaContactInfo.LANDLINE,AaaUser.USER_ID,AaaUser.FIRST_NAME "FullName",AaaLogin.DOMAINNAME "Domain",AaaLogin.NAME "LoginName",
AaaContactInfo.EMAILID "Email",DepartmentDefinition.DEPTNAME "Department",SDOrganization.NAME "Site",AaaContactInfo.LANDLINE "Phone",
SDUser.EMPLOYEEID "EmployeeID",SDUser.JOBTITLE "Job-Title",AaaContactInfo.MOBILE "Mobile",Requester_Fields.USERID,Requester_Fields.UDF_LONG1,
Requester_Fields.UDF_LONG2,Requester_Fields.UDF_LONG3,Requester_Fields.UDF_LONG4,Requester_Fields.UDF_CHAR1,Requester_Fields.UDF_CHAR2,
Requester_Fields.UDF_CHAR3,Requester_Fields.UDF_CHAR4,Requester_Fields.UDF_CHAR5,Requester_Fields.UDF_CHAR6,Requester_Fields.UDF_CHAR7,
Requester_Fields.UDF_CHAR8,Requester_Fields.UDF_CHAR9,Requester_Fields.UDF_CHAR10,Requester_Fields.UDF_CHAR11,Requester_Fields.UDF_CHAR12,
Requester_Fields.UDF_DATE1,Requester_Fields.UDF_DATE2,Requester_Fields.UDF_DATE3,Requester_Fields.UDF_DATE4 FROM Requester INNER JOIN CI
ON Requester.CIID=CI.CIID INNER JOIN CIType ON CI.CITYPEID=CIType.TYPEID INNER JOIN SDUser ON CI.CIID=SDUser.CIID LEFT JOIN
AaaUserContactInfo ON SDUser.USERID=AaaUserContactInfo.USER_ID LEFT JOIN People ON CI.CIID=People.CIID LEFT JOIN BaseElement ON
CI.CIID=BaseElement.CIID LEFT JOIN ImpactDefinition ImpactDefinition_IMPACTID ON BaseElement.IMPACTID=ImpactDefinition_IMPACTID.IMPACTID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID INNER JOIN AaaUser ON
SDUser.USERID=AaaUser.USER_ID LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID 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 LEFT JOIN RegionDefinition ON
SiteDefinition.REGIONID=RegionDefinition.REGIONID LEFT JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID LEFT JOIN
Requester_Fields ON SDUser.USERID=Requester_Fields.USERID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID WHERE 
((HelpDeskCrew.TECHNICIANID IS NULL) AND (BINARY SDUser.STATUS = 'ACTIVE'))  ORDER BY 10 DESC LIMIT 0,100