VoiceGuide IVR Software Main Page
Jump to content

callque table

Recommended Posts

in the callque table 

The isrequestcomplete field is "f" by default. When you make the phone call, do you change it to "Y"   ? Do you update the updatedAT field with the date and time the call was made?

Share this post

Link to post

VoiceGuide Dialer does not use a field named "isrequestcomplete" in the callque table.

You can view the SQL files in "C:\Program Files (x86)\VoiceGuide\System\setup" to see what tables and fields VoiceGuide uses.

The "updatedAT" field looks like a field that PostgreSQL itself adds to tables, and PostgreSQL itself updates that field.

VoiceGuide keeps track of the outgoing call outcome in the "calltrack" table, and the "cdrin" and "cdrout" tables.

Share this post

Link to post

If we add three fields to the callque  table so we don't have to read the calltrack table.


isrequestedcomplete = change from (F)alse to (T)rue  when done 

UpdateAT                     = Time and date call was made

Results                          = the results of the call 


We will be send all information to callque table and we have a cronjob that will be looking in the  callque table all the isrequestedcomplete that have been changed to yes to move to another

table Do you think this can be done ?



Share this post

Link to post

You can add extra fields to any of the database tables that the VoiceGuide software uses internally. Adding extra fields will not affect VoiceGuide operation.

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now