Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Filter by File Type

Avatar

Level 10
Hi I am putting together a Document Report to show all the videos that have been completed in the last month. I am getting the report I need except that I want to filter by "type" in order to eliminate the PDF and Word documents that are also in these Issues, so that I only show files of "type" ".mp4 File" or "MOV Movie" I cannot figure out where this "type" comes from, it's not a field I can find to filter on, but I do have it in my View as a column and it looks like this: listsort=nested(currentVersion).val(ext) namekey=filetype.abbr querysort=currentVersion:ext valuefield=currentVersion:documentTypeLabel valueformat=HTML width=50 I've tried to filter on every field I can find that has the word "type" in it but nothing is working. Also, if I have multiple filters for "type" equals -- do I have to make 2 statements with all the parameters and an "or" in between? Or is there a way to filter on 2 "types"? (In my other data world we have something called "in" which means the result can be equal to any of the choices listed e.g. {DocumentType} IN ".mp4 File","MOV Movie" Thanks! Jill Ackerman
0 Replies