Display pdf files from different folders in Base

DSmith · December 2, 2025, 11:27am

I’m trying to return a list of pdf files from two separate parent folders in one Bases table view.

For example, If I have this folder layout:

and I have this folder:

Is it possible to display only the pdf files in a Base query which returns only the pdfs from BOTH parent folders?

I have tried this Base query (using the basic query builder)

ALL VIEWS:
Where → File is in folder:
file.inFolder(“Fruits”) and File.inFolder(“Vegetables”)

THIS VIEW
All the following are true
where → file extension → ends with → pdf

I get error messages in the ALL VIEWS when I try to type the second folder into the box.

Maybe it isn’t possible, or maybe I’m doing something wrong!

Any help appreciated.

Thanks

Zodian · December 2, 2025, 11:40am

Try OR instead of AND.

DSmith · December 2, 2025, 2:41pm

Thanks @Zodian,

Using OR worked !

This is how I did it:

Thanks !