1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

SQL functions list?

Avatar
Peter Shute

I tried this, and it says there's no left function: select left(Applications.Name,5) from Applications

Is there no left function in PDQ's sql? Where can I see a list of available functions?

0

Comments

1 comment
Date Votes
  • Avatar
    Peter Shute

    It looks like the database is sqlite. select sqlite_version returns 3.27.2. I found this list of string functions: https://www.guru99.com/sqlite-functions.html

    Instead of select left(Applications.Name,5) from Applications I used select substr(Applications.Name,1,5) from Applications

    0