[kambilot]

1 year, 1 month 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.

[kambilot]

1 year, 1 month 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]

1 year, 1 month 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.

[kambilot]

1 year, 1 month 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]

1 year, 1 month 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 1 year, 1 month ago by Daniel Bieberstein.
• This reply was modified 1 year, 1 month ago by Daniel Bieberstein.

[Daniel Bieberstein]

1 year, 1 month 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

[kambilot]

1 year, 1 month 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]

1 year, 1 month 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

[kambilot]

1 year, 1 month 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.