• Leonid Gauss
        Has successfully completed the online course Intermediate (200)
        Has successfully completed the online course Basics (100)
      7 months ago #45096

      Hello,

      I would like to create a SelectBox above a table in which you can select auction numbers from completed auctions. I have created a SQL-Connector and this also returns the collection of the desired auction numbers, e.g.: 1,2 or 3. Which widget exactly do I need to use for this – SelectList, ActionSlect? I would like the data of the selected auction to be loaded into the table based on this number when a number is selected in the SelectBox.
      What do I need to do to make it work – I don’t have an example anywhere.

      Thank you in advance,

      best regards Leonid.

      Leonid Gauss
          Has successfully completed the online course Intermediate (200)
          Has successfully completed the online course Basics (100)
        7 months ago #45152
        Up
        1
        Down
        ::

        Hello Daniel,

        you write in your answer: “…In the UI designer, add a combobox and add an item to this combobox…”
        What kind of item exactly?

        Many thanks in advance

        Best regards Leonid

        Jan-Niklas Böhnke
            Has successfully completed the online course Introduction
            Has successfully completed the online course Basics (100)
          7 months ago #45111
          Up
          0
          Down
          ::

          Hello Leonid,

          you can use a toolbar in which you place a togglebutton. In the datasource of the togglebutton you can specify your result array of the desired auction numbers. This will give you a togglebutton for each element of your array. See Image attached.

          Attachments:
          You must be logged in to view attached files.
          Leonid Gauss
              Has successfully completed the online course Intermediate (200)
              Has successfully completed the online course Basics (100)
            7 months ago #45122
            Up
            0
            Down
            ::

            Hello Jan-Niklas,

            Thank you for your reply. I need for bidder portal archive a SelectBox, which can be opened and there the numbers of the past auctions are displayed, which can be selected, because there are 5 auctions per year and already after 2-3 years that would be too many buttons with the toggle button solution in the toolbar. The problem I have – no matter whether I try “Select”, “Action Select” or “Select List” widgets – I include the data source (SQL connector) in the App Designer with the widget, the widget is also displayed in the App Designer preview, but nothing is displayed in the browser after deploying. And when I try to fill the widget with data in the process logic in the “onBeforeShow” event (as I know it from filling the tables with data), there is no data in “items” of the widget – see screenshots in the attachment. What is missing/what am I doing wrong? Thank you very much.

            Best regards Leonid

            Attachments:
            You must be logged in to view attached files.
            Daniel Bieberstein
                Has successfully completed the online course Introduction
                Has successfully completed the online course Intermediate (200)
                Has successfully completed the online course Advanced (300)
                Has successfully completed the online course Basics (100)
                Has successfully completed the online course Advanced (310)
                Has successfully completed the online course Advanced (320)
              7 months ago #45147
              Up
              0
              Down
              ::

              Hey Leonid,

              in your case i’d suggest using a combobox widget. The normal “dropdown” would be a select widget but since you already mentioned that the amount of data will sum up, the combobox would be the better solution. The combobox gives the user the possibility to select the entries like in a dropdown menu but also lets the user type in values into the field. The typed in value will then be used to give some suggestions. if there are e.g. 20 entries in the list and 3 of those entries begin with “123” the user can type in “123” and the available items will get filtered to only display those items that include “123”.

              A regular select / dropdown without the possibililty for the user to filter should be user if there are no more than 7 items based on general usability recommendations.

              In the UI designer, add a combobox and add an item to this combobox. Select the item inside the combobox and use the property “datasource” to select the connector you want to use and the collection “GET_VersteigerungsNr_result_Col”. Afterwards you can map the text and key of the item. Last but not least drag the datasource property from the UI designer into the process designer. This will create a connector node with the output mapping already setup. You should be able to connect this to the “onBeforeShow” event of your screen.

              You than can use the change / selectionChange event of this Combobox to trigger further logic.

              Should there still be problems please share some screenshots of the UI designer / datasource mapping and the process designer where the connector is called.

              Best regards and have a nice weekend,
              Daniel

              • This reply was modified 7 months ago by Daniel Bieberstein.
              Daniel Bieberstein
                  Has successfully completed the online course Introduction
                  Has successfully completed the online course Intermediate (200)
                  Has successfully completed the online course Advanced (300)
                  Has successfully completed the online course Basics (100)
                  Has successfully completed the online course Advanced (310)
                  Has successfully completed the online course Advanced (320)
                7 months ago #45153
                Up
                0
                Down
                ::

                Hey Leonid,

                you can use an ui_core_item, sorry i should have made that clear right away.

                Best regards,
                Daniel

                Leonid Gauss
                    Has successfully completed the online course Intermediate (200)
                    Has successfully completed the online course Basics (100)
                  7 months ago #45161
                  Up
                  0
                  Down
                  ::

                  Hey Daniel,
                  I did everything as you described, but the ComboBox is still invisible in the browser after deploying, see screenshots.

                  Greetings Leonid

                  Attachments:
                  You must be logged in to view attached files.
                  Daniel Bieberstein
                      Has successfully completed the online course Introduction
                      Has successfully completed the online course Intermediate (200)
                      Has successfully completed the online course Advanced (300)
                      Has successfully completed the online course Basics (100)
                      Has successfully completed the online course Advanced (310)
                      Has successfully completed the online course Advanced (320)
                    7 months ago #45166
                    Up
                    0
                    Down
                    ::

                    Hey Leonid,

                    is the combobox part of a module? if yes: have you deployed the application as well after deploying the module?
                    Is there any kind of binding set to visible property of either the combobox or the flexbox it’s part of / is the flexbox set to visible?

                    You might as well want to clear your browsers cache. Depending on the browser your using you can find how to do this with a quick google search.

                    Best regards,
                    Daniel

                    Leonid Gauss
                        Has successfully completed the online course Intermediate (200)
                        Has successfully completed the online course Basics (100)
                      7 months ago #45169
                      Up
                      0
                      Down
                      ::

                      Hey Daniel,

                      this error that the ComboBox is not visible in the Borwser has something to do with the outdated Simplifier version on our test environment (7.0.171-LTS.1033), I tested this with the ComboBox on the customer system (version 8.0.121) and it worked there.

                      Thanks for your help.
                      Best regards Leonid Gauss.

                    Viewing 9 posts - 1 through 9 (of 9 total)

                    You must be logged in to reply to this topic.