Querying for the size of binary files
Paskutinį kartą atnaujinta May 20, 2021 04:49:10 PM GMT | Taip pat taikoma CRX
How to search for binary files (images, pdfs etc) whose size are bigger than some amount?
Theoretically the query should look like
select * from nt:base where Image.Length>100000
The size of the binary files are not calculated automatically, so in order to run a query like that you need to pre-populate your content with an additional property where you save the size of your binary file.
Note:The length property for binary data is specified in the new JSR 283.
Prisijunkite prie savo paskyros
Greitos nuorodosPeržiūrėkite visus savo planus Tvarkykite savo planus