What is the best way to find out if a shipping address is being used for the first time to ship an order

[Former Member]

Hello Team,

Can anyone, let me what is the best way to find out if a shipping address is being used for the first time to ship an order?

Thank you :)

[arvind-kumar_avinash]

Please use the following FS Query and if the count is greater than zero, it means the delivery address has not been used earlier:

 SELECT count({pk}) FROM {Order} WHERE {deliveryaddress}='123456'

Note: please replace 12345 with your value.