I'm now working on a project of IBM lotus notes plugin, using C#.
Here's request that we want to get the data from view by view column's name, such as "Date".
I found that I can use the method "GetColumn" in "NotesView" class to get the info of column name and other basic info, but the real data are not included in it. To get the data , I need to use the attributes "ColumnValues" in "ViewEntry" class or "Document" class.
Unfortunately, regarding the technical documents provided by IBM, there are several cases that not all the column values will be return.
https://www.ibm.com/support/knowledgecenter/en/SSVRGU_9.0.0/com.ibm.designer.domino.main.doc/H_COLUMNVALUES_PROPERTY_JAVA.html
For example , the result of GetColumn is 16 columns, and the 12th column's name is "Date", it's datetime type. But in the ColumnValues, there's only 13 columns, no column names, and the 8th columns type is datetime which seems to be the "Date" column.
I've tried to figure out which kinds of the columns will be omitted. Firstly, I tried to catch the "UI-only function" in formula, but it seems not enough. Secondly, I tried to catch "constant", but don't how. Finally I found that not all the "constant" formula columns are deleted. I abandoned.
Is there anyone who can help me to indicate the view column number in columnvalues ?
What I have tried:
I have tried to get the attributes "ColumnValues" in both "ViewEntry" class and "Document" class, the result are the same , some columns omitted, no column name, and I cannot figure out why