Hi All Thanks for great information.
Now I have downloaded Data module and enabled all the related modules as mentioned below. 1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy
(Do I need really those many modules, can I disable few from above)
I am using Drupal 6.20.
In my case, I have already tables created, data is entered through a form and saved into corresponding tables. So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed.
I am looking at Data module to scan through multiple tables with conditions (using JOIN, WHERE clause etc across tables) and show the filtered data in a view.
But I am not able to locate the related documents that will guide me how to proceed further. On google search I found http://drupal.org/node/580650 provides some information, but probably not suffiecient.
On further exploring, I went to Administer->Site Building->Data Tables. There I see a tab "Adopt tables". Under that I can see the tables created by my module (around 5 tables). Do I need to select those tables and adopt?????
After doing adopt, if I select a particulr table I see multiple tabs such as " Edit schema, Edit title, Configure search, " etc, Do I need to alter any default thing here.
And finally I saw the view creation page. I can see the tables those were created by my custom module.
Looks I can select only one table at a time. I am looking for showing the records where a particular condition is met across multiple tables. Say show all the user records where user is 40 years old and working in Texas. How can I acheive it?
Please bear with me for asking very basic questions.
Regards Austin
On Thu, Apr 7, 2011 at 7:50 PM, Ryan LeTulle bayousoft@gmail.com wrote:
nm lengthy discussion in the issues queue
Ryan LeTulle*
bayousoft http://twitter.com/bayousoft -twitter
On Thu, Apr 7, 2011 at 9:18 AM, Ryan LeTulle bayousoft@gmail.com wrote:
Anyone know if there is a Drupal 7 version planned or a promising looking equivalent?
Ryan LeTulle*
bayousoft http://twitter.com/bayousoft -twitter
On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards killshot91@gmail.comwrote:
Yes, the Data module makes your table available in a view. In fact, it creates a view for you with all of your table columns visible, and you can modify it from there.
On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:
Hi Victor Thanks for response.
The link you have given is for data module.
Does data module help to retreive the data from and show in *view*.
What I am looking at his how do we show the custom table data in view.
Regards Austin
On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane victorkane@gmail.comwrote:
http://drupal.org/project/data
On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter < austin.einter@gmail.com> wrote:
Hi All I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.
Example: *UID* *Name* *Email ID* *Alternate Email ID* *Phone number* *Alternte phone number* *DOB* *Years of experience* *Preferred work location* *Highest Qualification* 1 Austin austi@yahoo.com au@rediffmail.com 123456789 987654321 1/15/1975 10 Texas B.E (Electrical) 2 John john@yahoo.com jo@rediffmail.com 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel r@yahoo.com r@rediffmail.com 777777777 99999999 3/8/1987 8 Seoul MSC
Lets say, in a view I want to show data from this table with a condition. Let the condition is "people who work in Texas".
I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.
Regards Austin
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]