Java 8 : Lambda expression with where condition

Question

Let's say I have below records in a table in DB.

Here Emplid and date combination is my PK. With every change I maintain version of records. (in last 3 rows there are total 3 version as change in number).

Now I want to fetch record where emplid = 1111 date = 28-02-2019 with latest version (user don't know how many version are there in db).

How can I do it with lambda expression.

HrcKey matchedKey = hrcKeyList.stream()
             .filter(x -> (currEmplid.equals(x.getEmplid()) && 
                     format.format(updateListFromUI.getDate())
                                  .equals(format.format(x.getDate()))))
             .findFirst()
             .orElse(null);

this will give me vesrion 1. but how can I get latest version.

Does this answer your question? How to use a Java8 lambda to sort a stream in reverse order? — Rob Audenaerde
– Rob Audenaerde, Commented Jun 16, 2020 at 12:14
No., actually for sorting by version I need version field which is not present in HrcRestatementKey (given by user). — Payal
– Payal, Commented Jun 16, 2020 at 12:38
If the source of your data is the database, why don't you utilize SQL and write a query that returns the data you require? SQL is very good at that. Or is this purely an exercise in using Java's stream API? — Abra
– Abra, Commented Jun 16, 2020 at 13:30
What is the type of your date fields? Why don't you use equals on them instead of comparing the formatted strings? — ETO
– ETO, Commented Jun 16, 2020 at 14:41

Hadi · Accepted Answer · 2020-06-16 12:32:36Z

1

You can use max to get latest object by comparing version value.

hrcRestatementKeyList.stream()
            .filter(x -> (currEmplid.equals(x.getEmplid()) &&
                    format.format(updatedHrcDbpRestatement.getExtr_effdt())
                            .equals(format.format(x.getExtr_effdt()))))
            .max(Comparator.comparingInt(HrcRestatementKey::getVersion))
            .orElse(null);

answered Jun 16, 2020 at 12:32

Hadi

17.3k4 gold badges41 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ameet chaubal · Accepted Answer · 2020-06-16 12:37:23Z

0

in short you can do something like this,

employees.stream().
                filter(hrc -> hrc.empid == 11 && hrc.date.equals("28-02-2000")).
                min((o1, o2) -> o2.version - o1.version).orElse(null);

full example,

public static void main(String[] args) {
        RnD rnD = new RnD();
        rnD.test();
    }
    private void test() {
        List<Hrc> employees = new ArrayList<>();
        employees.add(new Hrc(11, "28-02-2000", 1));
        employees.add(new Hrc(11, "28-02-2000", 2));
        employees.add(new Hrc(11, "28-02-2000", 3));
        employees.add(new Hrc(11, "30-02-2000", 1));
        employees.add(new Hrc(22, "11-02-2000", 1));
        Hrc topVersion= employees.stream().
                filter(hrc -> hrc.empid == 11 && hrc.date.equals("28-02-2000")).
                min((o1, o2) -> o2.version - o1.version).orElse(null);
        System.out.println(topVersion);
    }
    private static class Hrc {
        int empid;
        String date;
        int version;

        public Hrc(int empid, String date, int version) {
            this.empid = empid;
            this.date = date;
            this.version = version;
        }

        @Override
        public String toString() {
            return "Hrc{" +
                    "empid=" + empid +
                    ", date='" + date + '\'' +
                    ", version=" + version +
                    '}';
        }
    }

answered Jun 16, 2020 at 12:37

ameet chaubal

1,56017 silver badges38 bronze badges

1 Comment

Naman Over a year ago

Do not rely on (o1, o2) -> o2.version - o1.version to compare! See HadiJ's answer for a better and correct offering.

ETO · Accepted Answer · 2020-06-16 14:47:58Z

0

I'd go with this code snippet:

yourList.stream()
        .filter(x -> currEmplid.equals(x.getEmplid())
        .filter(x -> updatedHrcDbpRestatement.getExtr_effdt()
                                             .equals(x.getExtr_effdt())
        .max(comparingInt(HrcRestatementKey::getVersion))
        .orElse(null);

answered Jun 16, 2020 at 14:47

ETO

7,3471 gold badge23 silver badges40 bronze badges

Collectives™ on Stack Overflow

Java 8 : Lambda expression with where condition

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related