Jef can enter the query "Tv Serials"

example:
find all the TV serials "Once upon a time" 2011.

Could you please give more details ?
This should consist in only one movie (containing all seasons and all episodes), so using, for instance, search tab you'll easily find the movie and so all the episodes.
JeF

Hi JeF.
Thanks for this wonderful plughin.

I've got a question: is there a command (for example "select * from table_name" or something like "descr table_name") that can show me the structure or the fields of a table? It'd be easier build queries with the names of the fields... I'm trying to guess some of them but sometimes it's difficult.
For example I'm trying to extract all the information of a movie file (file size, bitrate, codecs, audio stream ...) in order to build a report.

Thank you very much for your reply.
Charles5

You can easily see the structure of the database using a tool like sqlitebrowser

G R E A T !!!

Thank you very much, Vlad.


Charles

Dear Jef

I hope this is the right place to write about a possible bug of your plugin.
The selection of the columns "season" of both the tables "episodes" and "editions" doesn't work.
(for example simply "select season from editions").
The name of the column is always "n" vith no values.

I'm doing something wrong or is this a bug?

Thanks.
Charles5

Hi,
Yep, this is a bug. Thanks for reporting.
Here's a fixed v2.2 of the plugin waiting v2.3 to be out (i don't know when at the moment)
Should do it. Please let me know.

JeF

Hi JeF.

Thank you very much.
It works perfectly.

Bye.
Charles5

hey guys,

can anyone help me with listing the first 5-6 actors from a movie? i tried to work it out with no luck.

Something like this should help :


JeF