statonlab / tripal_ssr

0 stars 0 forks source link

organism -feature field displays inaccurate info #40

Closed bradfordcondon closed 6 years ago

bradfordcondon commented 6 years ago
screen shot 2018-07-02 at 10 50 40 am
bradfordcondon commented 6 years ago

First I ruled out the possibility that the features were all associated with the same parent:

select fr.object_id from chado.feature f INNER JOIN chado.feature_relationship fr ON fr.subject_id = f.feature_id WHERE f.type_id = 449;
2270577
2269971
2273485
2269734
2274595
2275850
2271766
2271002
2269690
2275978
2275607
2271001
2272781
2275123
2273741
2272417
2273263
2273566
2275187
2274373
2269778
2270365
2273900
2268695
2269142
2271743
2269422
2273240

not the case, good.

bradfordcondon commented 6 years ago

this query is pretty much what runs in the load. it works as expected.. so whats the problem?

select f.feature_id from chado.feature F INNER JOIN chado.feature_relationship fr ON fr.object_id = f.feature_id INNER JOIN chado.feature ftwo ON ftwo.feature_id = fr.subject_id WHERE ftwo.type_id = 449 AND f.organism_id = 28;
bradfordcondon commented 6 years ago

oops: fetchAssoc instead of fetchAllAssoc in the PDO object.

bradfordcondon commented 6 years ago
screen shot 2018-07-02 at 11 36 24 am