Thought it would be a good idea if we could have a dedicated topic for people to discuss how the new trade search works, especially some of its more advanced features such as the custom keyword syntax. If you haven't already read the guidance, go and start a new search, and click the 'Syntax' button there.
Share your custom codes, ask questions to each other, discuss your methods, and basically let's learn together how the new search works. If you see some useful routes or find some aspects of it particularly useful, please share your thoughts here so I know which bits need expanding on or improving.
Thought it would be a good idea if we could have a dedicated topic for people to discuss how the new trade search works, especially some of its more advanced features such as the custom keyword syntax. If you haven't already read the guidance, go and start a new search, and click the 'Syntax' button there.
Share your custom codes, ask questions to each other, discuss your methods, and basically let's learn together how the new search works. If you see some useful routes or find some aspects of it particularly useful, please share your thoughts here so I know which bits need expanding on or improving.
I was having trouble getting it to work the way I wanted until I saw the little option box for searching not just "titles" but "all".
Question: any way to search title+descriptions only? I see title OR description OR all (which includes offers). For example, I'd like to be able to search for "Raven Frost perfect" in titles and descriptions only, without picking up search results that include people offering "perfect" gems for low roll Raven Frost
wale wrote: 3 years ago
I was having trouble getting it to work the way I wanted until I saw the little option box for searching not just "titles" but "all".
Question: any way to search title+descriptions only? I see title OR description OR all (which includes offers). For example, I'd like to be able to search for "Raven Frost perfect" in titles and descriptions only, without picking up search results that include people offering "perfect" gems for low roll Raven Frost
wale wrote: 3 years ago
I was having trouble getting it to work the way I wanted until I saw the little option box for searching not just "titles" but "all".
Question: any way to search title+descriptions only? I see title OR description OR all (which includes offers). For example, I'd like to be able to search for "Raven Frost perfect" in titles and descriptions only, without picking up search results that include people offering "perfect" gems for low roll Raven Frost
Screen Shot 2021-11-15 at 05.50.24.png
Hybrid includes offers. I want to EXCLUDE offers: only search title+description. Maybe I'm in the minority and it isn't a high priority feature, but I guess I can be the first to request it, haha.
Thanks for the new site regardless, and even having hybrid search as it currently is a huge improvement over before.
Hey, thanks again for all the good work. Im getting lots of errors while using advanced search:
"General Error
SQL ERROR [ mysqli ]
Unknown column 't.legacy_resu' in 'where clause' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists."
I noticed it seems to happen more often if I choose "Display as posts" and leave region unmarked.
I might be silly, but im having some troubles to use adv.search correctly, lets say if I would want to search ring with both these stats included: mana stolen+all resistances, how should I search? I've been trying a lot in different ways found in Syntax.
Fury wrote: 3 years ago
I might be silly, but im having some troubles to use adv.search correctly, lets say if I would want to search ring with both these stats included: mana stolen+all resistances, how should I search? I've been trying a lot in different ways found in Syntax.
You could try the expression Ring (mana stolen|all resist) or any combination of exact names or phrases. Or you could just search those attributes and select 'rings' from the trade filter. Make sure your own default filters aren't excluding too many results from your searches - they work on an AND logic.
Question:
Using the "one of.." lists, what's the syntax to include a space in the search terms?
Example:
Say I want to search for any Archon Plate or Lacquered Plate of whatever, specifically including the "plate" part, not worrying about the space I'd start out with
(Archon Plate|Lacquered Plate). However, actually executing that as a search replaces the spaces and turns it into (archon|plate|lacquered|plate), then resulting in literally any "plate" and not just archon or Lacquered Plate. Tried a few of the more common space replacements or quoting the entire search term, nothing seems to work so far. Figured asking may be the simplest solution.
@Schnorki Yeah it treats each keyword separately. Have you tried just searching (lacquered|archon) and then refined
the results after with the 'plate' keyword?
Teebling wrote: 2 years ago
@Schnorki Yeah it treats each keyword separately. Have you tried just searching (lacquered|archon) and then refined
the results after with the 'plate' keyword?
That should work for the given example, true.
Though it wouldn't in other possible scenarios (say "Archon Plate" and "Dusk Shroud") which would make a space convenient to have, hence my curiosity as to whether there is one. Though even for those, there's probably some decently working workaround as well, given the exact search needs.
Side note: Yes, this is a very first world problem for me to have. The search as is, even without (knowing how to add a) space here, is pretty damn good.
I'm sorry but I'm striggling to get it to work. I'm trying to find a amulet with +1 druid skills, some resist all and FCR. I'm typing Amulet(skills|resistances), but I'm getting a error?
Astragoth wrote: 2 years agoI'm trying to find a amulet with +1 druid skills, some resist all and FCR. I'm typing Amulet(skills|resistances), but I'm getting a error?
Is there a syntax to find a specific string? I want to find 20% fcr amulet, using ' amulet "20% fcr" ' does not work.
Is there a way to search for only new threads (started within a day or two) instead of all that had been bumped?
Also, would be nice to have a possibility to search without any string while using advanced search. E.g. to pick a champ, skiller and res to list all items that do match.
AdamCz wrote: 2 years ago
Is there a syntax to find a specific string? I want to find 20% fcr amulet, using ' amulet "20% fcr" ' does not work.
Unfortunately not. The search engine treats each word separately, because it indexes each individual word.
I had a look into reconfiguring to accept 'exact matches', as per your example, but it's not a simple task and would require changing from phpBB's native fullsearch engine to the MySQL engine solution.
There is, however, a workaround which will get you close to the desired results.
Keyword search for 'fcr' and '20' in the 'Amulets' item type category
Remember, up until now you have only been searching in the trade titles themselves. So, in order to broaden your search further, try searches using the different options available at the top. This will allow you to search in titles (default), search in descriptions only, search in descriptions AND titles (hybrid) etc.
Search options
Some people put attribute details like the 20% FCR in the title, whereas some will put that extra information in the description. Make sure you're targeting the right area to search in
AdamCz wrote: 2 years ago
Is there a way to search for only new threads (started within a day or two) instead of all that had been bumped?
Yes. When you get to the search results, you have some basic time sorting options (and it is based off the original time of the listing, not bump times). Click 'Sorting', and then select the timeframe you want from the 'Display:' dropdown. You can also configure sorting of the results from the same menu. There are a limited number of options for the time being, can potentially expand later if it needs to be more granular than the 1d, 7d, 1m etc. options currently available.
@AdamCz alright cool. I think the data I was testing with was misleading me - can see from your screenshot that it's querying last_post_time instead of topic_time (original).
List trades and earn trust
Level up as you post
Give and Receive Likes
Discreet Notifications
Avatar & Profile customisation
Private Messaging
Bookmark Pages & Posts
Use Drafts & Revisions
Attach Images
Squelches this trader, making their offers on your trades invisible to anyone except themselves. Their trade listings will also be hidden from your marketplace.
Your squelch list can be managed and edited from Top right dropdown > Account Prefs > Squelches.
Advanced keyword search expressions
Teebling
Hide ads
Wostr
Teebling
17Admin