When an event is activated, we would like to send a message to the relevant number. Phone numbers and datasource names are stored in sql table which is more than 10.000 rows. As we see that, in order to find relevant phone number, we need to create a sql datapoint for each phone number and we don't want to create 10.000 sql datapoints.
Can we change select statement or row idenfier of sql data point dynamically??
What is your suggestion?
What we plan to do is in attachement.