all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Blue
Created By: Brandon Moore
Created Date/Time: 6/12/2017 9:35 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 2793
Template/Type: Quick Note
Title/Caption: Virtual Post-It Note
Start Date: 6/12/2017
Main Status: Active
Sorry, no photos available for this element of time.

Notes:
We had an issue with a corp id being passed to the adilas API sockets that was padded with zeros... This caused an error. I am wondering if we should go through the API socket pages and add some code to help with id numbers and forcing them to an integer (trim off the leading zeros). This would help with database table names, searches, etc. Just an idea.

Here is an example where the leading zeros could be a problem:
a corp-specific table such as customer_queue_0828 vs. the real customer_queue_828 (the extra 0 causes a problem)

or an SLQ statement like: Where corp_id = 0828 vs. Where corp_id = 828.

All of this could be fixed with an Int() function wrapping the id numbers.