[Migrated from old forumParticipant April 10, 2015 at 3:05 pm Post count: 327]

#5788 |

Hi,

Can someone tell me how I would go about checking a CallerID (number) against a MySQL DB.

I have been playing around with this query but it doesn’t seem to work.
SELECT number_ollo FROM callerid WHERE deviceID=${UNIQUEID};

is ${UNIQUEID} the caller ID number and if so what type is it (int, varchar etc…)?

If its not, can someone tell me how to get the Caller ID number in Visual DialPlan.

Thanks in advance
Ken

[Migrated from old forumParticipant April 10, 2015 at 3:06 pm Post count: 327]

#5789 |

Loopyjoe7,

UniqueID is composed of the epoch when a call starts, plus a monotonically incremental integer.
Together, they will be unique for all calls originating from a single machine.

You need to use ${CALLERID(num)} function instead of ${UNIQUEID}.

Raman

[Migrated from old forumParticipant April 10, 2015 at 3:06 pm Post count: 327]

#5790 |

Thanks Raman 🙂

I managed to get it all working using ${CALLERID(num)} function.

Ken