Why is it that a file filter for iCloud Numbers files doesn't return results

[nikivi]

I have this workflow. It searches Numbers files I have. I keep these files in iCloud inside Numbers directory (default).

 

 

I then have the file filter search this directory (add it to search scope):

 

 

And yet searching the file returns nothing:

 

 

Is this expected? What can I do to get around this?

[nikivi]

One other thing to note is that by default (with no Search Scope added) it also doesn’t find anything. 😞

[Vero]

@nikivi Works for me, both with the search scope set to iCloud only, and with the search scope cleared to find the files elsewhere on my Mac as well.

 

 

Check the state of the metadata for those files, and make sure you've got iCloud's "Optimised Storage" disabled, as the files won't actually be stored on your Mac if that feature is enabled.

 

Disabling Optimised Storage:

https://support.apple.com/en-us/HT207236 

 

Metadata tool to check what metadata is provided on those files:

https://cachefly.alfredapp.com/tools/AlfredMetadataTool_v1.1.zip

 

Cheers,
Vero

[nikivi]

Thank you @Vero for the reply.

I don't have optimized storage turned on. The metadata for the file is:

 

/Users/nikivi/Library/Mobile Documents/com~apple~Numbers/Documents/LA costs.numbers
Internal File Metadata
======================
 Display Name: LA costs
    Alt Names: LA costs.numbers
    File Type: com.apple.iwork.numbers.sffnumbers
     Comments: 
     Keywords: 
    Last Used: 2019-01-26 13:02:13 +0000
Raw mdls File Metadata
======================
_kMDItemDisplayNameWithExtensions  = "LA costs.numbers"
com_apple_iwork_SheetNames         = (
    2019
)
com_apple_iwork_TableNames         = (
    "Learn Anything Costs 2019"
)
kMDItemAlternateNames              = (
    "LA costs.numbers"
)
kMDItemContentCreationDate         = 2019-01-26 09:58:04 +0000
kMDItemContentCreationDate_Ranking = 2019-01-26 00:00:00 +0000
kMDItemContentModificationDate     = 2019-01-26 13:02:13 +0000
kMDItemContentType                 = "com.apple.iwork.numbers.sffnumbers"
kMDItemContentTypeTree             = (
    "com.apple.iwork.numbers.sffnumbers",
    "public.data",
    "public.composite-content",
    "public.archive",
    "public.item",
    "public.content",
    "public.spreadsheet",
    "public.zip-archive",
    "com.apple.iwork.numbers.sffnumbers",
    "com.pkware.zip-archive"
)
kMDItemDateAdded                   = 2019-01-26 13:28:48 +0000
kMDItemDateAdded_Ranking           = 2019-01-26 00:00:00 +0000
kMDItemDisplayName                 = "LA costs"
kMDItemFonts                       = (
    Helvetica,
    "HelveticaNeue-Bold",
    HelveticaNeue
)
kMDItemFSContentChangeDate         = 2019-01-26 13:02:13 +0000
kMDItemFSCreationDate              = 2019-01-26 09:58:04 +0000
kMDItemFSCreatorCode               = ""
kMDItemFSFinderFlags               = 16
kMDItemFSHasCustomIcon             = (null)
kMDItemFSInvisible                 = 0
kMDItemFSIsExtensionHidden         = 1
kMDItemFSIsStationery              = (null)
kMDItemFSLabel                     = 0
kMDItemFSName                      = "LA costs.numbers"
kMDItemFSNodeCount                 = (null)
kMDItemFSOwnerGroupID              = 20
kMDItemFSOwnerUserID               = 501
kMDItemFSSize                      = 144904
kMDItemFSTypeCode                  = ""
kMDItemInterestingDate_Ranking     = 2019-01-26 00:00:00 +0000
kMDItemKind                        = "Numbers Spreadsheet"
kMDItemLastUsedDate                = 2019-01-26 13:02:13 +0000
kMDItemLastUsedDate_Ranking        = 2019-01-26 00:00:00 +0000
kMDItemLogicalSize                 = 144904
kMDItemPhysicalSize                = 200704
kMDItemUseCount                    = 2
kMDItemUsedDates                   = (
    "2019-01-25 23:00:00 +0000"
)
kMDItemUserModifiedDate            = (
    "2019-01-26 13:02:13 +0000"
)
kMDItemUserModifiedUserHandle      = (
    501
)

Which looking at com.apple.iwork.numbers.sffnumbers seems correct.

Not sure what is wrong. Perhaps its related to this issue I still couldn't fix
 

 

[Vero]

@nikivi It's hard to say whether it's still related to that previous issue you were/are having, as it's not something I've seen from anyone else. Can Spotlight find the files?

 

Given how specific your path is, you could always remove the file types from the basic setup, as I'd imagine the Numbers app folder will only contain Numbers files. 

 

Cheers,
Vero

[Sazhen86]

I also have a similar issue where Numbers files aren't shown in Alfred file search.  I have several Numbers files in iCloud Drive and an Alfred file search will show some of them but not others.  All files are present on the local disk and the metadata looks OK.  What further information can I provide to help you look into this?