Custom SQL Queries within Logos

Page 1 of 1 (12 items)
This post has 11 Replies | 1 Follower

Posts 13
Tom Garcia | Forum Activity | Posted: Tue, Sep 3 2019 3:38 PM

Is there a way to perform custom SQL queries within Logos to pull data in a custom layout?  I've heard that there are certain search strings that are native to logos, but haven't been able to find what they are.  The basic keyword search is not always the best option as it takes too long or returns to many results.

For example, in a normal database,  if I wanted to see how often a name or word is used in a text, I can do something like this:

SELECT
    SUB_COUNT('my word', `my_column`) AS `match_count`
FROM `table`
Posts 2419
David Ames | Forum Activity | Replied: Tue, Sep 3 2019 4:09 PM

first question: Are the files stored in plan text or are they encrypted?

Posts 10109
Forum MVP
NB.Mick | Forum Activity | Replied: Tue, Sep 3 2019 11:29 PM

Tom Garcia:
Is there a way to perform custom SQL queries within Logos to pull data in a custom layout? 

No. Logos gives a very sophisticated search engine with capabilities far beyond simple SQL queries, specifically geared towards the bible text (and its dataset annotations) that most often is queried - allowing for original language morphology, syntax searches etc. 

Searching for text will be performed on a proprietary index rather than on raw data, but will allow for matching grammatical word forms and even a "fuzzy search". 

Running Logos 8 latest beta version on Win 10

Posts 10109
Forum MVP
NB.Mick | Forum Activity | Replied: Tue, Sep 3 2019 11:35 PM

David Ames:

first question: Are the files stored in plan text or are they encrypted?

While the files are stored in SQLite databases (thus on the metadata level there is a possibility for using SQL, such as for querying the library - this is not recommended and in nearly all use cases not needed at all), the book content is encrypted and thus can't be queried by SQL statements

Running Logos 8 latest beta version on Win 10

Posts 17990
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Wed, Sep 4 2019 7:33 AM

Tom Garcia:
The basic keyword search is not always the best option as it takes too long or returns to many results.

Please provide an example or two to allow other users an opportunity to replicate. Also helpful would be an idea about what trying to find. Logos and Verbum have a number of search options.

Logos Logos Bible Software Wiki includes: Search HELP LT Search + VT Search with ways to refine search.

Keep Smiling Smile

Posts 13
Tom Garcia | Forum Activity | Replied: Wed, Sep 4 2019 9:39 AM

Thanks for the info.  So more specifically, I attached an example of what I see when I search  for Biblical People in the passage guide. It gives the first three examples which appear to be the top hits, but I don't think this is the case.  The huge list below the graphics sometimes has more occurences of the person than the top results. 

For example, I want to see the the number of occurences of "people" in a particular book with the number of times they are referenced.  In Exodus, I'd like to see how many times Moses is mentioned or if i don't know who the top characters are in a book, then I'd like to list out all of the people and see who they are.

Posts 13368
Forum MVP
Mark Barnes | Forum Activity | Replied: Wed, Sep 4 2019 10:18 AM

Tom Garcia:
For example, I want to see the the number of occurences of "people" in a particular book with the number of times they are referenced.

You should use the Concordance tool for this. I'm not able to post more detailed instructions now, but ask if it's not clear. See this post: https://community.logos.com/forums/p/79673/1063893.aspx#1063893 

Posts 13
Tom Garcia | Forum Activity | Replied: Wed, Sep 4 2019 12:11 PM

Thanks Mark. Good Ol' Logos/Faithlife wants me to upgrade to get that tool.

Posts 13368
Forum MVP
Mark Barnes | Forum Activity | Replied: Wed, Sep 4 2019 1:18 PM

Tom Garcia:

Thanks Mark. Good Ol' Logos/Faithlife wants me to upgrade to get that tool.

It's a useful tool. Here's a screenshot for Exodus for you:

It counts explicit naming ("Moses said") and implicit naming ("he said").

The order is not identical to the Biblical People section (which has: Israelites, Moses, Pharaoh, Aaron, God, Egyptians, etc.). I'm not able to explain why.

Posts 17990
Forum MVP
Keep Smiling 4 Jesus :) | Forum Activity | Replied: Wed, Sep 4 2019 2:56 PM

Tom Garcia:
For example, I want to see the the number of occurences of "people" in a particular book with the number of times they are referenced. 

Appears Passage Guide for Biblical People in Luke (Jesus, Disciples, A Man) has different order of Top Three when compared to Concordance Count (Jesus, A Man, Disciples):

Keep Smiling Smile

Posts 13
Tom Garcia | Forum Activity | Replied: Wed, Sep 4 2019 3:08 PM

Thanks, again Mark. I think I'm going to ask one of the pastors if they have the concordance tool on their account. It does look really helpful for the particular research I'm looking to do.

Posts 13
Tom Garcia | Forum Activity | Replied: Wed, Sep 4 2019 3:09 PM

Yeah, the i was noticing some inconsistnencies with the biblical people search which lead me down this path.  thanks for the help.

Page 1 of 1 (12 items) | RSS