# HG changeset patch
# User Daniel Poelzleithner <poelzi@poelzi.org>
# Date 1286627359 -7200
# Node ID ff616202261581e7f3d63d0855ac1720d09db38f
# Parent  cc7650c7053fc3788f6a316d7a7afc04fc60df70
add more suggestion api fields

fixes bug #325

diff -r cc7650c7053f -r ff6162022615 app/main/api/suggestion.lua
--- a/app/main/api/suggestion.lua	Sat Oct 09 04:25:11 2010 +0200
+++ b/app/main/api/suggestion.lua	Sat Oct 09 14:29:19 2010 +0200
@@ -23,7 +23,11 @@
   suggestions_selector:add_where{"suggestion.initiative_id = ?", initiative_id}
 end
 
-if order == "id_desc" then
+if order == "created_desc" then
+  suggestions_selector:add_order_by("suggestion.created DESC")
+elseif order == "created_asc" or order == "created" then
+  suggestions_selector:add_order_by("suggestion.id")
+elseif order == "id_desc" then
   suggestions_selector:add_order_by("suggestion.id DESC")
 else
   suggestions_selector:add_order_by("suggestion.id")
@@ -39,6 +43,8 @@
 
   { name = "id",                       field = "suggestion.id" },
   { name = "initiative_id",            field = "suggestion.initiative_id" },
+  { name = "created",                  field = "suggestion.created" },
+  { name = "author_id",                field = "suggestion.author_id" },
   { name = "name",                     field = "suggestion.name" },
   { name = "description",              field = "suggestion.description" },
   { name = "minus2_unfulfilled_count", field = "suggestion.minus2_unfulfilled_count" },