Release Notes

Released: 2013-03-23

 

Client API Changes
 

Bug Fixes

  • ensured the csv Export is still functional with less features in the old TableLayoutWdg. It will alert the user if he is csv-exporting from the old TableLaoutWdg.
  • fixed a potential bug for using replace when setting a number type to a numeric or decimal type column
  • fixed a refresh row bug which was not working for sobject edits other than sthpw/-prefixed ones
  • added support for MySQL which does not support setting admin in login table to id = 0
  • fixed potential csv export unicode bug. ignored any unencodable characteres.
  • made the sobject dict created in api xml rpc call only encode value in utf-8 only if it is a unicode object
  • fixed a bug in ExpressionElementWdg when dealing with values other than string
  • fixed notification subject and message being blocked by security settings
  • added support for  0 in value for LookAheadTextInputWdg
  • fixed a bug where it won't display an sobject with id 0
  • removed the illegal characters silently when running SObject.set_value() for varchar and text type columns
  • added quotes around the length when dumping out table with varchar or char to prevent errors with length "max" for the SchemaDumper
  • improved reporting of error message with unicode characters
  • fixed DiscussionElementWdg handling of sobject with unicode in the code by using id based search_keys
  • introduced the concept of new_search which is true when the Search button is pressed to reset the pagination of results. This applies to Search Box or Simple Search area

 

New Features

  • added check for Title and code length in the Project Creation UI
  • added cross_db display_option to KeywordFilterElementWdg to allow for cross-db filtering if set to true
  • added 1 day to the end date for DateRangeFilterElementWdg so that the whole day of the end date is covered
  • updated DateFilterElementWdg to allow expression like syntax in column, consistent with DateRangeFilterElementWdg
  • made the csv copy and paste support Linux based client
  • updated csv import to have a new option lowercase title
  • made the csv file import use HTML5 upload instead of Java applet
  • added support of csv Export of any view the user is currently viewing with additional or reordered columns

Database Schema Changes

  • updated startup sthpw schema for different databases
  • added src_search_type, src_search_id index to connection table
 

 

 

Released: 2013-03-08

 

Client API Changes
 

Bug Fixes

 
  •  updated the game template zip file to prevent stack trace on project creation.
  •  made is empty filter work with uniqueidentifier column type
  •  made the locale setting compatible in both Mac and Windows when the locale for the OS can't be auto-determined
  •  fixed a bug where the first item in the SideBar being a separator line would cause an error
  •  fixed a time filter "is on" stacktrac

New Features
 

Database Schema Changes

 
 

 

 

Released: 2013-02-23

 

Client API Changes
 

