Hi, here is the description. In a dashboard there is time range picker with its token time_tkn and 2 dropdowns. The first dropdown is connected with the time_tkn (index=index1 host=host1 earliest="$time_tkn.earliest$" latest="$time_tkn.latest$"). Output is a varchar list. This dropdown has its token (dropdown1_tkn). Example: selected value from the dropdown is Text1 Text2. So dropdown1_tkn=”Text1 Text2” There is lookup table table1, which has these important columns: workplace, orderId, start_date, start_time, end_date, end_time. start_date, end_date have this format: %d.%m.%Y. start_time, end_time have this format: %H:%M:%S Output in dropdown should be a list of orderId. Here is condition for the list of the dropdown2: to select every orderId from lookuptable, where workplace=$dropdown1_tkn$ and start_date+start_time>=$time_tkn.earliest$ AND end_date+end_time<=$time_tkn_latest$ Can anybody help, please?
... View more