Search Screen: seach not working properly

[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

[admin]

Rui,

Sorry, I don't understand what you are mean.

Steven

[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

[admin]

rui,

Can you show the whole screen for the whole of QC?

Steven

[ruiascensao]

Hi Steven,

Here you have all the interface.

Thanks for your help!

Best Regards,
Rui

[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

[ruiascensao]

Hi Steven,

It was the "WHERE" cause statement ....

It is correct now!

Thanks.

Best Regards,
Rui

[admin]

Excellent!