Home » Forums » Off Topic - Non Ubercart Issues » General Off Topic Discussion
5 replies [Last post]
Mon, 03/28/2011 - 19:31
pxlgraf
pxlgraf's picture
Offline
Joined: 03/28/2011
Juice: 10
Was this information Helpful?

I would like to create a View that shows the last product viewed by a user. I am familiar with the process of creating Views but I'm not sure how to access the information of the 'last product'. Any help would be greatly appreciated.

Top
Mon, 04/04/2011 - 00:24
#1 View page
Sara Martin (not verified)
Sara Martin's picture
Re: Create View of Last Product Viewed

CREATE VIEW [Current Product List] AS
SELECT Product ID,Product Name
FROM Products
WHERE Discontinued=No
query the view above as follows
SELECT * FROM [Current Product List]

Top
Mon, 04/04/2011 - 09:09
#2 View page
pxlgraf
pxlgraf's picture
Offline
Joined: 03/28/2011
Juice: 10
Re: Re: Create View of Last Product Viewed

thank you so much for your response,but could you elaborate a little more? I don't know how to create a View based on what you sent.

thanks, again....

Top
Tue, 11/01/2011 - 08:18
#3 View page
make-online-shop
make-online-shop's picture
Offline
Joined: 01/01/2011
Juice: 369
Re: Create View of Last Product Viewed

Easiest way to show LATEST VIEWED PRODUCTS list ?

Hi,

Can you tell me what is the easiest way to show the latest viewed products list now ?

Thanks a lot.

Top
Fri, 01/20/2012 - 19:55
#4 View page
end user
end user's picture
Offline
Joined: 01/11/2008
Juice: 1685
Re: Re: Create View of Last Product Viewed

I haven't tried it yet but look/read here http://jan.tomka.name/blog/list-recently-viewed-nodes-drupal

Top
Sat, 01/28/2012 - 13:50
#5 View page
make-online-shop
make-online-shop's picture
Offline
Joined: 01/01/2011
Juice: 369
Re: Re: Re: Create View of Last Product Viewed

Thanks, I will check it soon.

Top