I’m new to dynamo and trying to no avail to get a list in excel of all the filters used in my project specifying in which view it is used.
The post I used as inspiration is this one : Listing Revit View Filters by the Views where they are used - Packages - Dynamo (dynamobim.com)
I’ve tried other examples but nothing came close to what I wanted. I did also find how to delete the unused filters which was great, but can’t get a list of the used filters.
The result I have with my trial, is basically a list of all the filters and the another list of the views, however it doesn’t seem to be corelated, and I don’t understand why.
I also don’t understand the logic in the main post, because to me it seems that the list are separated, however when they are put back togheter they have no correlation to each-other.
Would you show and example of how you would like to see the information in Excel? It would help, but chances are you will need to Join the Key values into the Groups and then Transpose the vales for export.
If I export directly the groups from List.groupByKey it does something weird where it re-exports and re-wirtes everything on the first line.
After some more digging, I found the List.transpose which allowed me to export the list of filters to excel, by collumn. as in A_Export List Transpose like so : EXPORT 1
Then I noticed it’s divided in 46 lines, so the number of views.
So I just exported the number of views in a separate document and combined them manually like so
COMBINING EXPORT 1 and EXPORT 2 IN EXCEL
I’d like to combine them from the first export
Now I notice that the views, are actually view types and not the actual view where it is used.
I also notice that some of the views types have no filters, is that correct or an error?
What I’m hoping to achieve is a table a bit reversed like so (DESIRED FINAL RESULT)
Showing the view name instead of the view type.
Ideally, I would also like to know the view template if said filter is in a view template that is not applied to any view.
Because I couldn’t add multiple images, I combined them in one :