Summary report current filter to string and not SQL queries

PHPMaker General Discussion (PHPMaker)
1

On summary report ,I enabled current filters ,which is working well. But is there a way to display The selected fields only and not SQL statements . For instance if my search field is State and my search value is TX. I want my current filters to display

Office : TX and not
Office : select WHERE State Like TX.This may not be good for real life reports as users may not understand SQL. Imagine IN SET ,or Join. It will make no sense to them.

2

You may use Message_Showing server event to customize the message.

3

I checked the docs .The arguments I found were $msg and &type.
I know $message will be my custom message but the type in my case is confusing. What I said were ‘Success’,‘warning’ etc.
How do I implement this with current filters ?.

4

The $type only controls the CSS classes of the message, you can ignore for this case, it is the $msg that you should customize, e.g. by str_replace() or preg_replace().

5

This is working for me:

<?php
echo str_replace("`Location` = 'Accountant Generals Office'","Accountant Generals Office","`Location` = 'Accountant Generals Office'");
?>

this is what my current filters show :

 Current filters:
Location : `Location` = 'Accountant Generals Office'

str_replace() helped replaced Location = ‘Accountant Generals Office’ to Accountant Generals Office. Which is exactly what i want .

how do i use this in Message_Showing serve event pls.

will it be

if ($msg == '`Location` = 'Accountant Generals Office'')
 {$msg = str_replace("`Location` = 'Accountant Generals Office'","Accountant Generals Office","`Location` = 'Accountant Generals Office'");  
}

summary of my aim.Change this

Current filters:
Location`Location` = 'Auditor Generals Office'
Category(FIND_IN_SET('1', `Category`))
``
to

Current filters:
Location = Auditor Generals Office
Category : 1


Thank u
6

Finally i was able to fix this $this->Location->AdvancedSearch->SearchValue gets me the search parametersi can now do this below . My case solved . Thank u guys.

if ($this->Location->AdvancedSearch->SearchValue) { 
echo 'Location :' . $this->Location->AdvancedSearch->SearchValue;
}
7

When field Location- is not selected i get this printed to the screen ##init## it happens for all the fields . It seems my if statement is not working . Coz

if ($this->Location->AdvancedSearch->SearchValue) { 
 echo 'Location :' . $this->Location->AdvancedSearch->SearchValue;
 } else {echo 'empty' ;}

could not fix it. Pls helo=p