Query Input Form

[Bob Sneidar]

Thanks Trevor. I was actually looking for a Livecode stack/card that already had the objects and code for adding/deleting conditions for the search. I want to upgrade my Forms Generator reporting to be like Crystal Reports, so that I could have a card where the user enters a customer searching by name or ID, a site by name or ID or address or city, a device or list of devices installed on, before, after or within a date range etc. Right now I have the user load all that data into an interface and manually select the  items they want from a series of datagrids, but this isn't very intuitive to my mind. The coding that converts the SQL queries into sqlYoga I can grok well enough. 

I can build the interface myself, but I'm lazy, and someone else would probably do a better and cleaner job than me. And I wouldn't mind paying a fee for it either. 

Bob S


> On Oct 13, 2017, at 06:58 , Trevor DeVore via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> On Thu, Oct 12, 2017 at 10:00 AM, Bob Sneidar via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> 
>> Has anyone put together a query input form, that can take simple input
>> from a user, like:
>> customers.customername is/is not/is greater than/is less than/is like
>> <value> AND/OR
>> <next condition> AND/OR
>> <next condition> ...
>> 
>> and then build an sql query for it?
>> 
> 
> Bob,
> 
> If you are using SQL Yoga with this project then Scopes will make the SQL
> Query part very straightforward. You would create a scope for each
> condition and then add the scope to the SQL Query object based on the user
> input in the form. SQL Yoga will generate the WHERE clause using any scopes
> that have been added to the SQL Query object.
> 
> http://revolution.screenstepslive.com/s/revolution/m/sqlyoga_sampleapp/l/6637-defining-scopes-to-make-aggregating-search-filters-easier
> 
> -- 
> Trevor DeVore
> ScreenSteps
> www.screensteps.com
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode