slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: ticket history

brian mcdonald
Posts: 1

ticket history Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Nov 09 10:48 AM

We have a dispute about a certain ticket that was created and im trying to figure out who created the ticket and if it was ever edited or changed? im pretty new to saleslogix and wondering if this is possible.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: ticket history Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Nov 09 2:29 PM

SalesLogix tables have 2 fields to help track how created and/or last modified certain records:

CREATEUSER and MODIFYUSER

When a record is first created, both fields are set to the same UserID (same as CreateDAte and ModifyDate, they would be identical).
As users work with the data, the CREATEUSER and CREATEDATE are not touched, and only the MODIFYUSER and MODIFYDATE fields are updated.

Now, this is only true for data created within the App. If you have Integration points, it will depend on how the data was created. If the code places a value under the Create User, that value will be applied.
Also, it is possible to modify these 2 fields via the backend, so if users have access/knowledge they could do so (or again an integration point not properly written could as well overwrite these fields).

Also, keep in mind that CREATEDATE and MODIFYDATE will be stored as Universal Time (UTC).

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 7:41:40 AM