<div>Hi All</div>
<div>Thanks for great information.</div>
<div> </div>
<div>Now I have downloaded Data module and enabled all the related modules as mentioned below.</div>
<div>1. Schema , 2. Search, 3. Data, 4. Data Admin UI, 5. Data Node, 6. Data search and 7. Data Taxonomy</div>
<div> </div>
<div>(Do I need really those many modules, can I disable few from above)</div>
<div> </div>
<div>I am using Drupal 6.20.</div>
<div> </div>
<div>In my case, I have already tables created, data is entered through a form and saved into corresponding tables.</div>
<div>So for table creation, deletion, storing data into table, deleting data from table is done by a custom module already developed.</div>
<div> </div>
<div>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> </div>
<div>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">http://drupal.org/node/580650</a> provides some information, but probably not suffiecient.</div>
<div> </div>
<div>On further exploring, I went to Administer->Site Building->Data Tables.</div>
<div>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> </div>
<div>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> </div>
<div>And finally I saw the view creation page. I can see the tables those were created by my custom module.</div>
<div> </div>
<div>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>Please bear with me for asking very basic questions.</div>
<div> </div>
<div>Regards</div>
<div>Austin</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Thu, Apr 7, 2011 at 7:50 PM, Ryan LeTulle <span dir="ltr"><<a href="mailto:bayousoft@gmail.com">bayousoft@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">nm lengthy discussion in the issues queue<br clear="all"><b>
<div><b><br></b></div>Ryan LeTulle</b><br><br>
<div>> <font color="#666666"><a href="http://twitter.com/bayousoft" target="_blank">bayousoft</a> -twitter</font></div>
<div>
<div></div>
<div class="h5">
<div><br></div>
<div><img><br></div>
<div>
<div><br></div><br><br></div><br><br><br>
<div class="gmail_quote">On Thu, Apr 7, 2011 at 9:18 AM, Ryan LeTulle <span dir="ltr"><<a href="mailto:bayousoft@gmail.com" target="_blank">bayousoft@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Anyone know if there is a Drupal 7 version planned or a promising looking equivalent?<br clear="all"><b>
<div><b><br></b></div>Ryan LeTulle</b><br><br>
<div>> <font color="#666666"><a href="http://twitter.com/bayousoft" target="_blank">bayousoft</a> -twitter</font></div>
<div>
<div></div>
<div>
<div><br></div>
<div><img><br></div>
<div>
<div><br></div><br><br></div><br><br><br>
<div class="gmail_quote">On Thu, Apr 7, 2011 at 9:10 AM, Steve Edwards <span dir="ltr"><<a href="mailto:killshot91@gmail.com" target="_blank">killshot91@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div style="WORD-WRAP: break-word">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.
<div><br>
<div>
<div>
<div></div>
<div>
<div>On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:</div><br></div></div>
<blockquote type="cite">
<div>
<div></div>
<div>
<div>Hi Victor</div>
<div>Thanks for response.</div>
<div> </div>
<div>The link you have given is for data module.</div>
<div> </div>
<div>Does data module help to retreive the data from and show in <strong>view</strong>.</div>
<div> </div>
<div>What I am looking at his how do we show the custom table data in view.</div>
<div> </div>
<div>Regards</div>
<div>Austin<br><br></div>
<div class="gmail_quote">On Thu, Apr 7, 2011 at 3:49 PM, Victor Kane <span dir="ltr"><<a href="mailto:victorkane@gmail.com" target="_blank">victorkane@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"><a href="http://drupal.org/project/data" target="_blank">http://drupal.org/project/data</a><br><br>
<div class="gmail_quote">
<div>
<div></div>
<div>On Thu, Apr 7, 2011 at 7:03 AM, Austin Einter <span dir="ltr"><<a href="mailto:austin.einter@gmail.com" target="_blank">austin.einter@gmail.com</a>></span> wrote:<br></div></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div>
<div>Hi All</div>
<div>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.</div>
<div> </div>
<div>Example:</div>
<div>
<table style="WIDTH: 631pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="840">
<colgroup>
<col style="WIDTH: 43pt" width="57">
<col style="WIDTH: 50pt" width="67">
<col style="WIDTH: 59pt" width="79">
<col style="WIDTH: 64pt" width="85">
<col style="WIDTH: 70pt" width="93">
<col style="WIDTH: 68pt" width="90">
<col style="WIDTH: 63pt" width="84">
<col style="WIDTH: 54pt" width="72">
<col style="WIDTH: 83pt" width="110">
<col style="WIDTH: 77pt" width="103"></colgroup>
<tbody>
<tr style="MIN-HEIGHT: 46.5pt" height="62">
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: #dbe5f1; MIN-HEIGHT: 46.5pt; WIDTH: 43pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" height="62" width="57">
<strong><font color="#ff0000" face="Calibri">UID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="67"><strong><font color="#ff0000" face="Calibri">Name</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 59pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="79"><strong><font color="#ff0000" face="Calibri">Email ID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 64pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="85"><strong><font color="#ff0000" face="Calibri">Alternate <br>
Email ID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 70pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="93"><strong><font color="#ff0000" face="Calibri">Phone number</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 68pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="90"><strong><font color="#ff0000" face="Calibri">Alternte <br>
phone <br>number</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="84"><strong><font color="#ff0000" face="Calibri">DOB</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 54pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="72"><strong><font color="#ff0000" face="Calibri">Years of <br>
experience</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 83pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" width="110"><strong><font color="#ff0000" face="Calibri">Preferred work location</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 77pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #0070c0 1.5pt solid" width="103"><strong><font color="#ff0000" face="Calibri">Highest Qualification</font></strong></td>
</tr>
<tr style="MIN-HEIGHT: 30.75pt" height="41">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 30.75pt; WIDTH: 43pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="41" width="57"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="67"><font face="Calibri">Austin</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="79"><a href="mailto:austi@yahoo.com" target="_blank"><font face="Calibri">austi@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="85"><a href="mailto:au@rediffmail.com" target="_blank"><font face="Calibri">au@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="93"><font face="Calibri">123456789</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="90"><font face="Calibri">987654321</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="84"><font face="Calibri">1/15/1975</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="72"><font face="Calibri">10</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="110"><font face="Calibri">Texas</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" width="103"><font face="Calibri">B.E (Electrical)</font></td></tr>
<tr style="MIN-HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 30pt; WIDTH: 43pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="40" width="57"><font face="Calibri">2</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="67"><font face="Calibri">John</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="79"><a href="mailto:john@yahoo.com" target="_blank"><font face="Calibri">john@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="85"><a href="mailto:jo@rediffmail.com" target="_blank"><font face="Calibri">jo@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="93"><font face="Calibri">3333333333</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="90"><font face="Calibri">5555555555</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="84"><font face="Calibri">2/16/1989</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="72"><font face="Calibri">6</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="110"><font face="Calibri">Washington DC</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" width="103"><font face="Calibri">BSC</font></td></tr>
<tr style="MIN-HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; MIN-HEIGHT: 30pt; WIDTH: 43pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height="40" width="57"><font face="Calibri">3</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="67"><font face="Calibri">Russel</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="79"><a href="mailto:r@yahoo.com" target="_blank"><font face="Calibri">r@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="85"><a href="mailto:r@rediffmail.com" target="_blank"><font face="Calibri">r@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="93"><font face="Calibri">777777777</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="90"><font face="Calibri">99999999</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="84"><font face="Calibri">3/8/1987</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="72"><font face="Calibri">8</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width="110"><font face="Calibri">Seoul</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" width="103"><font face="Calibri">MSC</font></td></tr></tbody></table>
</div>
<div> </div>
<div> </div>
<div> </div>
<div>Lets say, in a view I want to show data from this table with a condition.</div>
<div>Let the condition is "people who work in Texas".</div>
<div> </div>
<div>I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.</div>
<div> </div>
<div>Regards</div>
<div>Austin</div><font color="#888888">
<div> </div></font><br></div></div>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote></div><br></div></div>-- <br>
<div>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</div></blockquote></div><br></div></div><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</blockquote></div><br></div></div></blockquote></div><br></div></div><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>