Welcome, Guest. Please login or register.
March 18, 2018, 03:55:43 PM
Home Help Search Calendar Login Register
News: Please don't register for an account on this forum with a FREE email address (Yahoo, Gmail, Hotmail...etc) or you will not get approved.  Use your domain name email address instead.  Spammers use these free email accounts to post spam on our forum.

+  Collections MAX - Debt Collection Software Forum
|-+  General Information
| |-+  Support
| | |-+  composition assistance
« previous next »
Pages: [1] Print
Author Topic: composition assistance  (Read 1548 times)
Posts: 38

View Profile
« on: July 26, 2016, 07:25:39 AM »

I am having a challenge in composing a ? in MySQL

I seek to create a list of file numbers where the status= active and there is NO call back

then with that list update the call back table with a call back date, time and comment so collectors can resuscitate these orphaned accounts

the joins are not working for me thanks for any assistance
Hero Member
Posts: 900

View Profile
« Reply #1 on: July 26, 2016, 07:40:39 AM »

Unfortunately this is more of a developer question instead of a user question.  Also callbacks aren't really supposed to be used that way in the system.  When you overload the callbacks you will confuse your collectors.  Woudln't the inventory viewer work better without massively over populating the callbacks table?

Then you wouldn't want all your callbacks to be the same time. 

What I would do instead is update dbase.starttime to whatever date you want.  This way you automatically put the accounts in the virtual work date which is controlled by the icons under the zip code.

Otherwise you will have thousands and thousands of accounts clogging up the callback system.
Pages: [1] Print 
« previous next »
Jump to:  

Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!