Filter Reports via URL Parameters in Lightning Experience

Description

How to pass URL parameters to set filter values in Lightning Experience reports. When linking to reports or when bookmarking a report, add filter value parameters to the URL to customize how the report filters when opened. For example, bookmark your opportunities report and add a filter value parameter to specify whether you see New Business or Existing Business.This feature is new in Lightning Experience. Periodically throughout your day you check your opportunities report, and after opening it, you always edit a filter to show New Business or Existing Business. (The Type filter includes both New Business and Existing Business by default.) Instead of loading the report, editing the filter, and reloading the report, create two bookmarks. One with a filter value parameter for New Business, and one with a filter value parameter for Existing Business. Take note of the opportunities report URL.

Key Steps

  1. Identify Your Report URL: Locate the report link, for example:
    https://na1.salesforce.com/one/one.app#/sObject/00OR0000000PCHYMA4/view.
  2. Understand Filter Value Parameters:
    • fv0 represents the first field filter in the report.
    • Append the parameter with a value, e.g., &fv0=New%20Business (use URI encoding for spaces).
  3. Example Full URL:
    To filter for “New Business”:
    https://na1.salesforce.com/one/one.app#/sObject/00OR0000000PCHYMA4/view&fv0=New%20Business.
  4. Best Use Case:
    Create bookmarks for different filtered views (e.g., one for “New Business” and another for “Existing Business”).

Limitations

  • Only field filters can be modified (not standard or chart filters).
  • Operators like greater than cannot be changed via URL.
  • No new filters can be added using the URL parameters.

This functionality is a quick way to streamline repetitive reporting tasks while ensuring consistency.

For further details, check the Salesforce Spring ’17 Release Notes: https://releasenotes.docs.salesforce.com/en-us/spring17/release-notes/rn_rd_reports_filter_url.htm

9 thoughts on “Filter Reports via URL Parameters in Lightning Experience”

  1. Nice blog! Is your theme custom made or did you download it from somewhere?
    A design like yours with a few simple adjustements would really make
    my blog jump out. Please let me know where you got your theme.
    Thanks ps4 games allenferguson ps4 games

  2. Hi there to all, the contents existing at this web page are actually amazing for people experience, well, keep up the
    nice work fellows. games ps4 allenferguson games ps4

  3. Hi to every body, it’s my first go to see of this website; this web site contains amazing and in fact fine
    stuff designed for visitors.

  4. This is very interesting, You’re a very skilled blogger.

    I have joined your feed and look forward to seeking more of your wonderful post.

    Also, I’ve shared your website in my social networks!

  5. Hello there, I discovered your website by the use of Google while looking for a comparable subject, your
    website came up, it seems to be good. I’ve bookmarked it in my google bookmarks.

    Hello there, simply changed into alert to your weblog through Google, and located that it is truly informative.
    I’m gonna watch out for brussels. I’ll appreciate when you continue this in future.
    Numerous folks might be benefited from your writing. Cheers!

  6. I was excited to find this page. I want to to thank you
    for your time due to this wonderful read!! I definitely savored every bit of
    it and I have you saved as a favorite to check out new information on your website.

  7. Hi, I do think this is a great site. I stumbledupon it 😉 I’m going to revisit yet again since i have
    book-marked it. Money and freedom is the greatest way to change, may you
    be rich and continue to help others. asmr 0mniartist

Comments are closed.