Announcement

Collapse
No announcement yet.

Capture link can't filter (URGENT)!!!! (Part 2)

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

  • Capture link can't filter (URGENT)!!!! (Part 2)

    TL;TR
    Can't get on SC7/SC8 a capture link work, passing a field/variable as parameter to filter a grid


    After last update, tried again, of course, without success.

    This is the enviroment.
    http://1drv.ms/1uCMJLs

    In this link, there a a project (SC7) to import and a SQL file to replicate database.

    Database is easy.
    customers, addresses, and customer-addreses
    customers has a field, where I want to store the default customer-addreses to use.

    On SC, there are a grid and form for each table. Grid_customer_addresses has SQL modified to filter just customer addresses with a [glocustomer].
    On Form_customer, try to create a capture link over defaultaddress field, pointing to Grid_customer_addresses, and it suppose, then you can choose how do you want to fill [glocustomer] on Grid_customer_addresses, field, variable, fixed and empty, but instead, I got this:


    Captura.JPG
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

  • #2
    Any idea? I have stopped my development more than 1 week for this
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Hello,

      Issue reported to our bugs team.

      regards,
      Bernhard Bernsmann

      Comment


      • #4
        Originally posted by bartho View Post
        Hello,

        Issue reported to our bugs team.

        regards,
        Bernhard Bernsmann
        It's reported and talked with Ronyan. As far as he sais, will be solved in next version.
        /Giuseppe

        Professional Scriptcase Services
        Some Customers opinions

        Comment


        • #5
          Yes.
          It's already inside our To Do list.
          Regards,
          Cavadinha

          Development Team
          Netmake - IT Solutions

          Comment


          • #6
            Originally posted by Cavadinha View Post
            Yes.
            It's already inside our To Do list.
            I hope to see it solved soon. I'm stopped
            /Giuseppe

            Professional Scriptcase Services
            Some Customers opinions

            Comment


            • #7
              Originally posted by Giu View Post
              I hope to see it solved soon. I'm stopped
              Looks urgent enough, what is the status?
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Hello,

                This problem it is not a bug, because the field option has never been available to capture links.

                This implementation has been passed to our development team to be analyzed. However, the support will give you a workaround for this case.
                Best Regards,
                John L. Santos

                Bug Tracker Team
                NetMake - IT Solutions

                Comment


                • #9
                  If there is a workaround please share with all.
                  Thanks
                  Giorgio Bravi
                  Dolphin Software & Thinkware
                  www.dolphin.it

                  Comment


                  • #10
                    Hi John.

                    I would like an update about this. I still can't understand how a basic feature like this is not implemented. A basic feature a lot of easy to implement.

                    I know you say is not a bug but a new feature, and I insist is in SC DOCUMENTATION, I'm not crazy.

                    http://www.scriptcase.net/docs/en_us...lications/link

                    Captura.JPG

                    ....
                    In the window below “Definition of Parameters”, at the left side, is shown the application fields which we are linking and that need to receive parameters to execution and, at the right side, will must be selected the option for passing value, there are three options, they are:

                    Field - When choosing this option have to inform the field to be used for passing content.

                    Value - In case of selecting this option in the text field inform fixed content to be passed.
                    Empty - Choosing this option it wil be passed no value to the field.

                    Recovering the field value - It should be selected the field of the search application to the linking object, so its content return for the field the filter form.
                    ...
                    3 months has passed. Has you some christmas present for me?
                    Last edited by Giu; 12-28-2014, 08:57 AM.
                    /Giuseppe

                    Professional Scriptcase Services
                    Some Customers opinions

                    Comment


                    • #11
                      Just closed a ticket today with this workaround:
                      1. Define a session variable in form ( OUT )
                      2. Assign field value to session variable ( Ajax onChange )
                      3. Declare session variable "empty" on capture link
                      4. Add a where clause on grid with session variable ( IN )
                      In my case i've put this code in onScripInit event ( grid )
                      PHP Code:
                      if ( [filter_customer] > 0) {
                          
                      sc_select_where(add) = " where CUSTOMER_ID = [filter_customer]";

                      and this on onExecute event ( on menu )
                      PHP Code:
                      sc_reset_global([filter_customer]); 

                      +1 for your suggestion.
                      Giorgio Bravi
                      Dolphin Software & Thinkware
                      www.dolphin.it

                      Comment


                      • #12
                        Originally posted by gbravi View Post
                        Just closed a ticket today with this workaround:
                        1. Define a session variable in form ( OUT )
                        2. Assign field value to session variable ( Ajax onChange )
                        3. Declare session variable "empty" on capture link
                        4. Add a where clause on grid with session variable ( IN )
                        In my case i've put this code in onScripInit event ( grid )
                        PHP Code:
                        if ( [filter_customer] > 0) {
                            
                        sc_select_where(add) = " where CUSTOMER_ID = [filter_customer]";

                        and this on onExecute event ( on menu )
                        PHP Code:
                        sc_reset_global([filter_customer]); 

                        +1 for your suggestion.
                        I will try your workaround gbravi, thanks.
                        /Giuseppe

                        Professional Scriptcase Services
                        Some Customers opinions

                        Comment


                        • #13
                          I need this functionality also. The help documents clearly say you can create a capture link using a field as the parameter... but the option is nowhere to be found.

                          Comment


                          • #14
                            Update: I found a sort of workaround... using the above "Solution" but it is not ideal. Currently my user has to click the empty text field, which triggers an event to load the correct variable into the session variable and then click the "Lookup" Magnifying glass icon.
                            This works ok... but its clunky and the user has to remember to click the field each time.

                            Comment


                            • #15
                              Hi yourguide

                              Just put the variable assignment on the form's onLoad event

                              PHP Code:
                              [filter_customer] = {fieldCustomer}; 
                              Giorgio Bravi
                              Dolphin Software & Thinkware
                              www.dolphin.it

                              Comment

                              Working...
                              X