20 | | * Null exception in creation of (db) index. (DONE) |
21 | | * Some field was null |
22 | | * When retrieved from DB the table contact contains : |
23 | | * id, |
24 | | * !FirstName, |
25 | | * !MidInitials, !LastName, |
26 | | * '''Affiliation, ,<---- this is strange. Is not contained in the DB , where does it come from ?? ''' |
27 | | * Address, |
28 | | * Phone, Email, Fax, tollFreePhone, labworker, xref_Affiliation.name AS Affiliation_name FROM Contact LEFT JOIN Institute AS xref_Affiliation ON xref_Affiliation.id.... |
29 | | * Affiliation exists in model? but not in db ! update database . |
30 | | * database now empty |
31 | | * upload xls ..ok |
32 | | * rebuild index. |
33 | | * Search in the db index was not working for the field name |
34 | | * name is not included in the model or the database, but data are here! |
35 | | * this creepy feature is because this column was created by the XLS IMPORT! |
| 20 | * |
| 31 | * Null exception in creation of (db) index. - resolved (DONE) |
| 32 | * Some field were null |
| 33 | * When retrieved from DB the table contact contains : |
| 34 | * |
| 35 | * id, |
| 36 | * !FirstName, |
| 37 | * !MidInitials, !LastName, |
| 38 | * '''Affiliation, ,<---- this is strange. Is not contained in the DB , where does it come from ??''' |
| 39 | * Address, |
| 40 | * Phone, Email, Fax, tollFreePhone, labworker, xref_Affiliation.name AS Affiliation_name FROM Contact LEFT JOIN Institute AS xref_Affiliation ON xref_Affiliation.id.... |
| 41 | * Affiliation exists in model? but not in db ! update database . |
| 42 | * database now empty |
| 43 | * upload xls ..ok |
| 44 | * rebuild index. |
| 45 | * Search in the db index was not working for the field name |
| 46 | |
| 47 | * name is not included in the model or the database, but data are here! |
| 48 | * this creepy feature is because this column was created by the XLS IMPORT! |
| 49 | * '''Search inside the field description is WORKING : try "accurately" HIV .''' |