Unable to download agents

asked 2019-06-13 15:41:00 -0500

Hi,

We can download some agents but not others using the following queries. Can someone let us know what could be the issue?

url: http://maxebrdi-rets.paragonrels.com/... username: ccar_gabriels user-agent: gabriels

SELECT [Agent Identifier],[Agent Phone4 Number],[Agent Phone5 CountryId],[Agent Phone5 Description],[Agent Phone5 Extension],[Agent Phone5 Number],[Agent Salutation],[Agent State],[Active],[Active Book Count],[Agent Address Street Name],[Agent Address2],[Agent City],[Agent Designation],[Agent Email],[Agent First Name],[Agent Last Name],[Agent License Date],[Agent License ID],[Agent Logon Name],[Agent Mail Address2],[Agent Mail City],[Agent Mail Preference],[Agent Mail State],[Agent Mail Street Name],[Agent Mail Zip],[Agent Middle Initial],[Agent Office ID],[Agent Password],[Agent Phone1 CountryId],[Agent Phone1 Description],[Agent Phone1 Extension],[Agent Phone1 Number],[Agent Phone2 CountryId],[Agent Phone2 Description],[Agent Phone2 Extension],[Agent Phone2 Number],[Agent Phone3 CountryId],[Agent Phone3 Description],[Agent Phone3 Extension],[Agent Phone3 Number],[Agent Phone4 CountryId],[Agent Phone4 Description],[Agent Phone4 Extension],[Agent Status],[Agent Training],[Agent Type],[Agent Url],[AOFranchisor Opt-In],[AOIDX Y/N],[AOMain Office ID],[AOOffce Address Street Name],[AOOffice Abbreviation],[AOOffice Address2],[AOOffice City],[AOOffice Email],[AOOffice Name],[AOOffice Phone1 CountryId],[AOOffice Phone1 Extension],[AOOffice Phone1 Number],[Agent Zip],[AOBoard ID],[AOOffice State],[AOOffice Type],[AOOffice Url],[AOOffice Zip],[AOOffice Phone1 Description],[Board Prohibited By],[Board User ID],[Date Added],[Date Agent Type Changed],[Date Assigned to Office],[Date Key Assigned],[Date of Agt State Mbrshp],[Distributed User],[Hash],[Last Trigger Date],[Multiple Logon],[NRDS_ID],[Number of Keys],[Old Agent ID],[Pers PAC Contribution YTD],[Photographer],[Preferred Phone Area],[Preferred Phone Number],[Previous Key Number],[Prohibited],[Security Level],[Sold Book Count],[Source Access Rights],[Source Bill Type Role],[Source System Update Date],[Spouse First Name],[State Agent Is Member Of],[Status Date],[Training Date],[UPAgent image Timestamp],[Update By Agent],[Update Date],[UPLogo image Timestamp],[UPPreferred Phone],[User Code],[User Photos Code] FROM ActiveAgent:[All Active Agents] WHERE ([Active] IN ('No','Yes')))

or using this one too:

SELECT U_AgentID,U_PhoneNumber4,U_PhoneNumber5CountryCodeId,U_PhoneNumber5Desc,U_PhoneNumber5Ext,U_PhoneNumber5,U_UserSalutation,U_State,U_user_is_active, U_ActiveBookCount,U_AddressStreet,U_Address2,U_City,U_FreeFormDesig,U_Email,U_UserFirstName,U_UserLastName,U_AgentLicenseDate,U_AgentLicenseID,U_LoginName,U_MailAddress2, U_MailCity,U_PreferredMailCode,U_MailState,U_MailAddressStreet,U_MailZip,U_UserMI,U_HiddenOrgID,U_Password,U_PhoneNumber1CountryCodeId,U_PhoneNumber1Desc, U_PhoneNumber1Ext,U_PhoneNumber1,U_PhoneNumber2CountryCodeId,U_PhoneNumber2Desc,U_PhoneNumber2Ext,U_PhoneNumber2,U_PhoneNumber3CountryCodeId,U_PhoneNumber3Desc, U_PhoneNumber3Ext,U_PhoneNumber3,U_PhoneNumber4CountryCodeId,U_PhoneNumber4Desc,U_PhoneNumber4Ext,U_Status,U_Indoctrination,U_HiddenUsCID,U_WebPage,AO_Char10_1, AO_Char10_2,AO_BranchOfOrgID,AO_OrgAddressStreet,AO_ShortName,AO_OrgAddress2,AO_OrgCity,AO_EMail,AO_OrganizationName,AO_PhoneNumber1CountryCodeId,AO_PhoneNumber1Ext, AO_PhoneNumber1,U_Zip,AO_board_id,AO_OrgState,AO_HiddenOtyID,AO_WebPage,AO_OrgZip,AO_PhoneNumber1Desc,U_Char100_1,U_BoardId,U_InputDate,U_AgentTypeChangeDate, U_DateAssignedToOrg,U_DateKeyAssigned,U_StateAgentIsMemberOfDate,U_Dist,U_Hash,U_LastTrig,U_MultyLogin,U_users_nrds_id,U_NumberOfKeysAssigned,U_Char50_4,U_PersonalPACContrib, U_Photographer,U_Char10_1,U_Char10_2,U_PreviousKeyNumber,U_Char10_3,U_SecurityLevel,U_SoldBookCount,U_Char50_3,U_Char50_2,U_Char50_1,U_SpouseFirstName,U_StateAgentIsMemberOf, U_StatusDate,U_IndoctrinationDate,UP_AgentImageFileUpdt,U_UpdateAgent,U_UpdateDate,UP_LogoImageFileUpdt,UP_AgentPhone,U_UserCode,U_Photos FROM ActiveAgent:ActiveAgent WHERE (U_user_is_active=|0,1)

edit retag flag offensive close merge delete

Comments

Since you are using the ActiveAgent resource in both cases, the query is irrelevant.
If you search the Agent resource, Agent class, you should be able to pull either status.
1=Active and 0=Inactive like you did with this one: (U_user_is_active=|0,1)

bwolven gravatar imagebwolven ( 2019-06-14 16:47:47 -0500 )edit