Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Incorrect table names in search joins #29

Open
camdendotlol opened this issue Jun 22, 2023 · 0 comments
Open

Incorrect table names in search joins #29

camdendotlol opened this issue Jun 22, 2023 · 0 comments
Assignees
@dleadbetter

Comments

@camdendotlol
Copy link

When searching in NBU, the wrong table name seems to be injected into the SQL query at certain points. For example, POSTing a search to the Documents table throws this error:

2023-06-22T20:16:32.345523+00:00 app[web.1]: [b3aa046b-bdbc-4509-b864-62a81a6eec1d] ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR:  missing FROM-clause entry for table "people"
2023-06-22T20:16:32.345523+00:00 app[web.1]: LINE 1: ...OR documents.user_defined->>'Tags' ILIKE '%c%' OR people.use...
2023-06-22T20:16:32.345524+00:00 app[web.1]: ^
2023-06-22T20:16:32.345525+00:00 app[web.1]: ):
dleadbetter added a commit that referenced this issue Jun 22, 2023
@dleadbetter
UDF #29 - Updating queryable sort and search methods to scope the use…
7679a5f 
…r defined fields query to fields for the current table
dleadbetter added a commit that referenced this issue Jun 23, 2023
@dleadbetter
Merge pull request #30 from performant-software/feature/udf29_query_s…
18e14d2 
…cope

UDF #29 - Query scope
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dleadbetter dleadbetter

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dleadbetter @camdendotlol