...
One of the valid table names as mentioned in the table reference or generic for running any SQL query (only for On-Premise customers).
...
| Code Block | ||
|---|---|---|
| ||
api.do?function=query&table=db_task&project_id=200&db_task.percent_complete.<=100 |
Below query will return names of users who have a login in the application.
| Code Block |
|---|
api.do?function=query&table=generic&sql=select name from db_person where login_name IS NOT NULL |
This query will show tasks which do not have 'Details' entered i.e details field is blank.
| Code Block |
|---|
api.do?function=query&table=generic&sql=select summary from db_task where detail like '' |
join-with (Optional)
If you want the table to be joined with another table, you specify the 'join-with' parameter. This will be of the form <table-name>.<column-name>. The main table (specified by the table parameter) will be joined on its primary key with the table and column specified with the 'join-with' parameter. For example to fetch a list of tasks assigned to user with id 7 with project phase 1, you should specify :
...