Alpha DevCon 2018
Results 1 to 5 of 5

Thread: Track user generated queries

  1. #1
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,430

    Default Track user generated queries

    Looking for an event that tracks when a user defines a query/quick filter and executes it.

    Then I can track what they are looking for and build a more efficient structure and code to support it.

    Of course I never remember what I've queried for, so I don't expect users to remember either...
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,846

    Default Re: Track user generated queries

    Maybe a combination of events?

    Capture the current query settings with mru_query() in the oninit event. Save to variable.
    In the onfetch event, check to see if the mru_query() values are different.
    Do something if they are and reset the original variable to the new mur_query() settings.

  3. #3
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,430

    Default Re: Track user generated queries

    Yes I had a similar idea, but found that the onfetch doesn't fire if you are already pointing at a row that the query result will end up on.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,846

    Default Re: Track user generated queries

    Yes, noticed that but...

    Depending on the application, what is the probablity that they won't scroll through the query results if they felt the need to query?

  5. #5
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,430

    Default Re: Track user generated queries

    low, unless they want to create an exception and cause alarm and lack of confidence.. but I know what you are saying.....
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. How can I track when a user logs off (other than using the WAS log)?
    By Jay Talbott in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 02-03-2011, 05:44 PM
  2. Track the computer where the user last logged on
    By Scott Kurimski in forum Alpha Five Version 10 - Desktop Applications
    Replies: 13
    Last Post: 10-13-2010, 12:53 PM
  3. Give a user the facility to create queries / reports
    By jacsolutions in forum Application Server Version 10 - Web/Browser Applications
    Replies: 7
    Last Post: 09-20-2010, 04:42 PM
  4. A5 Generated Errors
    By forskare in forum Alpha Five Version 4
    Replies: 7
    Last Post: 11-30-2001, 05:19 AM
  5. User-entered dates within Queries
    By Christine Fenson in forum Alpha Five Version 1
    Replies: 1
    Last Post: 04-26-2000, 11:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •