...
| Code Block | ||
|---|---|---|
| ||
api.do?function=query&table=db_task&project_id=200&db_task.percent_complete.<=100 |
| Code Block |
|---|
api.do?function=query&table=generic&sql=select name from db_person where login_name IS NOT NULL |
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 :
...