Bug Fixes

 
  • updated Renew License Page to use Html5Upload
  • updated WorkHoursElementWdg csv export to export OT and ST into 1 single weekly sum 
  • turned off search security when  evaluating email address expression for sending emails
  • made datetime comparison in search box work properly for Sqlite and SQLServer
  • fixed the Show Server Transaction popup to run properly across different database types using the JSON filter syntax
  • improved detection if a date is a real date or just English like 1 week ago, 6 hours ago
  • made it possible to erase an number type nullable column
  • made expression search only affect the search if there are some results returned from expression
  • made css and rowcss display_option apply only if there is a value from the evaluated Expression
  • prevented adjusting column size from dragging the table around
  • passed in direction even for comma separated order_by
  • fixed a bug in SObjectConnection.get_connected_sobject() where context kwarg was ignored
  • improved efficiency of SObjectConnection.get_sobjects()
  • fixed the CalendarInputWdg always stuck on today's Date
  • fixed a display bug in General CheckinWdg where a Browsed directory contents are not displayed 
  • added better warning message when the user use the Delete File function in the local sandbox area
  • ensured sandbox doesn't get created automaticaly when checking in arbitrarily Browsed files/dir
  • prevented stacktrace for insert mode sobject in DiscussionElementWdg
  • changed only the task status from nvarchar(max) to nvarchar(256)
  • added sender email empty check for Email Test button 
  • fixed the scrolling and popup/dialog window positions and dragging.
  • fixed error checking which broke VFX import with TACTIC TEAM on Mac OSX Mountain Lion
  • updated DiscussionElementWdg to prevent error with the insert row when use_parent is true
  • fixed caching bug when SObject.get_by_id() is used
  • retained preprocess efficiency when use_parent is used in DiscussionElementWdg
  • added improved CSV Export for PythonElementWdg
  • fixed date search to use dateutils.parser instead of regular expression
  • optimized the connect statement in expression
  • made lookahead possible on expression filter elements.
  • fixed problem with random selects appearing on task status
  • set min-width for search widget 
  • added ability to set filters to connect in expressions 
  • some fixes to filter elements.
  • updated expression related to @SEARCH (new feature)
  • added email_to_sender project setting when sending out notification emails
  • fixed the Export All csv stack trace
  • prevented writing of '' to more number-type database column
  • made int recognized as integer type in SQLServer implementation
  • improving the speed by reusing DbResource for the default database, prevented wasted resources in decrypting password as well. 
  • added project as a valid starting point for an expression
  • raised an error when the sender email is empty
  • fixed a bug in LookAheadTextInputWdg where it fills in 0 in the hidden input when it should be ''
  • added utf-8 decode error protection to look ahead search
  • returned "" for insert object in ExpressionElementWdg
  • added condition in case an editable widget is None
  • updated the internally used datatype name
  • fixed a bug where the drawing of the multi-assigned users are wrong with the cached display options. 
  • naming edit view had duplicate fields which are now taken out
  • can now use checkin file basename and extension in the condition field for naming i.e. {$BASEFILE} {$EXT}
  • return numeric, double precision and decimal as float tactic types when used in filtering in Search box
  • added is empty and is not empty to Date and time related filters
  • made integer based filter textbox respond to Enter press in the Search box
  • made is empty and is not empty hide the text box beside it for all number, string and time-based filters
  • fixed a bug in add_keyword_filter() in its way of determining column types
  • added support for . notation in <column> in a multi column situation
  • added support for . notation in search.add_keyword_filter() for KeywordFilterElementWdg
  • added index to connection table
  • expanded to more number data type to return 0 if empty when retrieving from SObject.get_value()
  • fixed @GET(.text_column) != '' expression evaluation
  • fixed dictionary mode Expression calculation when the input sobject is a single item
  • if a Search.add_join() is called but the 2 sTypes are not related, it skips adding the join
  • fixed Search.add_startswith_keyword_filter to not do a join while looking for results usually for the look ahead search
  • added code to search_object on installation
  • fixed the potential stack trace after pressing the Clear button in Search box and then "Search"

New Features
 

  • added a new filter specifically for search tasks through connect (TaskConnectFilterElementWdg)
  • added @CONTEXT keyword for connect in expression e.g. @GET(connect['@CONTEXT','main_task']['description','tree'].id) so one can target what type of connection to get
  • made the Reset Password button senders email the admin user's email or support@southpawtech.com
  • made Windows TACTIC run a simple version of the CacheStartup at the startup so it skips the caching of the few main tables while maintaining the process_time_alive feature
  • added support for encrypted password for all database implementations
  • added @SEARCH used in DateRangeFilterElementWdg
  • added basic support for connect in SelectFilterElementWdg
  • added justify to expression element widget 
  • added LOGIN_ID variable to expression language.
  • added support for more data_types for Edit Panel and hid the ones that are used internally by databases
  • added show_shelf as an option that is respected during table/custom refresh 
  • added support for path in sTypes for keyword mode KeywordFilterElementWdg
  • added SimpleCsvImportCmd that can handle csv import without the use of web form values

Database Schema Changes

  • added index to process and status of the task table
     

 

 

Released: 2013-01-24

 

 

Client API Changes

