Customized search component for report data, using pages
Requirement
Provide a search component for users to search for the required data. Data is fetched from reports based on the search keyword.
Use Case
A library or a book management system wants to allow for searching. Any customer who wants to search for a particular genre of books can do so easily with the available category listings under the main search.
Steps to follow
2. Rename the
created
form
to
'Book'
and the report to
'Books'.
3. We shall now
create a function
to get
all the genres of the
Books
uploaded. We'll use this listing to show our category listing.
4. Add the below
Deluge code in the
Deluge editor to get the genres.
- list getGenres()
-
{
-
- //return a list of genres, hence return type is list
- //get all distinct genres available
- genres = Book[ID != null].Genre.getAll().distinct();
- return genres;
- }
The above code will return the list of all distinct genres available.
6. Drag a search element and mark the placeholder as
Title/Author. Click the
Configure
icon and select the
Search result component
as
Report
and select the
Books
report.
7. Set the criteria to search the
Books
report for the search string in title or author.
The configuration of the search element is as follows:
8. Drag an
HTML snippet
below the Search Element.
9. Let's create a list of the genres with corresponding links to the
Books
database filtering records that match the current genre.
- <%{
- //Get all the genres from function created in Step 3 & 4
- genres = thisapp.getGenres();
- for each genre in genres
- {
- %>
- <!- Create an HTML anchor tag to the Books report filtering appropriately -->
- <a class="genre-link" href="#Report:Books?Genre=<%=genre%>"><%=genre%></a><br/>
- <style>
- <!-- Style for the anchor tags -->
- a.genre-link {
- display: inline-block;
- width: 115px;
- height: 25px;
- padding: 10px;
- padding-left: 20px;
- text-align: left;
- border-radius: 5px;
- font-weight: bold;
- line-height: 25px;
- }
- </style>
- <%
- }
- }%>
10. Finally, although optional, we shall
publish the
Search for Books
page and
Books
report to make it available for all users to search and check the availability.
See how it works
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Understand Pages
1. What Does This Page Cover? Learn about pages and how they are used to create user-friendly, customized dashboards for your applications. Via these dashboards, you can display dynamic elements and visually represent the data stored in Creator. 2. ...Create a search functionality to dynamically filter a report
Requirement Create a search functionality for users to find specific records based on their search queries. Use Case An order management app is used by a business to store its customer details, and by billing agents to order products. There are three ...Filter report using dynamic values from a function
Requirement When a user accesses a report, data is filtered based on the logged-in user's role so that only the required details are visible to the user. Use Case An employee management system has two forms, Department and Employees. The Department ...How to copy subform data to another subform using a report action
The values in a subform of a record can be copied to another form's subform using Deluge within the report actions. This allows seamless transfer of subform data between forms, ensuring consistency. For example, consider a Zoho Creator resource ...Showing only logged in user's records in a filtered report
Requirement Display only the relevant records for the logged in user, based on the customer email, to ensure the security and privacy of the data from other users in the application. Use Case An order management application has the Order form ...
New to Zoho LandingPage?
Zoho LandingPage Resources