I have added SLJobTrans to Resource Group Dispatch List Report DataView and need to only retrieve the first Trans Date from SLJobTrans , currently it shows all:
Maybe try an expression column and use the "MIN" function? Haven't tried this so not sure if it will work, just a thought.
This is how I have added a filter into a dataview. You can change this to the correct date column and use MIN as J has suggested:
Hey, here is a filter you can use for this:
NOT EXISTS(SELECT 1 FROM jobtran ijt WHERE ijt.job = Job AND ijt.suffix = Suffix AND (ijt.trans_date < TransDate OR(ijt.trans_date = TransDate AND ijt.trans_num < TransNum)))
With MIN on the date you can still retrieve multiple records due to transactions with the exact same date so I also included the transaction number..
I recommend you also change it to Single Level link type after this since you will only have one record anyways.
