Announcement

Collapse
No announcement yet.

[SOLVED] Quicksearch in Forms / Grids

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

  • [SOLVED] Quicksearch in Forms / Grids

    Hi,

    i have a form (show single record) with tabs. In one tab is a grid with quicksearch enabled. The quicksearch field is not shown (header is enabled) ...

    In another tab is a form (editable grid view) also with quicksearch field. The quicksearch field appears, but the search result is totally wrong. The where clause from the editable grid view is not observed! Only the searchterm from the quicksearch field (search in all fields) ... Result: records are displayed, that not belong to the master record!

    Grid and form (editable grid view) not in tabs works as expected.
    Last edited by RHS; 06-10-2013, 08:24 AM.
    Best regards: - Reinhard -

    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

  • #2
    Hello,

    Please contact our support regarding this issue. Our chat is active on workdays from 8:00am to 6:00pm, and our ticket system is always available.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Excuse me Bernhard, but your support ist slow and often not answering ...

      You can easy reproduce the bug in SC 7 within 5 minutes: create a form (single record view) with 2 tabs and link a grid / form as detail as posted in my first post. You can't see the quicksearch field on the tab grid and the where clause (where clause for master to detail link) is not observed on the tab form when used the quicksearch field!
      Best regards: - Reinhard -

      I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

      Comment


      • #4
        The wrong where clause generated by scriptcase:

        Code:
        SELECT  top 20 Nummer, Mandant, Adresse, Ansprechpartner, Telefon, Telefax, EMail, Mobilfunk from dbo.KHKAnsprechpartner where (Mandant = 1 AND Adresse = 507)  and Ansprechpartner like '%scriptcase%' or Telefon like '%scriptcase%' or Telefax like '%scriptcase%' or EMail like '%scriptcase%' or Mobilfunk like '%scriptcase%' order by Nummer
        The correct clause:

        Code:
        SELECT  top 20 Nummer, Mandant, Adresse, Ansprechpartner, Telefon, Telefax, EMail, Mobilfunk from dbo.KHKAnsprechpartner where (Mandant = 1 AND Adresse = 507)  and (Ansprechpartner like '%scriptcase%' or Telefon like '%scriptcase%' or Telefax like '%scriptcase%' or EMail like '%scriptcase%' or Mobilfunk like '%scriptcase%') order by Nummer
        (Brackets missing before "Ansprechpartner" and after "or Mobilfunk like '%scriptcase%'")
        Best regards: - Reinhard -

        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

        Comment


        • #5
          Hello Reinhard,

          Issue reported to our bugs team. Although I strongly believe you may find a solution faster by getting in touch with our support.

          regards,
          Bernhard Bernsmann

          Comment


          • #6
            Hi Bernhard,

            Originally posted by bartho View Post
            Issue reported to our bugs team.
            thank you!

            And the problem that quicksearch field is not display on grids in tabs? "Feature" or bug?
            Best regards: - Reinhard -

            I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

            Comment


            • #7
              Hello Reinhard,

              That is actually the default behavior of Detail applications. Almost everything from the toolbar isn't displayed.

              regards,
              Bernhard Bernsmann

              Comment


              • #8
                Hi Bernhard,

                Originally posted by bartho View Post
                That is actually the default behavior of Detail applications. Almost everything from the toolbar isn't displayed.
                unfortunately ... actually is not unusual that you would search in a detailed grid. For example although many contacts exist in a company. It would therefore already attached when the quick search also works in detail.

                Thank you.
                Best regards: - Reinhard -

                I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                Comment


                • #9
                  Originally posted by RHS View Post
                  Hi Bernhard,



                  unfortunately ... actually is not unusual that you would search in a detailed grid. For example although many contacts exist in a company. It would therefore already attached when the quick search also works in detail.

                  Thank you.
                  Hello,

                  Some of our users have sent as a suggestion that the toolbar should keep all items (or most of it) on a detail application. Our development team is analyzing the suggestion.

                  regards,
                  Bernhard Bernsmann

                  Comment


                  • #10
                    Search-Problem not solved in SC v7.0.006
                    Best regards: - Reinhard -

                    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                    Comment


                    • #11
                      Hello Reinhard,

                      As I mentioned before, that is the actual default behavior of detail applications. It isn't a bug, it is just how detail applications were designed.

                      regards,
                      Bernhard Bernsmann

                      Comment


                      • #12
                        No Bernhard, look at post #4, the generated sql code is wrong (missing brackets). This is a bug, not a design feature ...
                        Best regards: - Reinhard -

                        I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                        Comment


                        • #13
                          Hello Reinhard,

                          Just to keep you updated, I'm reviewing the issue you posted. I had confused with another problem, sorry about that.

                          regards,
                          Bernhard Bernsmann

                          Comment


                          • #14
                            Hello Reinhard,

                            Just to keep you updated, I'm reviewing the issue with our bugs team.

                            regards,
                            Bernhard Bernsmann

                            Comment


                            • #15
                              SC 7.00.0013 - not solved
                              Best regards: - Reinhard -

                              I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                              Comment

                              Working...
                              X