Multimedia Query Filter Bug
Posted: 05 Feb 2011 11:57
I wanted to find out how many Multimedia Records linked to jpeg format files.
I created a Multimedia Query with a few Columns:
Record %OBJE%
Format %OBJE.FORM%
Running the Query lists all the Records with their Formats OK.
Then I added a Rows Filter:
Add if %OBJE.FORM% matches jpeg
Now running the Query lists nothing!!!!!
I have checked this misbehaviour on both FH V4.1.3 and FH RO V3.0.1.
Searching the Forum suggests it has not been reported before.
For FH V4.1.3 the workaround is to use Rows Filter:
Add if =ContainsText(%OBJE.FORM%,'jpeg',STD) is true
This correctly lists the Records with their Format = jpeg OK.
ID:4975
I created a Multimedia Query with a few Columns:
Record %OBJE%
Format %OBJE.FORM%
Running the Query lists all the Records with their Formats OK.
Then I added a Rows Filter:
Add if %OBJE.FORM% matches jpeg
Now running the Query lists nothing!!!!!
I have checked this misbehaviour on both FH V4.1.3 and FH RO V3.0.1.
Searching the Forum suggests it has not been reported before.
For FH V4.1.3 the workaround is to use Rows Filter:
Add if =ContainsText(%OBJE.FORM%,'jpeg',STD) is true
This correctly lists the Records with their Format = jpeg OK.
ID:4975