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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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
Understanding 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 ...Configuring and managing search bar
What does this page cover Learn to add and manage search elements on a page to enable speedy query search to filter records from a standalone report, or from a report embedded on a Page component. Availability Search bar can be created in all plans ...Understanding search bar element
In a nutshell The search element of a page allows users to find and locate record data on a report. It can be set up in a page to directly search a report component to filter results based on user input. Alternately, this functionality can also be ...Embedding a report in a page
What does this page cover Learn to embed Zoho Creator reports in a page component to allow users to view and manage record data from a centralized dashboard. Availability Reports can be embedded in pages in all plans of Creator. Only the super admin, ...
New to Zoho LandingPage?
Zoho LandingPage Resources