Bernard Devlin

Hi Frank, thank you, that is a very kind offer. Now that I've worked out how to interact more fully via REST I would rather keep on experimenting and take you up on your time when I get stuck on conceptual issues. PO is such a big system that I am likely to misunderstand how things work. I find the web UI rather daunting in how much information it provides and with so many features. Using REST I can build up my understanding piece by piece and see how far I can get. Regards, Bernard

I worked out how to do make more advanced List queries. im_project?query=(project_status_id<70 or project_status_id>80 im_project?query=(project_status_id in (76,80)) im_project?query=(project_status_id<70 or project_status_id>80&start=25&limit=500 im_project?query=project_status_id=76&columns=id,last_audit_id,creation_date

Hi all, I am looking at integrating ]po[ functionality but not in a browser. To this end I've been looking at the REST API. I have this working calling Lists and Reads of various ]po[ objects. However from some discussions of this API, it seems I'm not tapping into the full range of what can be done. I've managed to restrict the returned results using LIMIT and the COLUMNS clause. It appears the GET query can contain elements of SQL functionality, particularly WHERE clauses. I am assuming that found...

Hi Frank, thanks for your pointers. I have ]po[ installed. I think it's best I ask my next question in a new topic. Kind regards, Bernard

Hi I'm just starting to read about ]po[ and I was wondering where permissions are stored. I saw this in another thread: The ]po[ database has it's own API written in PLPG/SQL database procedures https://sourceforge.net/p/project-open/discussion/295937/thread/c6eb6667d1/ However, I expect that the permissions to ]po[ objects are not controlled via GRANT statements in Postgres, but are rather some specific mechanism designed to be compatible with the underlying OpenACS. I wonder if someone could tell...