0

How to find specific words in a field query [closed]

asked 2017-11-24 02:17:46 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello,

I have a table named John for my Bible Study Class. 6 Fields; Id, Testament, Book, Chapter, Verse, Passage.

I would like to be able to query the passage field so If I type in text like ’truth’ it will return the chapter, verse and passages that contain that word. My problem is that no matter what word I try under criterion for passages field, There are no records. Am I doing something wrong? I did query in design view and had the words I was looking for like 'truth' in single quotes next to criterion. No results. Everything else works for example if I put '28' under criterion for the verse field, It returns all verse 28 chapters and passages. Thanks for help if possible.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-23 19:57:14.843305

Comments

In the future, please do not check the Community Wiki box when asking questions. For more suggested guidelines, see https://ask.libreoffice.org/en/questi....

Jim K ( 2017-11-24 18:04:38 +0100 )edit

2 Answers

Sort by » oldest newest most voted

0

answered 2017-11-24 17:59:05 +0100

flag of United States of America

3811 ●7 ●26 ●53

updated 2017-11-24 18:14:34 +0100

Set Criterion to LIKE '*truth*'.

query design view

Using LIKE '%truth%' also works, and seems better to me because it is like the underlying SQL. However, the query design form turns % into *.

Instead of modifying the query each time, use this Criterion to ask for the keyword to search.

LIKE LOWER ( '%' || :keyword || '%' )

Then enter truth in the Parameter Input box that appears.

edit flag offensive delete link

Comments

Thank you for the advice. I did everything exactly like the screenshot. It worked. I did not try the parameter input box yet. Thanks again.

leoirias@hotmail.com ( 2017-11-25 02:46:54 +0100 )edit

0

answered 2017-11-24 03:13:57 +0100

Ratslinger
25570 ●9 ●35 ●134

Hello,

I believe your question is in regards to use the form filter. If so, start by selecting Filter Navigation icon giving you this screen:

image description

Then in the field you want to search, enter what you are looking for and press Enter:

image description

Then simply select the Apply Form-Based Filter icon for results:

image description

All records containing that information in that field will be selected. This is case sensitive unless your table field is set as VARCHAR_IGNORECASE:

image description

Additionally, there are many ways to use an SQL query to return results. Here is just one:

image description

The selection is done using a parameter for selection entry and ignores case (table setting doesn't matter for this).

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link

Question Tools

1 follower

Stats

Asked: 2017-11-24 02:17:46 +0100

Seen: 1,271 times

Last updated: Nov 24 '17

Related questions

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Powered by Askbot version 0.9.3