Templates: various questions not worth their own thread

[ownedbycats]

Why does program: raw_field('date') return "None" while field('date') works?

$date and $$date get the same result.

EDIT: It happens even if I set gui_pubdate_display_format back to default.

ANOTHER EDIT: For reference, I'm using search & replace to copy to another datetime field.

[chaley]

Originally Posted by ownedbycats

Why does program: raw_field('date') return "None" while field('date') works?

$date and $$date get the same result.

EDIT: It happens even if I set gui_pubdate_display_format back to default.

ANOTHER EDIT: For reference, I'm using search & replace to copy to another datetime field.

It happens because 'date' is an alias for the (historically) real field 'timestamp'. The field() function does the translation. The raw_field() function doesn't.

Workaround: use 'timestamp' instead of 'date'.

EDIT: Also & FWIW: raw_field for dates returns 0101-01-01 00:00:00+00:00 for the unknown date because that is what is stored in the db. Up to you to know what to do with it.

[ownedbycats]

Thank you.

Are there any other columns with alias that don't work with raw_field?

[ownedbycats]

Another question: Is it possible to use a template to search datetimes where the timestamp is 00:00, regardless of date?

[capink]

You can use the following template:

program:
	ts = raw_field('timestamp');
	time_timezone = list_item(ts, 1, ' ');
	time = list_item(time_timezone, 0, '+');
	hours = list_item(time, 0, ':');
	minutes = list_item(time, 1, ':');
	seconds = list_item(time, 2, ':');
	strcat(hours, ':', minutes)

Search bar > settings icon > template tab > copy/paste the template above in the template cell, and in template value should be "00:00". Datatype should be "text".

Instead, you can do it by copy/pasting this directly into the search bar:

template:"program:
	ts = raw_field('timestamp');
	time_timezone = list_item(ts, 1, ' ');
	time = list_item(time_timezone, 0, '+');
	hours = list_item(time, 0, ':');
	minutes = list_item(time, 1, ':');
	seconds = list_item(time, 2, ':');
	strcat(hours, ':', minutes)#@#:t:00:00"

Edit: I tried the format_date() but for some reason it is not working:

template:"program:
	format_date($$timestamp, 'hh:mm')#@#:t:00:00"

[chaley]

Originally Posted by ownedbycats

Thank you.

Are there any other columns with alias that don't work with raw_field?

Not that I know of. And in any event I am making raw_field() do the same alias replacement as field().

EDIT: The change is now in calibre source.

[chaley]

Originally Posted by capink

Edit: I tried the format_date() but for some reason it is not working:

template:"program:
	format_date($$timestamp, 'hh:mm')#@#:t:00:00"

Timestamps are stored in UTC. The format_date() function converts them to local time (in the current time zone), including summer time adjustments if any. Your template ignores the time zone so times are not adjusted.

It seems to me that the format_date() answer is the right one because time zones should be accounted for. However, if you don't want that then this template removes time zone from the ISO string turning it into a local time.

	format_date(re($$timestamp, '(\+.*$)', ''), 'hh:mm')

[capink]

That makes sense. Thanks.

[ownedbycats]

Thank you.

Any idea why the template search in #170 runs inconsistently on custom datetime fields? It only returns #fanficupdated values that are from the last few days, and nothing at all from #lastmodified. I don't think it's the formatting of the columns - it's using raw_field.

[chaley]

Originally Posted by ownedbycats

Thank you.

Any idea why the template search in #170 runs inconsistently on custom datetime fields? It only returns #fanficupdated values that are from the last few days, and nothing at all from #lastmodified. I don't think it's the formatting of the columns - it's using raw_field.

My guess is that you are not in the UTC time zone so the value you see is not the value stored in the database. See 3 posts back. Try the template @capink posted that takes the time zone into account:

template:"program:
	format_date($$timestamp, 'hh:mm')#@#:t:00:00"

If that doesn't work then we will need example failing raw_date() text to find the problem. Something like the output of this template:

program:
	strcat($$timestamp, ' ::: ', format_date($$timestamp, 'hh:mm'))

[ownedbycats]

Question:

I had this proof-of-concept template for making different icons based on is_marked values.

program:
m = is_marked();

first_non_empty
   (
    contains(m, "invalid_author_sort", 'test.png', ''),
    contains(m, "invalid_title_sort", 'test2.png', ''),
   )

But how do I set a value for a non-defined mark?

[chaley]

Originally Posted by ownedbycats

Question:

I had this proof-of-concept template for making different icons based on is_marked values.

program:
m = is_marked();

first_non_empty
   (
    contains(m, "invalid_author_sort", 'test.png', ''),
    contains(m, "invalid_title_sort", 'test2.png', ''),
   )

But how do I set a value for a non-defined mark?

Do you mean no marks or not one of the ones you have tested for? If you mean no marks then

program:
m = is_marked();

first_non_empty
   (
    contains(m, "invalid_author_sort", 'test.png', ''),
    contains(m, "invalid_title_sort", 'test2.png', ''),
    if !m then 'foo.png' fi
   )

If you mean any mark other than the ones above then remove the !.

[ownedbycats]

Thank you

[ownedbycats]

if
!approximate_formats() then 'foo'
fi

Is this actually the correct way to check for no formats? It works, at least.

[chaley]

Originally Posted by ownedbycats

Is this actually the correct way to check for no formats? It works, at least.

Yes, it is a correct way as long as your database correctly lists the formats. If Check Library phase 2 passes then you are fine.

FWIW: this does the same thing but is less efficient because of the explicit compare:

if approximate_formats() == '' then 'foo' fi