Jump to content

824 OR not working on Folder filter


exterminador
 Share

Recommended Posts

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:

 

post-97-0-11233100-1371689970_thumb.png

 

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...