Patch for src/pyasm/biz/expression.py bug fetching wrong SObjects in many to many handling

    Affected versions: 4.1.0v03, 4.1.0v04 are the ones I tested

    How to reproduce:
    To be sure there were no site or project specific interferences I dowloaded the 4.1.0.v03 VMware Image from http://community.southpawtech.com/downloads and used the VFX project.
    The easiest way to show the bug is using the Shot planner. Connect to Tactic and open the VFX project, in the sidebar click on "Tools"->"Shot Planner", see the assets and shots section loading into the shot planner tab. Click on "Tools"->Shot Planner" again and keep cliking, at some point, usually after 3 to 5 reloads you'll see a duplicated asset for a specific shot into the "Asset Drop" column. The bug appears randomly every 2 to 5 reloads but gets much worse when the shots and assets number gets higher. Note that the duplicated asset is really referring to another asset, on a shot having "camera001, set001, vehicle001" but showing "camera001, camera001, vehicle001" in the Asset drop if you "click to remove" on the second camera001 it will remove set001

    P.S.
        This was quite a long debug session, took me many hours to follow the flow of tactic code in the pyasm namespace. Tactic's code is huge and I'm not sure I understand all of the implications for this patch.
Patch for src/tactic/ui/table/drop_element_wdg.py bug fetching wrong SObjects in many to many handling

Affected versions: 4.1.0v03, 4.1.0v04 are the ones I tested

How to reproduce:
To be sure there were no site or project specific interferences I dowloaded the 4.1.0.v03 VMware Image from http://community.southpawtech.com/downloads and used the VFX project.
The easiest way to show the bug is using the Shot planner. Connect to Tactic and open the VFX project, in the sidebar click on "Tools"->"Shot Planner", see the assets and shots section loading into the shot planner tab. Click on "Tools"->Shot Planner" again and keep cliking, at some point, usually after 3 to 5 reloads you'll see a duplicated asset for a specific shot into the "Asset Drop" column. The bug appears randomly every 2 to 5 reloads but gets much worse when the shots and assets number gets higher. Note that the duplicated asset is really referring to another asset, on a shot having "camera001, set001, vehicle001" but showing "camera001, camera001, vehicle001" in the Asset drop if you "click to remove" on the second camera001 it will remove set001

As oboreo suggested I'm moving the clear_cache() call from src/pyasm/biz/expression.py to src/tactic/ui/table/drop_element_wdg.py
from tactic 4.0.1.v04 when trying to save/update a template project an exception is thrown:

SObjectValueException: Column [project_type_code] does not exist in search_object type [sthpw/project]

the "code" column in sthpw/project is expected to be named "project_type_code" because of the sobject_code relation between sthpw/project and sthpw/project_type.
expliciting the from_col in src/pyasm/biz/schema.py solve the problem...
Merge pull request #10 from diegocortassa/master

Patch for src/pyasm/biz/expression.py bug fetching wrong SObjects in many to many handling
BRANCH 4.2-51_delete_trigger:
   added support of delete|<sType> client trigger
   added search_type access rule check when deleting entries
4.2-105:
  added python tag feature in plugin
BRANCH 4.2-105:
  made sType Creation create a unique constraint instead of index
BRANCH 4.2-105:
   renamed the variable from my.commit to my.commit_now
BRANCH 4.2-105:
   made basic local table keyword search not use a sub select resulting in a faster query
Added domain_component for active_directory/ad_authenticate.py
BRANCH 4.2-105: added option in active_directory/ad_authenticate.py to call custom script that verifies the login names based on a user_group
BRANCH:4.2-105: updated formatting in ad_authenticate.py
BRANCH:4.2-105
BRANCH:4.2-105 - changed web_wdg.py to include name and password labels
BRANCH 4.2-105:
  made it to alert the user the session has expired followed by a redirection to the login page (page reload)
BRANCH 4.2-105:
  added the missing sthpw/custom_script stype to the search_sobject table
  added this to the upgrade script
BRANCH 4.2-105:
   removed the () in if statement
BRANCH 4.2-105:
  added support for ' in type for 2 different snapshot instance methods to get file_code or use_naming by type
BRANCH 4.2-105: removed single characters from keyword search
removed commented out function
BRANCH 4.2-105: updated hash handling to be more customizable