I have two drop downs. One of the drop down list is dependent on the Selected item from from other drop down.
I need to verify data in the dependent list is correctly listed based on the selected value. (note:- Both lists are dynamic and gets updated every week)
Eg: IF I select Truck, dependent drop down should have all small parts of truck.
The data coming in the dependent list is not always updated in the application I am working on.
How do I test this using automation(Selenium webdriver and java)?
I was thinking of grabbing data from the SQL DB and storing it in a list and comparing displayed list and acquired list.
Is this approach good, as there are many dependent fields? Also the application has different filters, so need to always verify returned data is accurate.