Using Date Range to retrieve data from excel
Can some help me with the below scenario.
I have a responder which sends list of rows having the same account number which was sent in the request. However, I need to send the rows based on the start date and end date range.
currently I have setup only account number in data source co-relation to match the account number.
Is there a way that I could match the rows and retrieve them based on the date range ?
Comments
-
Can someone help on this ?
I am stuck with this task for my project.0 -
Assuming that the dates are in the request, you could use an XPath that checks the dates as described here: https://stackoverflow.com/questions/4347320/xpath-dates-comparison
0 -
How do i use this in Responder ?
For example , excel sheet contains a column "ID" , "PostedDate" and "AccountNumber" having multiple rows.
When I send a xml request to the responder using 12345678 ; 2018-01-01 and 2018-12-12 how does it return all the rows between the mentioned range ?I have attached the pva file , data sheet and sample request and expected response
Edited the zip file with latest pva
0 -
@jakubiak ; could you please verify the files attached and help me on this please ?
0 -
Responder data source correlation expects to match the incoming request to just a single row. In your case you want to act on a range of rows.
This is probably a case where professional services could help, please contact Parasoft Support at support@parasoft.com
0 -
Can Someone please help me on this ?
0 -
@bsaikrishna84, If you are already Parasoft Customer, please create a support ticket via https://www.parasoft.com/support
0 -
Sure Thank you
0
