My goal is to develop an interface by using this form of data. The planned interface has two parts. The first part is asking the customer to add a new line or set the status as passive like shown below;
In the second part, when a customer choose adding a new line, the interface should look like this;
In the image shown above, dropdown menus should be filtered according to the change of the previous one consecutively. (Note: As the data dynamic, we can’ t define a static list for each dropdown). Text Input 1, Operator Dropdown (contains sql operators like <,NOT IN, LIKE vs.), Text Input 2 are created SQL Syntax column in the given excel. For example; a customer writes column1 for text input 1 and select a desired operator (let <) for operator dropdown and writes “5” for text input 2.
Having filled these parts and click OK button bottom right, filled data should be added the table like below;
The filled data can be stored as flow variables. With these flow variables, db writer node can be feeded these datas and the corresponding data can be inserted the data table.
When a customer select a “set the corresponding status passive” selection, the actual table should be opened and the user should be able to set the status passive when a user selects a row on the table and presses the OK button.
Thanks in advance,
You should check if you cannot create something similar to your requirements with the configuration/widget nodes combined with the view nodes. (this is easier to setup without prior knowledge)
Always dangerous to say something is easy… without being able to do it yourself…
But I think what you want should be somewhat possible with the above mentioned nodes and a loop/recursive loop
If it is based on user interaction, there are a few nodes, such as the single selection configuration node suggested by @AnotherFraudUser that offers interaction. You can then implement some logic based on what the user input.
Hi @KKERROXXX , I see. Indeed, for this kind of interaction, you will need JS as it supports events such as onclick/onchange, as opposed to Knime where you have to click Next to continue to the next node and load a new screen for the “dynamic” drop down (as in values would be populated based on the results of the previous node).
So, your options would be to learn JS, or go with the “Next” screen (no instantaneous refresh).
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.