[support] Views Questions - How to show the data from custom table

[nan wich]

Do you know how to program? Any chance of going to D7? If you can code a query 
and do a bit of PHP, I'd bet you can do this without any modules faster than 
unravelling all the modules. And it would be considerably easier with the new 
object form of queries in D7.

But you get by the single table problem in Views by building relationships.
 
Nancy
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.



________________________________

From: Austin Einter

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110407/8df804ec/attachment-0001.html