5 replies [Last post]
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.

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]

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....

make-online-shop's picture
Offline
Joined: 01/01/2011
Juice: 511
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.

end user's picture
Offline
Joined: 01/11/2008
Juice: 1738
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

make-online-shop's picture
Offline
Joined: 01/01/2011
Juice: 511
Re: Re: Re: Create View of Last Product Viewed

Thanks, I will check it soon.