Log Records Viewed

[scotthanes]

I have a web page with a grid component that returns many record results. However I hve my properties set to display one (1) record at a time. The user mas to press the NEXT button to go to the next record.

How do I write a log of each record viewed.

My table.open code works fine.

But I cannot find an event which will write for each record viewed.

Thanks.

[EricN]

Re: Log Records Viewed

What kind of log are you hoping to write?
1) # times viewed
2) who viewed
3) other...

What does your "table.open" currently do?

I'm not sure you can accomplish this with your current description.

Below is how I count # times a specific record has been viewed:

dim tbl as P
dim qry as P
tbl = table.open("[pathalias.adb_path]\posts")
query.filter = "Postnum="+quote(Postnum)
qry = tbl.query_create()
tbl.change_begin()
tbl.Viewsday = tbl.Viewsday+1
tbl.Viewsweek = tbl.Viewsweek+1
tbl.Viewsmonth = tbl.Viewsmonth+1
tbl.Viewstotal = tbl.Viewstotal+1
tbl.change_end(.T.)
tbl.close()

? jobtitle + " has been viewed " + lookup("[pathalias.adb_path]\posts","postnum="+ quote(postnum),"Viewstotal") + " times." + "<BR>"

I also run a daily, weekly and monthly script that clears out the viewsday, viewsweek and viewsmonth fields.

[Al Buchholz]

Re: Log Records Viewed

Have you looked at the raw log that the server will generate?

tools - application server - logging tab - raw log

[scotthanes]

Re: Log Records Viewed

Thanks for the replies.

I want to log "who" has viewed the record. This is a Web Application. My client wants to know what Customer Service Reps are looking at what Accounts.

[EricN]

Re: Log Records Viewed

If those viewing are "members" then this should be pretty easy.

Create a "Views.dbf". Create fields such as vDate, vTime, vName, vPage.

Then in the pages you want to keep track of place code such as this:
dim tbl as P
tbl=table.open("[pathalias.adb_path]\views")
tbl.enter_begin(.T.)
tbl.vDate = Date()
tbl.vTime = time("", now() ) (or just now() read up on these)
tbl.vName = registered users name taken from member's dbf or just session.__protected__userid
tbl.vPage = title of the page being viewed. Create a variable based on the page's title <title></title> to be placed here.
tbl.enter_end(.T.)
tbl.close()

Create grid or dialog to view!

[scotthanes]

Re: Log Records Viewed

This makes sense.

Question? Do I place this on the HTML page wapped in an "a5" tag...or in a validate event on the grid?

BTW: These are current members we will be logging.

[EricN]

Re: Log Records Viewed

For your situation because you said, "who" has viewed the record...probably place it in the a5w page between the <%a5 %> tags under the grid.