Eclipse Foundation Member Organization field should be a dropdown of valid Eclipse Members

Bugzilla Link	517208
Status	NEW
Importance	P3 normal
Reported	May 24, 2017 09:52 EDT
Modified	Aug 09, 2021 13:10 EDT
Depends on	516898
Reporter	Darrell Armstrong

Description

When viewing a member organization page, typically you see their Marketplace Solution / Training and Consulting listings. However, there are cases where they may not appear.

The lookup uses strict search on member name based on what is set for as the member organization, however as organization name is "free-form" there could be a mismatch between what it's looking for and what the listings are under. vs. Corp.

Instead of looking up by name, it was decided to instead link to the member ID by including an auto-complete field to define the member company listing owner.

Including notes below from discussions and testing

Christopher Guindon
Some ideas to consider for making the organization more precise:

1- make the organization field an autocomplete field based off values from the membership table.

2- Replace "Is a member company field" with a select member select field.

Additional Notes from testing - Darrell Armstrong

• the quick fix, changing the query to LIKE '%' works. On browsing other member pages, listings didn't appear out of place but there will always be the potential of pulling up a similar named company listing.

• Organization field as an auto-complete. This would aid consistency going forward. There is still the case of non-member and member companies being able to fill in the organization name as needed so a specific member company auto-complete field would be beneficial here and re-usable where needed.

Member company field as an auto-complete on Marketplace would make this more precise. Current listings will need to be migrated to the new setting. There are approximately ~576 entries (not necessarily active) set as belonging to a member organization. This could be scripted to match listing company name to member name, make some guesses and flag the guesses for manual review. Caveat here is that the member company field value is used by the REST API and badges so these areas will have to be updated as well as the member listing lookup.