Hi Team,
We have a requirement to create a List Report based on some filters which are not part of the entity.
Filter required Store, CardNumber, TransDate, Usage
Store, CardNumber and Transdate (from and to) are part of the Entity but Usage is NOT.
User wants to pass a value , say 10 in Usage Filter parameter, with other filter parameters and get a listing that satisfies the request. e.g want to see listing of all transactions for a Cardnumber with a transaction range and used => 10 times ..
We need this a a List Report (FE) so we can have the out of the box functionality e.g export, sorting etc.
What is the best way to achieve this?
Appreciate any feedback, comments, suggestions
Thanks
D
entity Transactions : managed, cuid {
CardNumber : String(32) not null @mandatory;
transactionDate : Date not null @mandatory;
store : String(8) not null @mandatory;
.......
}