Bug Fixes

 
  • added creation of plugin_dir at environment initialization
  • updated ProjectTemplateCreatorCmd so Update Template button continues to work
  • modified CustomLayoutWdg to use the custom category if provided to look for the config
  • changed format to display_format for the option of CalendarInputWdg so it's consistent with other input or table element widget
  • if using %m-%d-%Y format, use "date_format" option for that which is consistent with CalendarTimeWdg
  • added a supervisor schema connection to sthpw/login from sthpw/task with the path named "supervisor"
  • fixed bug in PasswordInputWdg set_value() and clear button
  • used PasswordInputWdg in System Config page
  • instead of removing an attribute on save if it's empty, just set it empty in System config page
  • fixed the Test database button in System Config page to work properly with DbResource
  • turned on Sudo mode when doing Security based sub search
  • turned off triggers when auto creating users  when LDAP authentication is used
  • improved used of authenticate_domains option in Login Page (for LDAP or Active Directory)
  • added 1, '1', and 'True' to the true boolean value for SQLite process_value so that it can undo and redo boolean value update fine      
  • return the error message where PythonElementWdg hits an error
 

New Features

  • updated Work hours csv export to export the weekly hours with consideration that they are on separate months with the month label
  • add attribute  sidebar, index, admin for use in widget in Custom URL element tag. 
e.g. 
<element admin='true' sidebar='false'>
 <display class='tactic.ui.panel.CustomLayoutWdg'>
   <view>ticket_single</view>
   <search_type>ticket/ticket</search_type>
   <include_mako>true</include_mako>
 </display>
</element>
  • added support of nvarchar(-1), nvarchar(max), varchar(-1), varchar(max) in TableSchemaDumper so that Postgres can import it back as text while SQLServer will import it back as the corresponding type.
  • added DATE and DATETIME to FormatDefinitionEditWdg and FormatElementWdg and they are now settable in Project Settings
  • set login for task creator on creating a task
  • updated CalendarInputWdg and CalendarTimeWdg to make use of the project settings DATE and DATETIME if available
  • added show_column_manager, show_layout_switcher, show_shelf option to Fast Table and View Panel
  • added "is before" and "is after" in expression for time-based comparison, equivalent to <= and >=
  • added padding of 2 to hours and minutes in case the user type in a single digit
  • updated the time widget on the CalendarInputWdg to work with Keyboard direct input and auto correct wrong time format

Database Schema Changes

  • added login to task table to store creator of the task

 
 

 

Released: 2013-01-11

 
 

Client API Changes

  • added get_plugin_dir() 
  • added transaction_ticket kwarg to start()
  • added get_connected_sobjects() , get_connected_sobject(), and connect_sobjects() 
  • added ability to generate ticket in api with generate_ticket()

