Icon

4. Search engine

Representation of the "Data App" component for display on the KNIME Hub. Representation of the "Search" component for display on the KNIME Hub. rated booksNavigation panelSeparate the RatedBooks view from theSearch view0: Rated books view1: Search viewSeparate differentSearch views0: Search by title1: Search by author2: Search by ISBNSwitch buttonsearch fieldconnect to db.sqliteload data from tableselect "books"Determine searchkeywordCreate labelfor the widgetauthortitleISBNvisualise search resultscheck for emptysearch query0: search returned results1: no search resultsload data from DBSearch button0: non-empty search query1: empty search query(initial run)Upon initial, run the outputis an empty string. We needto catch this and skip a DB querydummy component outputin case of initial runquery data from DBbased on the searchquery Text Output Widget Data App Single SelectionWidget Rule EngineVariable CASE SwitchVariable (Start) Rule EngineVariable CASE SwitchVariable (Start) RefreshButton Widget AutocompleteText Widget SQLite Connector DB Reader DB Table Selector Rule EngineVariable String Manipulation(Variable) Search Search Search Table View CASE SwitchData (End) Rule EngineVariable CASE SwitchData (Start) Table Rowto Variable DB Reader RefreshButton Widget CASE SwitchVariable (Start) Rule EngineVariable Variable toTable Row DB Row Filter CASE SwitchData (End) Representation of the " Data App" component for display on the KNIME Hub. Representation of the "Search" component for display on the KNIME Hub. rated booksNavigation panelSeparate the RatedBooks view from theSearch view0: Rated books view1: Search viewSeparate differentSearch views0: Search by title1: Search by author2: Search by ISBNSwitch buttonsearch fieldconnect to db.sqliteload data from tableselect "books"Determine searchkeywordCreate labelfor the widgetauthortitleISBNvisualise search resultscheck for emptysearch query0: search returned results1: no search resultsload data from DBSearch button0: non-empty search query1: empty search query(initial run)Upon initial, run the outputis an empty string. We needto catch this and skip a DB querydummy component outputin case of initial runquery data from DBbased on the searchquery Text Output Widget Data App Single SelectionWidget Rule EngineVariable CASE SwitchVariable (Start) Rule EngineVariable CASE SwitchVariable (Start) RefreshButton Widget AutocompleteText Widget SQLite Connector DB Reader DB Table Selector Rule EngineVariable String Manipulation(Variable) Search Search Search Table View CASE SwitchData (End) Rule EngineVariable CASE SwitchData (Start) Table Rowto Variable DB Reader RefreshButton Widget CASE SwitchVariable (Start) Rule EngineVariable Variable toTable Row DB Row Filter CASE SwitchData (End)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Ivan.Prigarin
Created at: 2021-10-14
On NodePit since: 2021-10-19
Last update: 2024-11-21
Created with KNIME version: v4.4.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!