Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

> What would I need to write as a criteria so that when the QUERY is run, it
prompts the user to select from a listbox

You must create a form to use the List Box control.  If you really only
need a query you can add the choices to the query parameter name.  For
example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
:enter_dog_cat_or_bird (see simple attached example).

From the installed help see: Contents > Database Functionality > General
Information > Working with Queries (Query Design / Parameter queries) and
Working with Forms (Form Controls / List Box).


On Sat, Aug 27, 2016 at 3:14 PM, alanon <alanon.sr3@gmail.com> wrote:

> Hi,
> Thank you in advance for your help!
> I'm trying to build a query that would list the records in a database where
> the user selects from an existing list of categories.
>
> IE
> there are 12 existing categories, each with a bunch of records.
> the user wants to review just the records under the category "gas", but he
> doesn't know that exact category name so he needs a listbox to show his
> existing categories to select from.
>
> What would I need to write as a criteria so that when the query is run, it
> prompts the user to select from a listbox so he can review the records for
> that said category?
>
> Thank you.
> Alanon
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/
> libreoffice-base-building-query-need-help-with-input-
> parameter-development-tp4191909.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted