Announcement

Collapse
No announcement yet.

Grid Module - Clicking See Details gives SQL dump

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid Module - Clicking See Details gives SQL dump

    Grid Module Application
    Built with v8
    SC Development Enviroment is patched to 8.0.33
    Web Browser: Firefox 36.0
    ServerOS: Zentyal 3.3.10 based on Ubuntu 12.04 - PHP 5.4

    Issue: I have built an application that works fine, that has a nested SELECT statement to sort out the latest day's log entries. All features including the 'See Details' icon work fine until I go to customize the dynamic selection under the grid, by adding more fields. As soon as I perform this step, the 'See Details' icon stops working, and it dumps a huge SQL error message in the development enviroment. BTW: The SQL dump does NOT match the SQL query I programmed into the grid, so am pretty sure this is a ScriptCase bug, and I can duplicate this bug at will.

    SQL Error message when clicking on 'See Details' magnafiying glass.
    Screenshot from 2015-03-02 14:40:38.png

    Customized Query that works fine until you attempt to add fields to the customizable colums in the display of the grid.
    Screenshot from 2015-03-02 14:44:04.png

    This isn't a 'show stopper' but we really need to be able allow the user to control what fields they want displayed on the grid module display.

    Thanks.

    Curtis Brotherton
    Software Engineer
    PDMNet

  • #2
    The fastest work around is to create a view to simplify the select.

    Regards

    Comment


    • #3
      Not every database allows an order by clause in a subquery.
      So I see your select .... FROM (select DISTINCT .. from ... ORDER BY) ...

      Comment


      • #4
        Originally posted by CurtisB View Post
        Grid Module Application
        Built with v8
        SC Development Enviroment is patched to 8.0.33
        Web Browser: Firefox 36.0
        ServerOS: Zentyal 3.3.10 based on Ubuntu 12.04 - PHP 5.4

        Issue: I have built an application that works fine, that has a nested SELECT statement to sort out the latest day's log entries. All features including the 'See Details' icon work fine until I go to customize the dynamic selection under the grid, by adding more fields. As soon as I perform this step, the 'See Details' icon stops working, and it dumps a huge SQL error message in the development enviroment. BTW: The SQL dump does NOT match the SQL query I programmed into the grid, so am pretty sure this is a ScriptCase bug, and I can duplicate this bug at will.

        SQL Error message when clicking on 'See Details' magnafiying glass.
        [ATTACH=CONFIG]1899[/ATTACH]

        Customized Query that works fine until you attempt to add fields to the customizable colums in the display of the grid.
        [ATTACH=CONFIG]1900[/ATTACH]

        This isn't a 'show stopper' but we really need to be able allow the user to control what fields they want displayed on the grid module display.

        Thanks.

        Curtis Brotherton
        Software Engineer
        PDMNet
        Originally posted by rr View Post
        Not every database allows an order by clause in a subquery.
        So I see your select .... FROM (select DISTINCT .. from ... ORDER BY) ...
        You can verify this solution? If the problem still persists, we can simulate this kind of situation in our systems.

        Thank you!
        Best regards,
        Thomas Soares.
        ScriptCase International.

        Email: t.soares@scriptcase.net
        Visit our Blog: http://www.scriptcase.net/blog/
        Visit out fan page: http://www.facebook.com/Scriptcase

        Comment


        • #5
          Backend database is MySQL which supports that SQL statement I am using, so I am 99.99% sure that is not the issue.

          Like I said, that See Details works FINE until I add more fields to the Colums area, that's when it blows up.

          Comment

          Working...
          X