Forum Discussion
URL filtering in report not working
Hi VidarRadiv
1.Please check whether your column name contains spaces or table names contain spaces, there are restrictions on the expression of spaces in the URL, if so, it is best to remove the spaces.
2.Check if the Author_ID in your visual is a field from table A, does it come from another table?
3.Try changing browsers before typing.
4.Try replacing the column name with AuthorID , the symbol "_" may not be recognized in the URL.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, and thanks for the input.
In my initial post, I wrote that Author_ID holds Integer data type. (I have just for the sake of it also tried ...eq '10'. Still all 3 rows are returned where 1 is expected)
Hi VidarRadiv
1.Please check whether your column name contains spaces or table names contain spaces, there are restrictions on the expression of spaces in the URL, if so, it is best to remove the spaces.
2.Check if the Author_ID in your visual is a field from table A, does it come from another table?
3.Try changing browsers before typing.
4.Try replacing the column name with AuthorID , the symbol "_" may not be recognized in the URL.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yolo, and again thanks for your help. I started from scratch now, in order to eliminate any conversion/naming errors:
I only retrieve data from one table, "A".
Procedure:
1. Get Data: Sharepoint List
2. No renaming to Report of Sharepoint List column names ("AuthorId" is the column name given by SP)
3. No adjustment of data type (using the "original Sharepoint type for "AuthorId")
Trying to paste into the web browser (Microsoft Edge), both of the following:
[URL to report]...ReportSection?filter=A/AuthorId eq 10
[URL to report]...ReportSection?filter=A/AuthorId eq '10'
Still all 3 rows are returned on the Report in My Workspace
Pasting same two URLs into the Chrome web browser, same result....
Thx 4 yr help :-). I tried switching from the "List A" to "List B". Then the URL-filtering worked. I consider therefore yr suggestions as the solution to this problem