Date input search with problem about spring-data-jpa-datatables HOT 5 CLOSED

I figure out how to make a date search, I'm using Postgres and the date type is stored like '2017-01-01 00:00:00', so what I made was to parse date to a date string that have the same format, but in JavaScript. Finally my JS function ended up like this:
$("#dataFilter").datepicker({ format : "dd/mm/yyyy", language : "pt-BR", todayHighlight : true }) .on("changeDate", function(e) { table.column(0).search(e.date.toISOString().substr(0, 10)).draw(); });

And Worked 👍

from spring-data-jpa-datatables.

To handle a date, you'll have to provide your own specification (since the library cannot know whether a field contains a date or not):

public DataTablesOutput<User> getUsers(@Valid DataTablesInput input) {
  ColumnParameter parameter0 = input.getColumns().get(0);
  LocalDate date = LocalDate.parse(parameter0.getSearch().getValue());
  Specification additionalSpecification = getSpecificationForDate(date);
  parameter0.getSearch().setValue("");
  return userRepository.findAll(input, additionalSpecification);
}

from spring-data-jpa-datatables.

Sorry to bring the old thread back. I am having a similar problem. Setting the date between returns empty table.

Here is the code

predicateDate = builder.between(root.<Date>get("orderDateTime"), d1, d2);

from spring-data-jpa-datatables.

Hi @darrachequesne , where is ColumnParameter class imported?

@JsonView(DataTablesOutput.View.class)
	@RequestMapping(value = "/data/users", method = RequestMethod.GET)
	public DataTablesOutput<User> getUsers(@Valid DataTablesInput input) {
		for (ColumnParameter parameter : input.getColumns()) {
			if (!parameter.getData().equalsIgnoreCase("likes"))
				continue;
			// create a specification based on the search value
			val additionalSpecification = getLikesSpecification(parameter
					.getSearch().getValue());
			// remove the search value
			parameter.getSearch().setValue("");
			return userRepository.findAll(input, additionalSpecification);
		}
		return userRepository.findAll(input);
	}

Thanks

from spring-data-jpa-datatables.

Hi @darrachequesne , where is ColumnParameter class imported?

@JsonView(DataTablesOutput.View.class)
	@RequestMapping(value = "/data/users", method = RequestMethod.GET)
	public DataTablesOutput<User> getUsers(@Valid DataTablesInput input) {
		for (ColumnParameter parameter : input.getColumns()) {
			if (!parameter.getData().equalsIgnoreCase("likes"))
				continue;
			// create a specification based on the search value
			val additionalSpecification = getLikesSpecification(parameter
					.getSearch().getValue());
			// remove the search value
			parameter.getSearch().setValue("");
			return userRepository.findAll(input, additionalSpecification);
		}
		return userRepository.findAll(input);
	}

Thanks

I think the class Column works.

Hi @darrachequesne, I have this same problem. A column in BD that is a Date that cant be search by the value of the input.

Im trying to work on the code for the Specification to solve this, but I cant.

Can you or anybody else write or explain the code inside the method getSpecificationForDate(date)?

Thanks.

from spring-data-jpa-datatables.