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
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:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Bigin?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
Related Articles
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 ...Understand pages
As an application user, when you have collected enough data using multiple forms, you go for insights, using the Reports component. Now, the primary rationale of collecting such vast amounts of data and generating reports is to measure, monitor and ...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 ...Capture data using NFC
Requirement Capture data from NFC supported tags. Use Case An organization wants a mechanism where its employees can submit feedback about its cafeteria and restrooms by tapping their NFC- enabled ID cards against the feedback collecting ...