• Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: Trunk
    • Fix Version/s: None
    • Component/s: framework
    • Labels:
    • Sprint:
      Bug Crush Event - 21/2/2015


      This is a new feature to manage SQL queries.
      You can :

      • store/update/delete SQL query
      • store/update/delete parameters for this query
      • execute query and view results into worksheet

      This SQL query manager is usefull to run frequently queries (ie: for maintenance report)

      How to use it :

      • goes to webtools/Entity Engine Tools
      • select "SQL queries library" item
      • create a new query and fill in SQL. If you want to use parameters, add them like this : select * from facility where facility_Id = '$ {facilityId}


      • to declare parameters for this query then goes to "Add or update query parameter" screenlet and fill in fields : description = facility id ; Parameter = facilityId
      • to execute SQl query then press buton "run"
      • fill in parameters value adn press buton "run"
      • worksheet should automaticaly open


        Sharan Foga made changes -
        Rank Ranked higher
        Sharan Foga made changes -
        Rank Ranked higher
        Sharan Foga made changes -
        Rank Ranked higher
        Sharan Foga made changes -
        Sprint Bug Crush Event - 21/2/2015 [ 91 ]
        Jacopo Cappellato made changes -
        Fix Version/s Trunk [ 12311928 ]
        Erwan de FERRIERES made changes -
        Assignee Erwan de FERRIERES [ erwan ]
        Gaudin Pierre made changes -
        Field Original Value New Value
        Attachment query_manager_patch.txt [ 12454864 ]
        Gaudin Pierre created issue -


          • Assignee:
            Erwan de FERRIERES
            Gaudin Pierre
          • Votes:
            0 Vote for this issue
            3 Start watching this issue


            • Created: