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

[Austin Einter]

Thanks Nancy.
D7, yes I need to move one day, but not now.

In D6, I am trying either through available modules or through a custom
module or PHP, want to show specific data in View.
I have basic knowledge on PHP, SQL query (learnt recently - me from a
different background C, assmbly -- etc), atleast a high level hint will help
me to great extent.

Best Regards
Austin.


On Fri, Apr 8, 2011 at 8:06 AM, nan wich <nan_wich at bellsouth.net> wrote:

>   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?
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110408/cb6019cb/attachment.html