public void selectable10() { // tag::selectable10[] Datastore datastore = obtainDatastore(); final PathProperty<Long> ID = PathProperty.create("id", Long.class); final PathProperty<String> DESCRIPTION = PathProperty.create("description", String.class); SingleSelect<Long> singleSelect = Components.input.singleSelect(ID) .dataSource(datastore, DataTarget.named("testData"), PropertySet.of(ID, DESCRIPTION), // Datastore () -> ID.gt(0L)) // <1> .itemCaptionGenerator(propertyBox -> propertyBox.getValue(DESCRIPTION)).build(); // end::selectable10[] }
public void selectable10() { // tag::selectable10[] Datastore datastore = obtainDatastore(); final PathProperty<Long> ID = PathProperty.create("id", Long.class); final PathProperty<String> DESCRIPTION = PathProperty.create("description", String.class); SingleSelect<Long> singleSelect = Components.input.singleSelect(ID) .dataSource(datastore, DataTarget.named("testData"), PropertySet.of(ID, DESCRIPTION)) // .withQueryConfigurationProvider(() -> ID.gt(0L)) // <1> .itemCaptionGenerator(propertyBox -> propertyBox.getValue(DESCRIPTION)).build(); // end::selectable10[] }
public void queryDefinition() { // tag::querydefinition[] final PathProperty<Integer> PROPERTY = PathProperty.create("test", Integer.class); Datastore datastore = getDatastore(); // build or obtain a Datastore Query query = datastore.query() // <1> .target(DataTarget.named("testTarget")) // <2> .filter(PROPERTY.gt(10)) // <3> .sort(PROPERTY.asc()) // <4> .aggregate(PROPERTY) // <5> .limit(100) // <6> .offset(200); // <7> query = datastore.query(DataTarget.named("testTarget")) // <8> .aggregate(QueryAggregation.builder().path(PROPERTY).filter(PROPERTY.gt(10)).build()) // <9> .restrict(100, 200); // <10> // end::querydefinition[] }
void operations() { Datastore datastore = getJpaDatastore(); PropertyBox value = PropertyBox.builder(Test.PROPERTIES).set(Test.PROPERTIES.property("id"), 1L) .set(Test.PROPERTIES.property("value"), "test").build(); // <3> datastore.save(Test.TARGET, value); List<PropertyBox> values = datastore.query(Test.TARGET).filter(Test.PROPERTIES.property("id").gt(0L)) .sort(Test.PROPERTIES.property("value").desc()).list(Test.PROPERTIES); // <4> } // end::beans1[]
public void listing9() { // tag::listing9[] PropertyListing listing = Components.listing.properties(PROPERTIES) // .sortable(ID, true) // <1> .sortUsing(ID, DESCRIPTION) // <2> .sortGenerator(ID, (property, ascending) -> { // <3> return ascending ? ID.asc() : ID.desc(); }) // .fixedSort(ID.asc()) // <4> .defaultSort(DESCRIPTION.asc()) // <5> .fixedFilter(ID.gt(0L)) // <6> .withQueryConfigurationProvider(() -> DESCRIPTION.isNotNull()) // <7> .build(); // end::listing9[] }
restriction = PROPERTY1.lt(7); // less than restriction = PROPERTY1.loe(7); // less than or equal restriction = PROPERTY1.gt(7); // greater than restriction = PROPERTY1.goe(7); // greater than or equal restriction = PROPERTY1.between(1, 7); // between