01-14-2014 12:55 AM
some of the Todo list fields are empty, records are not being populated. is there a way by which I can link todo table with incidents or problems to fill such fields. actually I have searched for that and found that there is no link done at the first place to make the existing working fields work as they are.
so why some fields are working and some are not? and how to fix that?
thanks a lot
Solved! Go to Solution.
01-14-2014 12:58 AM
There is a table TodoMap which saves all mappig of the fields from specific tables to the Todo table.
Search for the records in that table and fix or add required mapping.
01-14-2014 01:09 AM
01-14-2014 02:19 AM
Please post the existant records from the TodoMap table for the objects which are not working properly.
Use database manager for that as it was written in the previous post. For accessing database manager type db in the SM command line. In the opened window search for the TodoMap table and then check the existant records in it.
01-14-2014 02:40 AM
You have to check if the right named fields are mapped from your tables (probsummary,incidents ...) to the correct fields in the Todo table (actrually the fields which are set in the columns on the Todo form).
You just have to check for mistypes and probable modifications which could have changed the fields in which the data is stored.
01-14-2014 02:41 AM
01-14-2014 02:51 AM
Just to make sure that we are talking about the same problem can you clarify the quotes below:
Records are populated in Todo list without a problem.
For some records some data is missing (like for some records columns in the Todo are empty but for some the same columns are filled out).
Data in some columns is missing based on objects (for example column 3 is empty for all Interactions, but for Incidents is filled out).
01-14-2014 03:08 AM
OK, now open some test incident.
Go to RAD Debagger and:
d contact.cisco.no in $L.file
if Value is NULL
x contact.cisco.no in $L.file="111"
And save incident, now u can see this number(111) in Todo?
01-14-2014 03:11 AM
01-14-2014 03:16 AM
You would not get that fields filled out for the old records unless you run mass update or something like that. Or a short script which will go trough all that records and populate that fields to the Todo table.
If you have added your fields to mapping later, the old records in the Todo are not updated automatically.