<div>Thanks Nancy. </div>
<div>D7, yes I need to move one day, but not now. </div>
<div><br>In D6, I am trying either through available modules or through a custom module or PHP, want to show specific data in View.<br>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.</div>
<div> </div>
<div>Best Regards</div>
<div>Austin.<br></div>
<div> </div>
<div> </div>
<div class="gmail_quote">On Fri, Apr 8, 2011 at 8:06 AM, nan wich <span dir="ltr"><<a href="mailto:nan_wich@bellsouth.net">nan_wich@bellsouth.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<div></div>
<div>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.</div>
<div> </div>
<div>But you get by the single table problem in Views by building relationships.<br> </div>
<p><font color="#ff007f" size="4" face="bookman old style, new york, times, serif"><em><strong>Nancy</strong></em></font></p>
<p> </p>
<p><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></p>
<div><br></div>
<div style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><br><font size="2" face="Tahoma">
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<hr size="1">
</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><b><span style="FONT-WEIGHT: bold">From:</span></b> Austin Einter</div></font>
<div class="im">
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">Now I have downloaded Data module and enabled all the related modules as mentioned below.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">(Do I need really those many modules, can I disable few from above)</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">I am using Drupal 6.20.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">In my case, I have already tables created, data is entered through a form and saved into corresponding tables.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">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.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">But I am not able to locate the related documents that will guide me how to proceed further. On google search I found <a href="http://drupal.org/node/580650" rel="nofollow" target="_blank">http://drupal.org/node/580650</a> provides some information, but probably not suffiecient.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">On further exploring, I went to Administer->Site Building->Data Tables.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">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?????</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">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.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">And finally I saw the view creation page. I can see the tables those were created by my custom module.</div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"> </div>
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">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?</div>
</div></div></div></div><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>