I'm making software in JSF (2.2), primefaces and JPA with Postgres bank. I need to make a schedule of accounts payable with the following columns and their data: Column before yesterday with data: due date, vendor and value. Column yesterday with the data: expiration date, vendor and value. Column today with data: expiration date, vendor and value. Column tomorrow with data: due date, vendor, and value. Column after tomorrow with data: due date, vendor and value.
There are several different query data. My question is how to perform these queries on a single datatable. How do I know what list to call in the columns.
These are the doubts.