Icon

5. Rating Search Results

Representation of the "Rate" component for display on the KNIME Hub. Generate the possible label values for the Labelling View node.The labels are: 1, 2, 3, 4, 5 Write rated books to the DB. The write only happens if at least one book was rated. Navigation panel Ratings Search engine Representation of the "Data App" 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 buttonconnect to db.sqlitecheck for emptysearch query0: search returned results1: no search resultsrate search resultstitleauthorsISBNcollate valuesinto a group columnpossible label valuescreate a flow var.as a string collectionprettify column namesonly keep books thatwere ratedNode 288keep ISBN and ratingget number of rows0: at least 1 book rated1: no books ratedcheck ifat least one bookwas ratedISBN -> isbnNode 297Rating buttonselect ratings tablecheck if bookalready ratedby userNode 304book addednotificationdefine colour schemefor labels Text Output Widget Login Single SelectionWidget Rule EngineVariable CASE SwitchVariable (Start) Rule EngineVariable CASE SwitchVariable (Start) RefreshButton Widget SQLite Connector CASE SwitchData (End) Rule EngineVariable CASE SwitchData (Start) Table Rowto Variable Labeling View Rate Search Search Search Create CollectionColumn Table Creator Table Rowto Variable Column Rename Row Filter DB Writer Column Filter Extract TableDimension CASE SwitchData (Start) Rule EngineVariable Column Rename Variable toTable Column RefreshButton Widget DB Table Selector ParameterizedDB Query Reader ReferenceRow Filter Text Output Widget Data App Variable Creator Representation of the " Rate" component for display on the KNIME Hub. Generate the possible label values for the Labelling View node.The labels are: 1, 2, 3, 4, 5 Write rated books to the DB. The write only happens if at least one book was rated. Navigation panel Ratings Search engine Representation of the "Data App" 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 buttonconnect to db.sqlitecheck for emptysearch query0: search returned results1: no search resultsrate search resultstitleauthorsISBNcollate valuesinto a group columnpossible label valuescreate a flow var.as a string collectionprettify column namesonly keep books thatwere ratedNode 288keep ISBN and ratingget number of rows0: at least 1 book rated1: no books ratedcheck ifat least one bookwas ratedISBN -> isbnNode 297Rating buttonselect ratings tablecheck if bookalready ratedby userNode 304book addednotificationdefine colour schemefor labels Text Output Widget Login Single SelectionWidget Rule EngineVariable CASE SwitchVariable (Start) Rule EngineVariable CASE SwitchVariable (Start) RefreshButton Widget SQLite Connector CASE SwitchData (End) Rule EngineVariable CASE SwitchData (Start) Table Rowto Variable Labeling View Rate Search Search Search Create CollectionColumn Table Creator Table Rowto Variable Column Rename Row Filter DB Writer Column Filter Extract TableDimension CASE SwitchData (Start) Rule EngineVariable Column Rename Variable toTable Column RefreshButton Widget DB Table Selector ParameterizedDB Query Reader ReferenceRow Filter Text Output Widget Data App Variable Creator

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-18
Last update: 2024-09-16
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!