Bug Fixes

 
  • updated LookAheadTextInputWdg so it clears the hidden input when validation fails
  • updated RelatedTaskUpdateTrigger to work well with copying empty value in task
  • turned off cache startup in Windows
  • only clear null code tickets in the first process when running as a service
  • fixed a bug in CSV export Matched with simple search view.. made it use base search type to do the search for the simple search view widget config
  • updated Custom Layout Editor so that it draws properly during initial loading, insert mode, or regular edit mode 
  • fixed LookaheadTextInputWdg so that you can override the column to get the current value (by default it uses the name of the element).
  • fixed process_value() bug in SQLServer implementation
  • added SQLServer and postgres set_value tests
  • fixed the work hours bug where the group summary does not display the new data when switching week
  • added class spt_group_cell to group table cells
  • added anticipation of user specifying group_elements as a string for FastTableLayoutWdg
  • fixed a bug in Task.get_by_sobject() when process is defined as unicode
  • skipped the saving of a skipped non editable item in Edit popup
  • fixed a bug in refreshing row after editing thru Edit popup by using id based search_key
  • updated the deprecated CalendarTimeInputWdg to behave like CalendarInputWdg with show_time option set to True
  • updated Search Criteria to use the updated CalendarInputWdg
  • fixed a bug in CalendarInputWdg where when choosing a date again, it will be unresponsive
  • fixed a bug in CalendarInputWdg where it resets the time on choosing a new date.
  • fixed a bug in TaskStatusSelectWdg to anticipate a status pipeline code that does not exist
  • fixed a bug in Expression where connect is not working with expression with no starting sobject.. like when env_sobjects is used
  • fixed a bug where the env_sobjects is not recognized when used more than once in an expression
  • fixed a bug so that trigger can handle a string with non-ASCII characters
  • updated ActionButtonWdg to not have an extra attribute-less div around it.
  • commented out unused code in Tactic Script Editor
  • made saving of Custom Layout Editor and Tactic Script Editor work when both are open
  • made the Saving Script overlay appear in Chrome as well
  • fixed a bug in Search.add_order_by() with comma separated value. it used to only run on the first column name on the list
  • made config/process order by pipeline_code,sort_order by default
  • removed the logic in the Configuration page to update the process table manually, it only updates the description field now. Pipeline class takes care of the process table update instead. 
  • added update of the process table on insert or update thru the Configuration Page for regular pipeline and status pipeline
  • fixed the bug where it always insert a <connect from "None" to ...> using the Configuration page 
  • fixed a bug in Search.get_related_by_sobjects to account for id relationship
  • made redo and undo create a relative symlink where applicable
  • fixed a bug in the recording of the prev attribute during a symlink type file transaction
  • updates to plugin manager to handle info
  • preliminary addition of html docs for each plugin
  • updated Insert to do the same decoding in windows or linux
  • added support for unicode capable storage in SQLServer implementation
  • updated Html5UploadWdg to use just the transaction_ticket in the form to prevent UploadServerWdg not responding
  • added generate_ticket to client API
  • Small update to TextInputResultsWdg to narrow down the result as you type a space in the field 
  • added the search_object entry config/plug_in to sthpw_schema.sql
  • updated mysql and sqlserver and sqlite install schema
  • more updates to plugin manager
  • rearranged quickbox
  • rearranged order of reading in plugin kwargs
  • open up plugin path to cherrypy
  • improved url # hash handling so that one can control whether to draw the admin page with the widget in a custom URL
  • fixed the input select turning red bug after  insert by converting potential int into strings 
  • updated TriggerDetailsWdg to avoid errors from missing processes in pipeline definition
  • accomodated unicode in HtmlElement.set_attr()
  • removed the auto background color swtiching on blur for read_only TextInputWdg
 
 

New Features

  • added PythonElementWdg which takes a script path to process or reformat values in Python
  • enabled csv export of work hours
  • added display of error alert if csv export fails in one of the widget columns
  • made clearing of text in TextInputWdg clear the invalid property if applicable
  • added ability to set a value key to explicitly set a value into a lookahead text input using an search key.
  • added @PYTHON to expression to evaulate a script_path. It is suited for message or subject in notification.
  • added edit_definition view to login-conf.xml
  • made sure that TACTIC_DATA_DIR exists when running TACTIC in development mode
  • updated search_type column in config/process to use fast calc_mode in expresion evaluation
  • updated Delete widget message and have the dependent checkbox unchecked
  • added Services process_count, thread_count and process_time_alive settings to System Config page
  • added ability to set context in checkin button widget.
  • made the checkin and upload buttons have a TextWdg which stores the file name.
  • expanded on html5 upload classes
  • added validation_scheme kwarg to TextInputWdg
  • made the CLEAR icon in TextInputWdg to re-validate the input value
  • allowed for __NONE__ in the search_keys argument for table layout.
  • added validation_js kwarg to TextInputWdg
  • added the validation_scheme option to TableLayout Edit Definition as an option
  • made the Insert of utf-8 data from a ASCII source file work in both linux postgres and windows sql server
  • added decoding of iso-8859-1 if utf-8 decoding fails at insert statement construction
  • made multi-level folders work on custom layout editor.
  • added sorting to schema nodes and connectors so that they are ordered alphabetically.. dangling connection appearing at the bottom would be more easily spotted
  • more additions to plugins ... added some code to handle python code/classes in plugins
  • added hint to subcontext_option of process in edit_definition

Database Schema Changes

 

 
 
 

Pages