How to recalc a virtual_libraries() column?

[ownedbycats]

I run into an rare glitch where my virtual_libraries() template starts reporting 'recursion detected' when there actually isn't any -- I can't reliably replicate it yet, but I noticed it sometimes happens after I run an action chain that modifies several columns in sequence (maybe the template processor is confused by the values rapidly changing?)

Restarting Calibre fixes the issue, but is there another way to re-calculate the column?

[chaley]

Originally Posted by ownedbycats

Restarting Calibre fixes the issue, but is there another way to re-calculate the column?

Try selecting all the books then doing Edit Metadata and pressing OK. IIRC this will clear caches but not change any data.

NB: IIRC "Recursion detected" can happen if a saved search references a VL that references a saved search, either directly or through a composite column. The problem is that the second search cannot depend on the results of the first because it hasn't finished yet. I know how to fix it, build a Directed Acyclical Graph (DAG) of the operations, but this is both hard and slow to compute.

[ownedbycats]

Thanks.

Is there any obvious recursion going on here?

Virtual library:

search:"=Books Currently Reading" OR #readinglist:"~To Be Read"

Saved search "Books Currently Reading":

template:"program: readstatus()#@#:t:currentlyreading"

readstatus():

program:

	if $$#percentread >=#1 && $$#percentread <=#99
	then 'currentlyreading' 

	elif "To Be Read" in $#readinglist && $$#percentread ==#0
	then 'toberead' 

	elif $$#percentread >=#100
	then 'read' 

	elif $$#percentread == 'None'
	then 'undefined' 

	elif $$#percentread >=# 0
	then 'unread' 

	fi

#readinglist is a series-like and #percentread is integer.



I'll try changing the VL to query readstatus() directly and skip the saved search:

template:"program: if '(currentlyreading|toberead)' in readstatus() then 'yes' fi#@#:t:yes"