search

BscThesis / aboard.iee.ihu.gr

7 stars 0 forks source link

Event tags #14

Closed nickcn closed 3 years ago

nickcn commented 3 years ago

Old announcements with "Εκδηλώσεις" as their tag should also have is_event set to true. Shall we do it directly in the DB or will you import again? @asidirop

nickcn commented 3 years ago

Actually it was easier than I thought. update announcements set is_event=1 where announcements.id in(select announcement_id from announcement_tag where tag_id=22 );

asidirop commented 3 years ago

It is easy but there is no meaning doing it. The idea is that the "is_event" announcements have a date-time attribute. In old announcements, we cannot extract this information. So they can just exist.

Antonis Sidiropoulos https://www.it.teithe.gr/~asidirop/, Assistant Professor Information Management & Software Engineering Laboratory http://imselab.it.teithe.gr Department of Information and Electronic Engineering https://www.iee.ihu.gr/ - International Hellenic University https://www.ihu.gr/. @., @., @., @., @.*** LinkedIn http://www.linkedin.com/pub/antonis-sidiropoulos/a/32/8b3, researchgate http://www.researchgate.net/profile/Antonis_Sidiropoulos/?ev=hdr_xprf, academia https://teithe.academia.edu/AntonisSidiropoulos, google scholar http://scholar.google.gr/citations?user=42WdccQAAAAJ&hl=el, dblp http://dblp.org/pers/hd/s/Sidiropoulos:Antonis, aminer https://aminer.org/profile/antonis-sidiropoulos/53f453e3dabfaee2a1d6a4f7

On Tue, 4 May 2021 at 22:53, Nikolaos Christos Nikolaidis < @.***> wrote:

Actually it was easier than I thought. update announcements set is_event=1 where announcements.id in(select announcement_id from announcement_tag where tag_id=22 );

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/BscThesis/aboard.iee.ihu.gr/issues/14#issuecomment-832202116, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKW7XFWD4GDKFGZBMB4QFTTMBGERANCNFSM44DKJKDA .