Lieven Janssen

Add $methods and $tables array and $table_prefix

1

I would like to add a $tables array with allowed tables and a possible $table_prefix in the code. Suggested approach: - add $tables array and $table_prefix variable after the $dsn...

replace #num by #any

1

I think you shouldn't restrict the type of field you use as the unique identifier for a resource. I would replace all #num by #any.

Create an API documentation portal with a Generic Resource, Installed, Resource, Formatters Tree on the left and the documentation on the right. cfr. API docs of Secha ExtJs: http://docs.sencha.com/ext-js/4-0/#!/api

Sort, Filter & Facetted search in portal page

1

Support faceted search on resources based on tags, supported formatters. Filter resources: creation date: today, this week, this month, last 3 months, last year, ... updated date: today, this week,...

How can I create a chart on top of SPECTQL with specific charting url params, following url gives error: http://data.appsforghent.be/spectql/TDTStats/Year/all/all/2012%7Bmonth-,requests%7D:column?category=month&value=requests Error: Could not process this token: Parse Error: ('?')() not...

Fix bug with ascending sort. Following url works: http://data.appsforghent.be/spectql/TDTStats/Year/all/all/2012%7Bmonth-,requests%7D But following url gives wrong results: http://data.appsforghent.be/spectql/TDTStats/Year/all/all/2012%7Bmonth+,requests%7D

Add != string comparison support in SPECTQL Following url works: http://data.irail.be/spectql/NMBS/Stations%7Bid,name-,longitude,latitude%7D?name==%27Ghent%20Dampoort%27:json but following gives error: data.irail.be/spectql/NMBS/Stations{id,name-,longitude,latitude}?name!='Ghent Dampoort':json Error: Could not process this token: Parse Error: (NE)() not expected

Implement ability to concatenate column values and strings. e.g. /person{name, 'http://icons.com/' + gender + '.png'} would generate an icon url for a gender icon which could be used on maps....

PUT/DELETE don't work

3

I changed the PUT code locally and implemented it this way: http://www.lornajane.net/posts/2009/putting-data-fields-with-php-curl To implement DELETE you can find code in following article: http://developer.sugarcrm.com/2013/08/30/doing-put-and-delete-with-curl-in-php/