Track Utilization

Hello, I would like to set up a page where we can track all user logins and also track what searches they conduct in a session. From reading past discussions, I roughly understand that I need to set up a table for this, as well as update record behavior. Is there any way I could get a little more assistance as to how to go about this? How do I set up the table, or should I do multiple tables? Thanks!

I think you would want to have 2 tables, one to track the logins, and another to track the searches for the session.

the structure for the table to track logins would be something like:

logins:
loginID - Primary key
loginUserID - relates to the users.userID table


on the login page, the the security assist authenticate user behavior will store the logged in uses ID in a session. make sure the authenticate user behavior does not redirect to another page, then add an insert behavior to store the logged in users ID using the session variable binding.

make sure the insert code gets added after the security assist authenticate user code.

the insert behavior will also store a session with the loginID value for the was created.

for tracking the searches, you would need a table with the following structure:
searchID - Primary Key
searchLoginID - relates to the logins.loginID
search Terms

on the results page, you would add another insert behavior to capture the search. use the loginID session variable for the searchLoginID column.

you will need to add bindings to the bindings panel depending on the search form method, POST or GET for the search form, then use those bindings in the insert behavior.

If I must remove the page redirect before inserting behavior on login page, how then do I get the page to redirect after inserting behavior?

Set the redirect to occur in the insert behavior

the order of execution should be:
-authenticate user
-insert

if the authenticate user behavior redirects, it wont be able to execute the insert

so set the redirect to happen in the insert behavior.

Ok, thank you. I believe the issue is that I am not properly understanding how to insert behavior. Is there any way you could explain this is more detail? Thank you very much for your help so far!

add the insert record behavior by opening the server behaviors panel, clicking the plus button, and select Webassist -> Data Assist -> Insert Record -> Insert Single record

Thank you, that was the issue. The other issue, I don't understand how to add bindings to the binding panel for the search form (which was GET). Any way I could get some clarification there, as well?

The get method passes the form using URL variables.

make note of the names of each element in the search form

go to the bindings panel, click the plus button and URL variable, set the name to the name of the first form element. repeat for each element in the search form.