Page 1 of 1
Search Screen: seach not working properly
Posted: Mon Sep 03, 2012 4:49 pm
by ruiascensao
Hi,
In every my search screens when I search for a "Job Number" it only shows this "Job Number".
But there is one that when I do this it only highlights.
Why this happens?
Thank you!
Best Regards,
Rui
Re: Search Screen: seach not working properly
Posted: Mon Sep 03, 2012 7:31 pm
by admin
Rui,
Sorry, I don't understand what you are mean.
Steven
Re: Search Screen: seach not working properly
Posted: Tue Sep 04, 2012 6:42 pm
by ruiascensao
Hi Steve,
When I search a job number I want just to see that record on the search screen.
But now what I get is the job number highlighted.
How can I solve this?
Thanks
Rui
Re: Search Screen: seach not working properly
Posted: Wed Sep 05, 2012 5:21 am
by admin
rui,
Can you show the whole screen for the whole of QC?
Steven
Re: Search Screen: seach not working properly
Posted: Fri Sep 07, 2012 9:21 am
by ruiascensao
Hi Steven,
Here you have all the interface.
Thanks for your help!
Best Regards,
Rui
Re: Search Screen: seach not working properly
Posted: Fri Sep 07, 2012 9:36 am
by admin
Rui,
If you are logged in as globeadmin, you can view the html source code and find the sql that built the Browse Form.
eg.
Code: Select all
SELECT tra_number, tra_date, tra_type, cus_name, sli_description, tra_amount, tra_tax, tra_total, tra_outstanding, transaction_id FROM transaction INNER JOIN customer ON transaction.tra_customer_id = customer.customer_id LEFT JOIN zzsys_list ON transaction.tra_posted = zzsys_list.sli_option WHERE (sli_name = 'answer') AND (tra_type = 'I' OR tra_type = 'C') AND (
(
(tra_number LIKE "%1500%")
OR (DATE_FORMAT(tra_date,"%d-%b-%y") LIKE "%1500%")
OR (tra_type LIKE "%1500%")
OR (cus_name LIKE "%1500%")
OR (sli_description LIKE "%1500%")
OR (REPLACE(FORMAT(tra_amount,2), ",", "") LIKE "%1500%")
OR (REPLACE(FORMAT(tra_tax,2), ",", "") LIKE "%1500%")
OR (REPLACE(FORMAT(tra_total,2), ",", "") LIKE "%1500%")
OR (REPLACE(FORMAT(tra_outstanding,2), ",", "") LIKE "%1500%") ))
This should give you an idea of why this is happening.
Steven
Re: Search Screen: seach not working properly
Posted: Fri Sep 07, 2012 10:40 am
by ruiascensao
Hi Steven,
It was the "WHERE" cause statement ....
It is correct now!
Thanks.
Best Regards,
Rui
Re: Search Screen: seach not working properly
Posted: Wed Sep 12, 2012 6:44 am
by admin
Excellent!