New tasker DB commands?

[Bill DeWitt]

I just read that Tasker now has SQL/DB functions (thanks Joao) and we don't need to use the SQLite Plugin anymore.

Yes, I'm sure I'm behind on that news. I've been doing other things.

So, is there a place I can catch up and learn what's going on with that? My quick google searches so far refer back to the SQLite Plugin.

[Marta Hintz]

The question mark in the top right gives you info on this.  I'm assuming you may need to know some basic sql commands.  On tasker reddit there seems to be a user fairly well versed in using this.  

[jmjc...@gmail.com]

Not sure what new SQL functions you referred to. But Tasker has the "SQL Query" action that works with your own database without using plug-in.

[Baerdric]

Thanks. I guess I just didn't see that earlier. I read about it when I went to reinstall SQLite Plugin and the author said it was no longer necessary but didn't elaborate. I haven't really messed around in tasker for a few years so I'm sure there's lots that Joao put in after he took over for Pent.

--
You received this message because you are subscribed to a topic in the Google Groups "Tasker" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tasker/hKT21mK5EOM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tasker+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/tasker/c2889b08-8dd9-4efa-bfe7-e3e32d149e48n%40googlegroups.com.

[CHunter]

I had some success with the SQL action, starting here:
https://www.reddit.com/r/tasker/comments/o9wghn/how_to_get_detailed_info_about/

I have a task using SQL Query action with Mode URI Formatted and URI content://call_log/calls/  and it is working. I want to add a LIMIT clause, so I have to rewrite to use Mode Raw, because that way I can enter the full SQL statement.
In Raw mode I cannot locate the file.
I get this error:
file not found
storage/emulated/0/content://call_log/

After some research, it looks like Raw mode needs to be pointed to a db file, which I do not have; but URI mode can use a URI, which I have. However, it would be great to have a URI mode that allows the Query to be entered as a full SQL statement, so that other SQL directives besides SELECT, WHERE can be used, like LIMIT.

[jmjc...@gmail.com]

Some content providers do work with LIMIT. Simply put, e.g. LIMIT 1, in the Order By field. 

If a content provider doesn't work with LIMIT, you will need to get all items and then get the specific number of items from the array returned.

[C H]

Thank you, this is exactly what I wanted:

"Simply put, e.g. LIMIT 1, in the Order By field."

To view this discussion on the web visit https://groups.google.com/d/msgid/tasker/c24ad988-565d-47cf-ae89-e2ab41cb6a2an%40googlegroups.com.