Dear All,
For the display methods we cant apply "Filter by field or filter by selection" .
But in case if we want this functionality means what is the way to achieve this.
Help me regarding this.
Regards,
Madhan
The filter creates some condition to the WHERE close in the SQL statement sent to the database - but the display method is not defined in database, so the DBMS can't use it to filter data.
The simplest answer is: You can't filter by display (and edit) methods. In some situations, you can actually filter by some other field used by the display method (e.g. you're displaying percents but the order by original numbers is the same). And you can always use a temporary table.
Another way is to return the display method into another field, i.e., create a new field,, auto declare form control field, then set the new field value = the form control field value