x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 213 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
avolpe

New Search Screen Fields

Posted By

I created a new search screen so a user can search every address, not just the default address. For some reason when I go to maintain the screen definition some of the fields from the list are missing, whatever fields AREN'T part of the entity I created the screen in. So, when I created the screen in Company address fields aren't showing, when I create the screen in the address entity customer fields don't show up. I have tried a number of different view configurations.

Any ideas?

SELECT dbo.vAddressCompany.*, dbo.vCompany.*
FROM dbo.vAddressCompany INNER JOIN
dbo.vCompany ON dbo.vAddressCompany.AdLi_CompanyID = dbo.vCompany.Comp_CompanyId

  • 0

    Have you tried joining just the tables rather than trying to join views together? Something like...

    Select c.comp_companyid, c.comp_name, c.comp_mas_customerno, c.comp_primaryuserid, a.addr_addressid, a.addr_address1, a.addr_address2, a.addr_city, a.addr_state, a.addr_postcode from Company as c JOIN Address_Link on c.comp_companyid = adli_companyid JOIN Address as a on adli_addressid = a.addr_addressid

    You can remove the need to list specific fields and just do...

    Select c.*, a.* from Company as c JOIN Address_Link on c.comp_companyid = adli_companyid JOIN Address as a on adli_addressid = a.addr_addressid

    That's not as efficient if you know what fields you're after, but will remove any limitation/restriction of fields available.

  • 0

    Changing it to pull from the tables directly didn't change anything...Its very strange, all of the fields are available when i create the list, just not on the search screen.

*Community Hub is the new name for Sage City