Jacknq · January 6, 2021 11:49
diff --git a/litedb v5 sql examples.sql b/litedb v5 sql examples.sql
 SELECT $ FROM post
 INCLUDE categories,tags 
 where  $.Categories[*].$id any in [ 7 , 10]

 SELECT  *.Categories[*], sum(*.Categories[*].id) as c
 FROM post
 --include $.Categories
 where $.Categories!=null and Count($.Categories[*])>0  and $.$missing any  !=true
	SELECT $ FROM post
	INCLUDE categories,tags
	where $.Categories[*].$id any in [ 7 , 10]

	SELECT .Categories[], sum(.Categories[].id) as c
	FROM post
	--include $.Categories
	where $.Categories!=null and Count($.Categories[*])>0 and $.$missing any !=true