Advanced Search Checkbox for "search only in open tickets"

Markus4

Hi,in advanced search, its not possible to filter to the State "OPEN" ....i tried to implement a checkbox to do that "search only in State 'open' " but i don't find out who I get the variable of the checkbox into the sql query...has anybody a mod or a hint?I know it will be solved in dev-next. but i cant wait.thanks very much!

ntozier

It is possible.Click Advanced SearchChange "Statuses" to Open.enter keywords, or whatever.Click Search.Works for me.

Markus4

i have 10 diffrent statuses. 6 of them are state "open"

So if i choose "Status" open, it does only search in "status" open, but not in all "state" open. State and status are not the same.

can you check if it still work on your installation?

Chefkeks

The Advanced Search is being revamped and the improvement will come with some of the future versions I guess (no ETA). See this pull request: https://github.com/osTicket/osTicket-1.8/pull/1528

ntozier

SO if I interpret this correctly...You want Grapes to mean all Fruits, not just Grapes.ieFruits- Grapes- OrangesYou want to search Fruits and get all results for all sub categories as well. That's not how it works .

Markus4

I have several open status. Like:

Open

Evaluate

Reopen

OnHold

...

And then i have close status like

Closed

Denied

...

Now i want to search all open tickets that are assigned to a team xy.

I want to find all "open", "evaluate", "Reopen", "on hold" .... bit not the "closed" and "denied" tickets...

So i beed a checkbox or a multi selectable dropdown for status.

Can someone tell me where I can find the part of the sourcecode where i can imolement that?

I found the query for the list view but i dont know how i can implement there an aditional var and how i can get this post var into it.

And a dont understand where to find the query for the advanced search...

Markus4

SOLVED:in File: ajax.tickets.phpLine159 (insection "Flags")i added: case 'open': $criteria = 'open'; $where .= ' AND status.state="open" '; break;and in File ticket.inc.php around line 602 in the advanced form filed set "Flags"i added the Line:<option data-state="open" value="open"><?php echo __('Open Tickets');?></option>Now I can search in the "Open" state, by using the flag filter "open tickets"