Databases
StackOverflow2013
Postsdbo
PODisplay data from Custom Query(Joined tables) in liferay search container
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplay data from Custom Query(Joined tables) in liferay search container
    primarykey
    data
    text
    <p>I have followed <a href="http://www.liferay.com/community/wiki/-/wiki/Main/Custom+queries+in+Liferay+5.2" rel="nofollow" title="Liferay Wiki: Custom queries in Liferay 5.2">this wiki</a> and have successfully built a custom query.</p> <p>It works fine. I have used a join between tables.</p> <p>My question is how do I display it on a jsp using liferay search container since className in search container requires one model class.</p> <p><em><strong>EDIT:</em></strong><br> What I have tried till now is this:</p> <pre class="lang-java prettyprint-override"><code>&lt;% getAttendanceData attName = new getAttendanceData(); List&lt;Object[]&gt; displayAttListName = AttendanceLocalServiceUtil.findAttendance(); ArrayList name = new ArrayList(); ArrayList title = new ArrayList(); ArrayList status = new ArrayList(); ArrayList remarks = new ArrayList(); for(Object[] att:displayAttListName) { name.add(att[0]); title.add(att[1]); status.add(att[2]); remarks.add(att[3]); } %&gt; &lt;liferay-ui:search-container delta="20" emptyResultsMessage="No Results Found"&gt; &lt;liferay-ui:search-container-results total="&lt;%= displayAttListName.size() %&gt;" results="&lt;%= ListUtil.subList(displayAttListName , searchContainer.getStart(), searchContainer.getEnd()) %&gt;" /&gt; &lt;liferay-ui:search-container-row modelVar="search" className="java.lang.Object"&gt; &lt;% for(Object displayName:name) { %&gt; &lt;liferay-ui:search-container-column-text name='studName' value = '&lt;%=String.valueOf(displayName)%&gt;' href=""&gt; &lt;/liferay-ui:search-container-column-text&gt; &lt;% } %&gt; &lt;/liferay-ui:search-container-row&gt; &lt;liferay-ui:search-iterator/&gt; &lt;/liferay-ui:search-container&gt; </code></pre> <p>What I have done above displays each of the 10 names 10 times in a column.<br> I want the names to appear on each new row. How shoould I modify the above code?</p> <p><em><strong>EDIT 2</em></strong><br> Considering the <code>name</code> array defines earlier I did the following:</p> <pre class="lang-java prettyprint-override"><code>&lt;liferay-ui:search-container-column-text name="employee name" href = ""&gt; &lt;%=name.getClass().getDeclaredFields().toString() %&gt; &lt;/liferay-ui:search-container-column-text&gt; </code></pre> <p>With the above, I am getting the result something like: <code>[Ljava.lang.reflect.Field;@195f1af</code> on each row.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRasabihari Kumar
    1. USSeeya K
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat do you get from the 'Select'. Usually, in Service builder Custom Queries, you get an array of instances of one Class/entity/Table
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. USyannicuLar
    2. CO@ yannicuLar: I get data from two tables. I have taken a join: select concat(stud.studFname , ' ' , stud.studLname) as studName , stud.studTitle, attendance.attRemarks, attendance.attStatus from student stud left outer join attendance attendance on stud.studId = attendance.studId and attendance.attDate = '2013-05-20'; I have taken inner join. How do I display the result of the above query in liferay search container? Like I said I am not sure what to put as className
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. USSeeya K
    3. CO@ yannicuLar: : Sorry i have taken left outer join.. not inner join.. like i said in previous comment
      singulars
      1. PODisplay data from Custom Query(Joined tables) in liferay search container
      1. USSeeya K
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload