I try to create a html report. In this report i use a loop based on a view that shows only finalized workorder.
I expect that only the finalized workorders will be shown in the report sorted and grouped like i defined in the view.
But unfortunate it is showing all the workorders. What is going wrong here.
Is it me not understanding this Rollbase functionality or is it a bug.
I was unable to reproduce the issue in my environment. Perhaps you can provide a sample code of your report?
You also mentioned that use are using this on a report. Is this loop within another loop?
In my test environment Loops through related records are using filters from View correctly. Which Rollbase version you're using?
I'm talking about the master loop in this situation. As i understand this loop is based on a view.
So i expected that the selected loop in this situation would give me all workorders with status finalized sorted by Principal and project. Sorting is ok but filtering is not what i expected.
I hope it's more clear now
I'm using 3.1.1
Yes, it is much clearer now.
Did you use the original ID of the view in the #LOOP_BEGIN token? All related records are also displayed (no filter) when I use an incorrect view ID on the #LOOP_BEGIN token.
Also, it's a good practice to use the Template Helper in determining the tokens on your html template.
I believe the template should be written like:
I think i've somehow misled you with my example. That was an example of bad cutting and pasting.
The real example should look like: