Jump to content
  • 0

How to record zero results?


acraigl
 Share

Question

I have a knowledge base application. I would like proactively improve this by recording in a database if the search returned zero results. I'm already saving the time/date and search string... how can I add whether results were returned to the user or not?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

To archive it you separated your search and report DataPage into two different pages - submission for search and predefined criteria for report. You have to create a separate table for first DataPage, it will collect information about all searches - search data, search time and Yes/No field, that will be yes if no records found, etc, you need add autonumber to this table as well. Then you may customize your No Records found message - add JS to it:

location.href="?id=[@InsertRecord]";

You may do it in localization wizard.

And you need to create Single Record Update DataPage, based on the table you are using for collecting search information, find record thorough unique id (autonumber from the table and id parameter)

You have to use auto-submit script to submit this form, and you may add Yes/No field from the table, use hidden form element, checked by default.

And finally you may customize Successful submission message to No Records Found.

So, when user found no records, you localized message will redirect you to update form (and will pass unique id parameter), your update form will be updated (and yes/no field will be changed to yes) and a user will see message No Records Found. You may also hide submission button on your update form, so user doesn't see it.

Hope this helps.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...