Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] Suggestions

Thread Tools Rate Thread Display Modes
Old 11-09-2007, 05:07 PM
Quantum7 Quantum7 is online now
Registered User
Join Date: 10-01-2007
Location: Netherlands
Posts: 71
Searching - SQL Search

This has been suggested before, but the suggestion is hidden in a question thread. Therefore this separate thread.

The suggestion is to have a 'SQL' advanced search. In that SQL Search the user would be able to store query's from SQLite, which can be executed directly from UR. Meaning you make i.e. a complex query (which isn't possible the UR search), you store it in UR and execute it every time you need it.

Basically I'd envision something which would i.e. work like this:
1. Insert Child Search.
2. Click a "SQL" button (only visible in advanced mode).
3. A single (big) text field appears.
4. The user can paste a SQL query he made in SQLite in this text field.
5. UR stores the SQL query in a text field (as simple text).
6. The user can execute the search; UR directly uses the query text to execute it's search. If the query is invalid an error is shown. If not: jackpot.
7. The user now has a saved search in UR which can work like a normal search; only all search options that are possible in the syntax used by SQLite can be used in UR.

- Main advantage might be that search can remain simple while still allowing extreme flexibility.
- Update and Delete could be disallowed to prevent the user from doing things that would completely mess up their database.
- Syntax checking would be unnecessary; it's an advanced advanced feature --> The user should know what he's doing.
- Variable's. At least one variable could be useful.
- Manual editting from SQLite to UR could be acceptable; it's an advanced advanced feature.

Last edited by Quantum7; 11-09-2007 at 05:10 PM.
Reply With Quote
Old 11-09-2007, 07:07 PM
quant's Avatar
quant quant is online now
Registered User
Join Date: 11-30-2006
Posts: 967
this suggestion has my vote, especially if only "passive" searches are allowed, ie. no update/delete as those could essentially be done afterwards on the found items (where the proper checks are already implemented).

But as was mentioned elsewhere, maybe being able to search through parent/child attributes would be enough for the beginning. This should be straightforward to implement ;-)
Just triple the list of available attributes in the advanced search (second and third copy of attributes preceded with parent: and child: respectively) and do the proper sql queries on the backend ;-)
Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

All times are GMT -5. The time now is 01:07 PM.

Copyright 1999-2019 Kinook Software, Inc.