⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Multiple table data show in grocerycrud table



likhon3k

likhon3k
  • profile picture
  • Member

Posted 29 September 2015 - 15:36 PM

I can show multiple table data in a table by custome controller, model, view. but I need to know there is any way to show multiple table data in a table by GC?

 

like:

 

user_info table:

 

id, name, username, password

 

 

student_grade:

 

id. user_info_id, subject, grade, cgpa

 

 

student_info:

 

id, user_info_id, stud_name, fathers_name, present_address, permanent_address

 

 

there are three tables named user_info, student_grade, student_info and so on and those table data inserted seperately or custom registration form. but I want to show all the inserted data for that user_info_id in one table from diferent table at a time by using GC.

 

like:

 

all_data_table

 

id, name, username, password, subject, grade, cgpa, stud_name, fathers_name, present_add, permanent_add

 

is it possible?

 


buoncri

buoncri
  • profile picture
  • Member

Posted 02 October 2015 - 07:04 AM

Look at what you have installed(grocery_crud), there are a multiple table example in the demo page.


likhon3k

likhon3k
  • profile picture
  • Member

Posted 04 October 2015 - 17:08 PM

Look at what you have installed(grocery_crud), there are a multiple table example in the demo page.

 

Lol. Brother, that is not my solution. In demo example multiple table shows in multiple grid/data tables. but I want to merge mutiple table information into a single table in GC. 

 

 suppose, I have two table. table1 has 5 field, and table2 has 5 field. I want to show 10 field in a single table that fetch data from table1 and table2.

 

Is it clear?


buoncri

buoncri
  • profile picture
  • Member

Posted 09 October 2015 - 11:17 AM

Try extending grocery_crud_model like this ? /topic/1963-simple-guide-to-executing-custom-queries/


likhon3k

likhon3k
  • profile picture
  • Member

Posted 18 October 2015 - 09:51 AM

Try extending grocery_crud_model like this ? /topic/1963-simple-guide-to-executing-custom-queries/

 

Thank You.

 

I found my solution from here:

/topic/1963-simple-guide-to-executing-custom-queries/


buoncri

buoncri
  • profile picture
  • Member

Posted 19 October 2015 - 14:03 PM

I helped someone, I am happy  ;-)