SimplyPats User Forum

SimplyPats Portable Appliance Testing Software
It is currently Sat Dec 16, 2017 12:34 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Thu Jun 19, 2014 4:45 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 23, 2008 11:47 pm
Posts: 1087
Location: Cornwall
Advanced Searching for PAT Testing Records

Following a request by a SimplyPats user whose customer wanted them to record the value of appliances tested so that they could produce a report of items with a value in excess of 100 pounds, we have added a new Advanced Search Screen in SimplyPats 7.0.4.

The company doing the PAT testing recorded the value of tested items in the Notes field on their PAT test machine. On download the Notes field on the PAT tester was assigned to the Notes field within SimplyPats.

Using the new screen, they could search for PAT test records where the value in the Notes field was greater than 100. The screen selects those records on the Main Grid within SimplyPats allowing you to either save the selected records to a seaparate file, or print any of the reports based on the selected data.

Attachment:
File comment: Find PAT testing records based on advanced search criteria.
advanced_search_records.jpg
advanced_search_records.jpg [ 29.9 KiB | Viewed 3419 times ]


Types Of Search

There are a range of search types (operators) that you can use to search for items of information. This includes mathematical comparisons, Greater Than, Less Than, Equal To, etc. as well as word comparisons such as Starts With, Ends With or Contains.

Attachment:
File comment: Mathematical and Text Searches On PAT Testing Records
advanced_search_records_operators.jpg
advanced_search_records_operators.jpg [ 22.2 KiB | Viewed 3419 times ]


Searching For Dates

If you are searching for Electrical PAT Test Dates or Visual Inspection PAT Test date fields within SimplyPats, you are prompted to use a date picker control to enter a value, rather than a text box.

Attachment:
File comment: Searching for PAT Test Visual Inspection Dates and Combined Inspection Dates.
advanced_search_records_dates.jpg
advanced_search_records_dates.jpg [ 7.69 KiB | Viewed 3419 times ]


Searching A Selection of Records

When you have searched through your PAT testing records for all those items meeting a certain criteria e.g. Where the Notes field contains a value of 100 pounds or greater, you can then perform subsequent searches on those selected items, e.g. Find those items whose location is the Kitchen.

This process can be repeated many times so narrowing down the final items you need to isolate.

As has been mentioned above you can then either save the selected records to a new file, or print any of the SimplyPats printed reports based on the selected records.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group