search

specify / specify7

Specify 7
https://www.specifysoftware.org/products/specify-7/
GNU General Public License v2.0
66 stars 36 forks source link

Support `many-to-many` relationships #2928

Open grantfitzsimmons opened 1 year ago

grantfitzsimmons commented 1 year ago

This has come up most recently with users asking to use the Project table. Because it has a many-to-many relationship from Collection Object, it is not supported.

A big issue is that this relationship is used infrequently with user-facing tables. Do the programmers have any thoughts on how we can resolve this?

grantfitzsimmons commented 1 year ago

Iñigo at CSIC is also requesting this functionality to be added

maxpatiiuk commented 1 year ago

Could be done as part of https://github.com/specify/specify7/issues/2621

grantfitzsimmons commented 1 year ago

We would like to add a form access to the Project table. The relation should be 1:Project to many Col Objects. The button should be in Colletions Object form near to CollectionObjectCitations. The fields active in the Project table should be: projectName; projectNumber; projectDescription; startDate ;endDate; remarks; GrantAgency

Requested by: Barcelona

grantfitzsimmons commented 1 year ago

CSIC, SAIAB, UMich, New Brunswick, Barcelona, and on and on have been requesting this. Is this a major addition to Sp7?

grantfitzsimmons commented 1 year ago

From @tlammer in #1172:

Reported by UMich

they tried to add projects to the CO form, it appears in 6 but not in 7. Code added: cell type="subview" viewname="Project" id="proj" name="projects" initialize="btn=true"

error in the console: unhandled relationship type: many-to-many

grantfitzsimmons commented 1 year ago

UMich asked again today about the Project subview in Specify 7

specifysoftware commented 1 year ago

This issue has been mentioned on Specify Community Forum. There might be relevant details there:

https://discourse.specifysoftware.org/t/specify-6-vs-specify-7-feature-comparison/551/3