CV Term vs. its alias

[dsenalik]

Tripal Version

4.x

Drupal Version

any

PostgreSQL Version

any

PHP Version

any

Branch

tv4g7-issue1894-cv-term-alias-autocomplete

General Description

Create a new contact. For the "Contact Type" select empire (TAXRANK:0000037) save and it appears as edit and it appears as domain (TAXRANK:0000037)

This is because the empire term is an alias for domain.

I propose that the autocomplete, when it is presenting an alias, includes the "real" term, so a site admin knows this will happen. For example empire (TAXRANK:0000037) [alias for domain]

Here is how this example is stored in Chado:

sitedb=> select * from cvterm where name='empire';
 cvterm_id | cv_id | name | definition | dbxref_id | is_obsolete | is_relationshiptype 
-----------+-------+------+------------+-----------+-------------+---------------------
(0 rows)

sitedb=> select * from cvtermsynonym where synonym='empire';
 cvtermsynonym_id | cvterm_id | synonym | type_id 
------------------+-----------+---------+---------
             4554 |      2923 | empire  |        
(1 row)

sitedb=> select * from cvterm where cvterm_id=2923;
 cvterm_id | cv_id |  name  | definition | dbxref_id | is_obsolete | is_relationshiptype 
-----------+-------+--------+------------+-----------+-------------+---------------------
      2923 |    25 | domain |            |      3230 |           0 |                   0
(1 row)

Steps to reproduce

.

Error messages

.

Screenshots

.

[dsenalik]

We will need to modify the sql in tripal_chado/src/Controller/ChadoCVTermAutocompleteController.php to determine if this is an alias, and probably alter just the label to include something like [alias for xxx]