Notes and its fields in sql
Posted: March 24th, 2020, 12:36 pm
Using the dataviewer to look at a questionnaire I noticed that, at the end, it shows the notes fields, as the interviewers filled them. That´s very good!
I can see also that the fields having notes are marked in yellow and if you move the cursor over it you can see the notes´contents, which is also very good.
I have some questiona about the last two columns in the Notes table:
1. Operator ID. Where does it comes from? That is, how is it filled with? Is it possible to assign a value to that? One of the variables in my dictionary´s application holds the operator´s CPF (similar to your Social Security Number). Can I copy it to the operator ID?
2. Date/Time. I see the Notes table in SQL that it has a modified_time field. Is it the one storing the date AND the time? In what base?
One example is that the contents is 1581871493 (in SQL) and it "translates" to 2/16/2020 1:44:53 PM in the dataviewer. Is that correct, or this field has only the time and the date comes from another field?
By the way, I can click in any field from the "regular" records, the field is highlighted and I can copy (Ctrl_C) it. But clicking in the notes it highlights the whole line, I cannot copy it, and I do not know why, the dataviewer is crashing.
If you want to have look at it I´m attaching the csdb, look at 3109006999999970396. It is only a test example.
Best
I can see also that the fields having notes are marked in yellow and if you move the cursor over it you can see the notes´contents, which is also very good.
I have some questiona about the last two columns in the Notes table:
1. Operator ID. Where does it comes from? That is, how is it filled with? Is it possible to assign a value to that? One of the variables in my dictionary´s application holds the operator´s CPF (similar to your Social Security Number). Can I copy it to the operator ID?
2. Date/Time. I see the Notes table in SQL that it has a modified_time field. Is it the one storing the date AND the time? In what base?
One example is that the contents is 1581871493 (in SQL) and it "translates" to 2/16/2020 1:44:53 PM in the dataviewer. Is that correct, or this field has only the time and the date comes from another field?
By the way, I can click in any field from the "regular" records, the field is highlighted and I can copy (Ctrl_C) it. But clicking in the notes it highlights the whole line, I cannot copy it, and I do not know why, the dataviewer is crashing.
If you want to have look at it I´m attaching the csdb, look at 3109006999999970396. It is only a test example.
Best