Hi, Here is my use case. I have one set which has Large List that contains reference of guid (PK) of other set.
Set 1: Customer: id(PK) | cities (large list containing guid of city) Set 2: City: guid(PK) | name
I want to achieve the below use case using lua script.
- For specific city it should scan the large list of customer table.
- If no customer have reference of city in large list then delete customer.