Column to store 100 Phone Numbers

Question

Hi Experts, 
 
 I have a requirement where I need to store 100 phone numbers in a given field, i.e Targets for now. And then to filter the data on all the columns considering if user searches with 555 then 2nd record should be returned 
 Currently I was using a single table with structure as shown below

TargetID (num) 
 OrderID (num) 
 Targets(varchar)

1 
 1 
 +91-9999999999 +91- 9999999999 +91- 8888888888

2 
 1 
 +91-9999999999 +91-9999999999 +91-8888888888 +91- 5555555555

Now, due to some performance issues, we need to get that targets column to be moved to a separate table and store all the phone numbers as a separate row, as shown in below tables

TargetID 
 OrderID

1 
 1

2 
 1

id 
 TargetID 
 Targets

1 
 1 
 +91-9999999999

2 
 1 
 +91- 9999999999

3 
 1 
 +91-8888888888

4 
 2 
 +91-9999999999

5 
 2 
 +91-9999999999

6 
 2 
 +91-8888888888

7 
 2 
 +91-5555555555

Kindly suggest as how this can be implement, do we need to use nested CDT or if there is any other way possible. 
 
 Thanks, 
 Gaurav Singh

Naresh · Accepted Answer

Hi, 
 I see an issue with your nesting configuration. The DB column is not matching the name that you provided in nested configuration. 
 Try with this configuration

hopefully this will work for you

Abhay Dalsaniya · Answer

If there is no further use case other than just ability to search. You may save multiple phone numbers separated by ";" in single text field in DB and retrieve them and split them using the split(). Use contains operator to search the desired substring. 
 filter: a!queryFilter( field: "phone", operator: "includes", value: ri!value )

Mike Schmitt · Answer

GauravSingh said: I mean the record will not be updated immediately until the Record get synced. And we cant sync the record every time we run the process. 
 As Peter already pointed out, but just to reiterate very specifically, this is not true.

Column to store 100 Phone Numbers

Top Replies