metacat query "files where (namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco__20240223T220602Z_reco2.root and core.file_content_status!=good)"
yields no files while
metacat query "files where (namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco__20240223T220602Z_reco2.root)"
gives me the file because core.file_content_status is not set at all for that file
metacat query "(files where namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco20240223T220602Z_reco2.root) - (files where namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco20240223T220602Z_reco2.root and core.file_content_status=good)"
metacat query "files where (namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco__20240223T220602Z_reco2.root and core.file_content_status!=good)"
yields no files while
metacat query "files where (namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco__20240223T220602Z_reco2.root)"
gives me the file because core.file_content_status is not set at all for that file
metacat query "(files where namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco20240223T220602Z_reco2.root) - (files where namespace='fardet-hd' and name=nu_dune10kt_1x2x6_1421_948_20230827T094046Z_gen_g4_detsim_hitreco20240223T220602Z_reco2.root and core.file_content_status=good)"
does give the correct response.