Hibernate - filter full text search for supplied date between start and end date in database
up vote
0
down vote
favorite
I have a database with a list of medical diagnosis codes that have a codeId, description, startDate and endDate in the database. I need to do a full text search on words in the diagnosis description and filter the returned list for the diagnosis that applies on the doctor's examination date (startDate <= examDate <= endDate).
I have been unable to find a way of doing this. A range filter can be added to a full text query, but that only is useful if you have a single date in the database and you supply an upper and lower limit in the code. (For example, this would work if I had the examDate in the database and wanted to find if examDate was between two dates - that is not my use case).
I have found filter and non-filter solutions that look at dates but do not fit my use case (e.g., How to search between dates (Hibernate Search)?). How can I accomplish what I need to do?
hibernate date filter full-text-search multiple-columns
asked Nov 8 at 18:10
Bruce_DDD
45110
add a comment |
up vote
0
down vote
favorite
I have a database with a list of medical diagnosis codes that have a codeId, description, startDate and endDate in the database. I need to do a full text search on words in the diagnosis description and filter the returned list for the diagnosis that applies on the doctor's examination date (startDate <= examDate <= endDate).
I have been unable to find a way of doing this. A range filter can be added to a full text query, but that only is useful if you have a single date in the database and you supply an upper and lower limit in the code. (For example, this would work if I had the examDate in the database and wanted to find if examDate was between two dates - that is not my use case).
I have found filter and non-filter solutions that look at dates but do not fit my use case (e.g., How to search between dates (Hibernate Search)?). How can I accomplish what I need to do?
hibernate date filter full-text-search multiple-columns
asked Nov 8 at 18:10
Bruce_DDD
45110
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a database with a list of medical diagnosis codes that have a codeId, description, startDate and endDate in the database. I need to do a full text search on words in the diagnosis description and filter the returned list for the diagnosis that applies on the doctor's examination date (startDate <= examDate <= endDate).
I have been unable to find a way of doing this. A range filter can be added to a full text query, but that only is useful if you have a single date in the database and you supply an upper and lower limit in the code. (For example, this would work if I had the examDate in the database and wanted to find if examDate was between two dates - that is not my use case).
I have found filter and non-filter solutions that look at dates but do not fit my use case (e.g., How to search between dates (Hibernate Search)?). How can I accomplish what I need to do?
hibernate date filter full-text-search multiple-columns
asked Nov 8 at 18:10
Bruce_DDD
45110
I have a database with a list of medical diagnosis codes that have a codeId, description, startDate and endDate in the database. I need to do a full text search on words in the diagnosis description and filter the returned list for the diagnosis that applies on the doctor's examination date (startDate <= examDate <= endDate).
I have been unable to find a way of doing this. A range filter can be added to a full text query, but that only is useful if you have a single date in the database and you supply an upper and lower limit in the code. (For example, this would work if I had the examDate in the database and wanted to find if examDate was between two dates - that is not my use case).
I have found filter and non-filter solutions that look at dates but do not fit my use case (e.g., How to search between dates (Hibernate Search)?). How can I accomplish what I need to do?
hibernate date filter full-text-search multiple-columns
hibernate date filter full-text-search multiple-columns
asked Nov 8 at 18:10
Bruce_DDD
45110
asked Nov 8 at 18:10
Bruce_DDD
45110
asked Nov 8 at 18:10
Bruce_DDD
45110
asked Nov 8 at 18:10
Bruce_DDD
45110
asked Nov 8 at 18:10
Bruce_DDD
45110
45110
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53213738%2fhibernate-filter-full-text-search-for-supplied-date-between-start-and-end-date%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
