Native query language

I have a user that wanted to search issues that have "NO LINE" and autofax. I thought we were using xapien so I entered "no line" AND autofax in the 'all text' part of the search page. It returned 30 issues where only 1 had both parts of the search and missed another matching issue. It turns out that neither xapian nor woosh are installed, so, according to the config.ini the native search is used.

I searched the doc/ directory and the "Roundup User Guide" but didn't find much on the native query language, with regard to 'all text'.

I ended using a variation of grep to search for issues. On the tracker host, I cd'ed to where the messages are stored and entered:

dgrep -il "NO LINE" | cut '-d/' -f3 | cut -dg -f2

The dgrep program does a recursive grep search The rest isolates the message #. Then I did this query:

SELECT nodeid FROM issue_messages WHERE linkid IN (the messages #s, comma separated);

This query identified the 9 issues that contained "no line". It was a simple process to see which issues in that list also contain autofax using the issue search page.

There must be an easier way.

Tom Ekberg
Senior Computer Specialist
Department of Laboratory Medicine and Pathology
4th Floor, Pat Steel Building, currently WFH
Home: (253) 561-2509
Email: [email protected]<mailto:[email protected]>

_______________________________________________
Roundup-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/roundup-users