IV72359: Filtering by title not working in “My Reports”


Filtering reports by title does not work properly in “My Reports -> My Reports” or “My Reports -> Community”, if the profile language is different than the base language.

This issue happens when there are no translations available for the report title in the web_label table. You can fix this by creating a join for both web_label and rep_template_hdr tables, so that it will return the translated title from web_label if available. Otherwise, it returns the report template title by using COALESCE; then use this column to filter the title. This fixes the same issue across all tabs in the Report Manager.

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s