1
General / Re: storing multiple versions of the document and retrieve the latest version
« on: June 03, 2015, 12:42:52 PM »
Thanks for all the suggestions.
Our development team reached out to me saying max(load_date_field_name) won't work and they are getting the following error when they manually enter the MAX function in the sql window.
Error: The server failed during a search operation.
Does SQL functions ( MAX, AVG etc., ) are supported in CMOD query restriction ?
Meanwhile the team reached out to IBM and they got back saying whenever a particular index value is selected we can only use the operators that are listed in the operator symbols pane and it doesn't show any sql functions.
Our development team reached out to me saying max(load_date_field_name) won't work and they are getting the following error when they manually enter the MAX function in the sql window.
Error: The server failed during a search operation.
Does SQL functions ( MAX, AVG etc., ) are supported in CMOD query restriction ?
Meanwhile the team reached out to IBM and they got back saying whenever a particular index value is selected we can only use the operators that are listed in the operator symbols pane and it doesn't show any sql functions.