3684 - Advanced Search People Tag doesn't work

[Uwe]

Hello,
the advanced search for person "not assigned/is empty" or "is not empty" does not work.
In the Tags panel->People there are 78 items without a person tag (not assigned). If I now set the condition “Person is empty” under Advanced search, no items are displayed. Conversely, no items are displayed for ‘Person is not empty’ either.
 I have created the following SQL query (see batch file in the attachment). The query searches the NetCatalog for all entries in the ‘mediaitems’ table for which no entry exists in the ‘people_file’ table and creates a text file with the IDs without a person tag in the folder in which the batch file is located. But the problem is: the items determined by the query do not match those from the Tags panel and vice versa and are also not among the ‘unassigned’ items in the Tags panel->People.
What might I be doing wrong with the SQL query or where is the error in the Daminion query for the person tag in the Tags panel?
Best regards, Uwe

 

no_personen_tag_to_TXT.bat

[Daria Kotilainen]

Hello Uwe, I suspect this could be related to the files processed by facial recognition. @Oleg.Rossplease comment on this when you have a moment.

 

Advanced > People: Is Empty works for me: 

 

 

[Uwe]

Hi Daria,
I used FR as a test some time ago, but then uninstalled it and it hasn't been active for a long time. I deleted the ‘old FR entries’ from the database following your instructions.
Have you tried my batch file on your system?
Greetings, Uwe

[Daria Kotilainen]

Yes. The output txt file is not created. I will check it put later after the scheduled sessions are done