First up, unfortunately i am not able to download example workflows, so i am hoping someone can describe a solution.
I have a table in an SQLite database which contains records grouped by a date value.
I want to read the date column from this table, make the values distinct and sorted descending order (normally i would do both of these things via SQL, but explicitly including as steps here in case i need to do these things differently) and then prompt the user to select one of the date values from a drop-down list.
Further downstream in the flow, i want to use the selected value as a flow variable to get all records from the table which have that value in the date column.
I have tried selecting and reading from the date column in my table and then passing to a Value Selection Widget or a Nominal Row Filter Widget, but both of these give me error messages either about no columns with domain information or no column available for selection in input table.
Can anyone assist?