We have our winners! Thank you for reading and voting [ Dismiss ]
Home » Forum » Bug Report and Feature Requests

Forum: Bug Report and Feature Requests

Is Category search SQL, or something else/custom

tenyari 🚫

Let's say I do a Category search:

Showing: This [OR] That [OR] TheOtherThing

I'm asking about how the query is handled because if it's handled similar to something like SQL; I'd like to request a new feature (or find out how to do it if it's already there). For a search like this:

Showing: This [OR] (That [AND] TheOtherThing)

When I pick what to search on, there are two check boxes

- [] + []

I guess what I would need would be a LOT more complicated to make the UI for...

- [], + [], & []
- would actually not do it.

That would result in:

Showing: (This [OR] That) [AND] TheOtherThing

So what it might need is an input text box that fills in all the things you have checked as '+', and then you can change the [OR] to an [AND] as well as put in parenthesis, or even just let you type in an SQL query.
- if you edit this box, it then overrides the rest of your search, and if what you put in the box is invalid, it just returns an error that has a link to an external SQL website... :)

The problem with just 'toggling the check mark boxes' is the question of where the person wants the parenthesis. What things need to be in the 'and' and what don't.

The 'simpler solution' is already in there:

Find Stories having [Any,All,Exact Match] of the selected codes

So this is a 'niche' request for edge cases. Understandably low priority.

Switch Blayde 🚫

@tenyari

- [] + []

It's not the -/+ that controls the and/or in the boolean logic. It's the "Find stories having ALL/ ANY/EXACT MATCH

The - would be the NOT in the boolean logic.

What you're asking for is rather complex for Lazeez.

Lazeez Jiddan (Webmaster)

@tenyari

The categories search page is SQL.

What you're asking for is easy to do in SQL, but nearly impossible to build an interface for.

However, it is actually doable currently, but not where you expect.

In the contents search (bottom of Advanced search) if you switch to 'Extended Query Search' you can accomplish what you want. There is a link to the extended query search documentation for syntax to use.

Replies:   tenyari  richardshagrin
tenyari 🚫
Updated:

@Lazeez Jiddan (Webmaster)

Thanks. That looks close to what I'm looking for. And with the top section of advanced search it seems to be able to deliver what I'm trying to find.

EDIT: This looks to be exactly what I was trying to achieve with my questions on SQL.

richardshagrin 🚫

@Lazeez Jiddan (Webmaster)

syntax

And you don't have to pay the sin tax.

Back to Top

Close
 

WARNING! ADULT CONTENT...

Storiesonline is for adult entertainment only. By accessing this site you declare that you are of legal age and that you agree with our Terms of Service and Privacy Policy.


Log In