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

Austin Einter austin.einter at gmail.com
Fri Apr 8 01:50:18 UTC 2011


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 at 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 at 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 at 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 at gmail.com>wrote:
>>>
>>>> http://drupal.org/project/data
>>>>
>>>>   On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <
>>>> austin.einter at 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 at yahoo.com au at rediffmail.com 123456789 987654321 1/15/1975 10
>>>>> Texas B.E (Electrical) 2 John john at yahoo.com jo at rediffmail.com
>>>>> 3333333333 5555555555 2/16/1989 6 Washington DC BSC 3 Russel
>>>>> r at yahoo.com r at 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110408/6113e944/attachment.html 


More information about the support mailing list