Here's a patch for the "Order by" bug reported in
http://sourceforge.net/tracker/index.php?func=detail&aid=931962&group_id=87538&atid=583488
Obviously you also need to rebuild all your table manager objects, i.e.
for x in context.objectValues('zetadb table manager'):
print x.zetadb_man_build_objects(RESPONSE=None)
nika-/qQEVZGChKg@xxxxxxxxxxxxxxxx:~/data/projects/rts/playinstance/Products/zetadb>
diff zetadb_script.py zetadb_script.py_orig
208,209c208,209
< body += """if p_request.has_key('%s_order_by'):\n""" % table_name
< body += """ request.%s['%s_order_by'] =
p_request['%s_order_by']\n""" % (session_name, table_name, table_name)
---
body += """if p_request.has_key('order_by'):\n"""
body += """ request.%s['order_by'] = p_request['order_by']\n""" %
session_name
211,212c211,212
< body += """if not(request.%s.has_key('%s_order_by')):\n""" %
(session_name, table_name)
< body += """ request.%s['%s_order_by'] = \"""%s\"""\n""" %
(session_name, table_name, default_order)
---
body += """if not(request.%s.has_key('order_by')):\n""" % session_name
body += """ request.%s['order_by'] = \"""%s\"""\n""" % (session_name,
default_order)
215,216c215
< body += """if request.%s['%s_order_by']:\n""" % (session_name,
table_name)
< body += """ kw['p_order_by'] = ' order by ' +
request.%s['%s_order_by']\n""" % (session_name, table_name)
---
body += """kw['p_order_by'] = ' order by ' + request.%s['order_by']\n"""
% session_name
532c531
< body += """current_order = request.%s['%s_order_by']\n""" %
(session_name, table_name)
---
body += """current_order = request.%s['order_by']\n""" % session_name
Based on the first impression, it seems to work.
