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 -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 -twitter








On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards <killshot91@gmail.com> wrote:
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.com> wrote:
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/ ]