KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Query by picture weight
PRODUCT: 4D | VERSION: 15.x | PLATFORM: Mac & Win
Published On: June 30, 2017

The Query Editior provides a way to query picture field by it's weight as shown below:




This can also by done programatically with QUERY BY FORMULA:

1. Weighs at least

QUERY BY FORMULA ([Table];Picture size([Table]Field)>=n)


2. Weights a maximum of

QUERY BY FORMULA ([Table];Picture size([Table]Field)<=n)


n - number that can be bytes, Kbytes, Mbytes, & Gbytes




Example of finding a picture of atleast 1024 bytes:

QUERY BY FORMULA([Table_1];Picture size([Table_1]Field_picture)>=1024)