Znuny Open Source Ticketsystem

I think I figured it out. Your help led me to adding a new dynamic field with date/time rather than just date. This improved things but searches were still inconsistent. After some more digging, I found that when I removed "Prevent entry of dates in the future" from the dynamic field defin...

No. The dynamic field is defined for a ticket. That's what surprised me when I saw the SQL statement. So, I see two things not right with the SQL statement when I use Service Date (between) for the search filter: - The FROM table is dynamic_field rather than dynamic_field_value - It's looking for an...

I did some monitoring of the SQL statements during each of the search methods. I setup each search with the desired settings to where I only had to click the Search button to run. Before clicking Search, I enabled general logging in MariaDB. Then I clicked Search. This method captured all SQL statem...

Yes, the search I'm using is from the main menu Tickets > Search. I am using no other filters when performing the Service Date (between) search. I am at the early stages of evaluating the program so I only have 1 queue and 3 agents defined so far. I have tried searching while logged in as either of ...

Hello community. Our field techs are self-dispatched, meaning that they respond directly to customer trouble reports and deal with the paperwork afterwards. Tickets may be created the same day or a day or two after the service was performed. As such, I have created a dynamic field named Service Date...