Custom SQL Queries : How to Search POS Products by Last Sold Date

Knowledge Base Article

Knowledge Base Index : Custom SQL Queries

How to Search POS Products by Last Sold Date

This article will describe how to search POS Products by the Last Sold Date.
The last sold date field in TRS is a calculated field, whenever information is requested from that field the database queries the review pos tables to find the last time that product was sold. You can do a search on the field but it does take longer then searches on other fields.

In order to do a search you must do a complex search. If you just want to search that field without any others then after clicking on the Complex Search button copy and paste the following into the blank part of the window:

where PRODLASTSOLD < "1/1/2007"

if you want to search with other criteria then click on search assistant and add your other criteria. When done click on OK. Then at the end of what the search assistant has added, add the following statement:

and PRODLASTSOLD < "1/1/2007"

in both cases change the date to the date you want to use. The examples above search for products sold before 1/1/2007 if you want to search for products sold greater then a date then change the < symbol to a > symbol.

Depending on your database and the computer this query is being run on this report will vary in how long it takes to run. It would not be uncommon at all for this report to take hours to run. It could even take an entire business day or longer. If you have other computers that run TRS then it would be a good idea to run it on one that is not the register and not critical for use during the day. If you only have TRS on one computer then it would be a good idea to run it at the end of the day and then when you come back the next morning it should be complete. If you are running it on a secondary computer it will not affect the performance of the other computers. The computer you are running it on will look as though it is locked up and if you bring up Task Manager it will say it is not responding but it is working in the background, just let it go and it will finish in time. You can run other programs on the computer while it is working.

Article Details

Date Created July 09, 2009

Author Robert Pirone

Article Options [e-Mail this Article] [Print this Article] [Bookmark Article]

© Copyright JMM Software, Inc.
http://www.jmmsoftware.com/

How to Search POS Products by Last Sold Date
This article will describe how to search POS Products by the Last Sold Date. The last sold date field in TRS is a calculated field, whenever information is requested from that field the database queries the review pos tables to find the last time that product was sold. You can do a search on the field but it does take longer then searches on other fields. In order to do a search you must do a complex search. If you just want to search that field without any others then after clicking on the Complex Search button copy and paste the following into the blank part of the window: where PRODLASTSOLD < "1/1/2007" if you want to search with other criteria then click on search assistant and add your other criteria. When done click on OK. Then at the end of what the search assistant has added, add the following statement: and PRODLASTSOLD < "1/1/2007" in both cases change the date to the date you want to use. The examples above search for products sold before 1/1/2007 if you want to search for products sold greater then a date then change the < symbol to a > symbol. Depending on your database and the computer this query is being run on this report will vary in how long it takes to run. It would not be uncommon at all for this report to take hours to run. It could even take an entire business day or longer. If you have other computers that run TRS then it would be a good idea to run it on one that is not the register and not critical for use during the day. If you only have TRS on one computer then it would be a good idea to run it at the end of the day and then when you come back the next morning it should be complete. If you are running it on a secondary computer it will not affect the performance of the other computers. The computer you are running it on will look as though it is locked up and if you bring up Task Manager it will say it is not responding but it is working in the background, just let it go and it will finish in time. You can run other programs on the computer while it is working.
Article Details
Date Created	July 09, 2009
Author	Robert Pirone
Article Options	[e-Mail this Article] [Print this Article] [Bookmark Article]
© Copyright JMM Software, Inc. http://www.jmmsoftware.com/