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.

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

Date Picker in course search changes search criteria in undesireable way. #10

Open
sstaggs1 opened this issue Oct 6, 2021 · 0 comments

Comments

@sstaggs1
Copy link

sstaggs1 commented Oct 6, 2021

Today I was verifying some results against a database report.
In DDA my where clause is: WHERE course_id ilike '%20218-%' and I get 3500+ results

In the Course Data Source: Search by Course selected Course ID Contains 20218- Course created: Before 10/06/2021.
When I click go and the page refreshes, the date field reads 06/10/2021 and I only receive 224 results.

Within my DDA, if I add a check for dtcreated < '06/10/2021'

WHERE course_id ilike '%20218-%'
   AND dtcreated < '06/10/2021'

The results in the DDA are also 224.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant