×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Show on list view no longer working correctly
alex
New Member
Posts: 2
pred 7 rokmi 9 mesiacmi #1470
od alex
Show on list view no longer working correctly bolo vytvorené alex
I have a field J_SQL
It is a select of virtuemart products.
On the list view it always has shown the "selected" product. ie the value in the database.
Now, after my last rebuild the list view shows all the same product , which is the "lowest id" in the virtuemart product database.
It is a select of virtuemart products.
On the list view it always has shown the "selected" product. ie the value in the database.
Now, after my last rebuild the list view shows all the same product , which is the "lowest id" in the virtuemart product database.
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Chris
New Member
Posts: 3
pred 7 rokmi 9 mesiacmi #1484
od Chris
Odpoveď od Chris na tému Show on list view no longer working correctly
I see same problem. I checked my database, data is saving correctly, but showing incorrectly on admin list view.
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Chris
New Member
Posts: 3
pred 7 rokmi 9 mesiacmi #1485
od Chris
Odpoveď od Chris na tému Show on list view no longer working correctly
I was able to adjust the query in the list model, adding a left join, grabbing the correct data. Then I edited the view file, showing the "name" rather than the "id" of the field in question. This challenged my SQL skills, but solved the problem.
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
alex
New Member
Posts: 2
pred 7 rokmi 8 mesiacmi #1487
od alex
Odpoveď od alex na tému Show on list view no longer working correctly
so how did you solve this?
can you post it here?
can you post it here?
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Chris
New Member
Posts: 3
pred 7 rokmi 8 mesiacmi #1490
od Chris
Odpoveď od Chris na tému Show on list view no longer working correctly
Alex, Something like this...
let's say you have "items" and "parents". You want to show a list of items with the correct parent name.
Modify the query in the model, adding #__parents.name AS parentName in the select().
Modify the query further, adding a LEFT JOIN ON item.parent_id = #__parents.id.
Notice the parentName alias, this is important. I think I also aliased the table name simply to reduce typing, not important.
Now go into your view. Instead of displaying parent_id, display parentName. You probably don't have a "parentName" column in your #__parents table, that's ok, we created one on the fly with our alias.
I had to brush up on MySql joins as well as the JDatabase query() object.
As always for testing, in the model, before "return $query", add var_dump( $query->__toString() ); die; so that you can monitor the query. Cut and paste into PHPMyAdmin to test.
As an alternative, blow away the query found in the model, and write your own, might be simpler. Just remember to join "name" from the "parents" table as an alias.
That's as specific as I can explain, hope it helps.
let's say you have "items" and "parents". You want to show a list of items with the correct parent name.
Modify the query in the model, adding #__parents.name AS parentName in the select().
Modify the query further, adding a LEFT JOIN ON item.parent_id = #__parents.id.
Notice the parentName alias, this is important. I think I also aliased the table name simply to reduce typing, not important.
Now go into your view. Instead of displaying parent_id, display parentName. You probably don't have a "parentName" column in your #__parents table, that's ok, we created one on the fly with our alias.
I had to brush up on MySql joins as well as the JDatabase query() object.
As always for testing, in the model, before "return $query", add var_dump( $query->__toString() ); die; so that you can monitor the query. Cut and paste into PHPMyAdmin to test.
As an alternative, blow away the query found in the model, and write your own, might be simpler. Just remember to join "name" from the "parents" table as an alias.
That's as specific as I can explain, hope it helps.
Nasledujúci užívateľ(ia) povedali ďakujem: Andres Maeso
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.054 sekúnd