824 OR not working on Folder filter

[exterminador]

Hi!

 

It seems the OR operator doesn't work when filtering Folders. I'm trying to display elements from two folders by using the following filter:

 

 

But I get "No items match your search criteria". I noticed the default operator is "equals" but there is no option to choose that operator from the dropdown (it only shows: "matches", "does not match", "is not empty" and "empty".

 

Found this on the server logs:

 

2013-06-20 03:02:33,915 [23] DEBUG PicaJet.Daminion.Service.Utils.CreateMediaItemsBookCommand [(null)] - Start: (24175) - 1 - 1 - 9 - 0 - 1000
2013-06-20 03:02:33,931 [23] DEBUG SQL [(null)] - select distinct m.ID, m.Name, m.MediaFormatUi, m.Deleted, m.HashCode, m.ID_ImportSession, m.ID_File, b_a01.ImportTime, m.ID_Event as ID_Event, subject.Description as Description, m.ID_User as ID_User, m.ID_SystemFlag as ID_SystemFlag, m.ID_ColorLabel as ID_ColorLabel, m.ID_Rating as ID_Rating, image.ImageOrientation as ImageOrientation from MediaItems m 
left join ImportSession b_a01 on m.Id_ImportSession = b_a01.Id
left join subject subject on m.ID = subject.ID_MediaItem
left join image image on m.ID = image.ID_MediaItem where not m.Deleted
and 
(exists (select 1 from Folder_File where ID_Value = @9506fe35ce4345aaabe68d270bf1ed82 and m.ID = ID_MediaItem) Or a_a1.ParentValueId in (select Id from Folder_Table where Value = @5443a78361c44362a3ae1adf1eaca917) and a_a1.Value = @a6e1eb5c12cc4b159a03805c2de5a585 )   
order by b_a01.ImportTime Desc (@9506fe35ce4345aaabe68d270bf1ed82=1852, @5443a78361c44362a3ae1adf1eaca917=htpc, @a6e1eb5c12cc4b159a03805c2de5a585=Concerts$)
2013-06-20 03:02:33,931 [28] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (24176) - 5 - -1 - 0 - 50
2013-06-20 03:02:33,931 [28] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon from ColorLabel_Table where (not Hidded or Hidded is null) LIMIT @Limit OFFSET @Offset (@Offset=0, @Limit=50)
2013-06-20 03:02:33,931 [28] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (24176) - 5 - -1 - 0 - 50
2013-06-20 03:02:33,931 [24] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (24177) - 5 - -1 - 0 - 50
2013-06-20 03:02:33,931 [24] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon from ColorLabel_Table where (not Hidded or Hidded is null) LIMIT @Limit OFFSET @Offset (@Offset=0, @Limit=50)
2013-06-20 03:02:33,931 [24] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (24177) - 5 - -1 - 0 - 50
2013-06-20 03:02:33,931 [28] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - Start: (24178) - 5 - -1 - 0 - 50
2013-06-20 03:02:33,931 [23] ERROR PicaJet.Daminion.Service.Utils.CreateMediaItemsBookCommand [(null)] - Error: (24175) - 1 - 1 - 9 - 0 - 1000
Npgsql.NpgsqlException:
falta una entrada para la tabla «a_a1» en la cláusula FROM
Severity: ERROR
Code: 42P01
  at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 839
  at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1163
  at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1181
  at Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1367
  at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1030
  at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 591
  at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 571
  at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 521
  at System.Data.Common.DbCommand.ExecuteReader()
  at PicaJet.Daminion.Service.DbCommandWrapper.ExecuteReader() in c:\DaminionAuto\Code\Service.DB\DbCommandWrapper.cs:line 47
  at PicaJet.Daminion.Service.Utils.CreateMediaItemsBookCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\CreateMediaItemsBookCommand.cs:line 66
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 96
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 44
2013-06-20 03:02:33,946 [28] DEBUG SQL [(null)] - select ID, Value, HelperValue, ParentValueId, IndexedTagId, SortOrder, IsGroup, HasChilds, IsDefaultValue, HierarchyLevel, Id_Icon from ColorLabel_Table where (not Hidded or Hidded is null) LIMIT @Limit OFFSET @Offset (@Offset=0, @Limit=50)
2013-06-20 03:02:33,946 [28] DEBUG PicaJet.Daminion.Service.Utils.GetIndexedTagValuesCommand [(null)] - End: (24178) - 5 - -1 - 0 - 50

 

Thanks!

[exterminador]

Figured out it is possible to Ctrl+click elements at the Catalog Tags panel to select files from more than one tag. This way the filter shows the "equals" operator for both folders:

 

 

Thanks.