Scholia Parameter Handling
Jump to navigation
Jump to search
params_stats
query
SELECT count(*),
params
FROM "QueryDetails"
GROUP BY params
ORDER BY 1 desc
result
count(*) | params |
---|---|
682 | |
293 | q |
14 | q1,q2 |
9 | q,q |
3 | q,q,q |
3 | p |
1 | q,q2 |
1 | q,q,q,q,q |
1 | q,doi,q,doi,q,doi,q,doi,q,doi |
1 | lexeme |
1 | keyword |
scholia_jinja_for_loops
query
SELECT
count(*),
substr(
sparql,
instr(sparql, '{% for') + length('{% for'), -- Start position right after "{% for"
instr(substr(sparql, instr(sparql, '{% for')), '%}') - length('{% for') -- Length of substring
) as for_loop_content
FROM
NamedQuery
WHERE
sparql LIKE '%{% for%' ESCAPE '\' and for_loop_content like "%in%"
group by for_loop_content
order by 1 desc
result
count(*) | for_loop_content |
---|---|
28 | q in qs % |
1 | q1 in qs % |
1 | doi in dois % |
1 | day in range(-32, 1) % |