<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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>On Apr 7, 2011, at 4:25 AM, Austin Einter wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><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">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 class="h5">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 class="h5">
<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>
-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</blockquote></div><br></div></body></html>