Lookup rich text fields in any database

For reporting reasons I need to have an agent that scanns all databases on a server and reports in which databases a rich text field is used.

I've got the code to scan the databases and walk through all forms in a database, but I can't seem to extract the rich text fields from the form note.

Using the API function NSFNoteInfo for a rich text field the data type is always returned as TYPE_INVALID_OR_UNKOWN (=0), where it should be TYPE_COMPOSITE.

Does anybody know of a way how I can walk through all forms in a database and check if there is a rich text field on it? Using LotusScript or C API or any other method?
Jean Marie GeeraertsApplication EngineerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

moduloConnect With a Mentor Commented:
PAQed with points refunded (500)

Community Support Moderator
API functions are sensitive on data type that you pass.. for instance check this one..


Also make sure the length of the item is correct.

Jean Marie GeeraertsApplication EngineerAuthor Commented:
Yes, I know. Wrong declaration and you could get a "red box of death" :-)
Will look into it and keep you posted.
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Jean Marie GeeraertsApplication EngineerAuthor Commented:
Apparently this bit of info doesn't get us any further.
The problem is we have a reference to the form design element and when we use above function to retrieve info from an item, we don't get the correct value for the item type from the API function.

Do you have any idea as to why this wouldn't be working as it should?
On a regular data document, when you get the properties this way it returns the correct type.
Thing is, since a form's definition can change without changing the underlying data (documents already created with the form), you are goingto have to be careful with scope: do you want to check for current design using RTF, or for current data, or both.

To check for current data, you would haveto scan every doc in the database.  Checking forms is trickier, as you found, for a very simple reason: the way Notes stores a form's design.  A form is itself a note (document).  It has the following fields:

1) $Body - a rich text field that contains the form's content, including text, style, hootspots, images, etc. -- and a PLACEHOLDER for each field without any defintion for that field

2) $* -- a bunch of other fields whose names start with $ that control how the form is used (e.g., flag for store form in document), along with a few others (e.g., $UpdatedBy, which has no real function except to record the last person to edit the form)

3) A field for every field definition on the form.  These fields have the same name as the form's fields, contain the description of the fields (data type, formula, etc.), and have a special flag PLACEHOLDER.  The data type for these fields is not really relevant -- I think numbers and dates placeholders are actually stored as numbers and dates, everything else is a special type (though it should not be unknown... see what actual numeric value is returned, and match that against teh constants.  I don't think it matches teh standard unknown, though the specific number may not be defined)


A better way to do this might be to use the R6 client, with DXL, to get the form defintion, use teh DXL transform interpreters to go down to just teh field defintion level, and pull the data type flags.
Jean Marie GeeraertsApplication EngineerAuthor Commented:
Well, we don't have R6 available yet, so we'll have to do with R5 for the time being.

We did get as far as to the design note of the form and found the fields describing the fields on the note, but now want to read from these fields or in another way if any rich text fields are specified in the current design. (in current data is not important for our report)
Why don't you use a view (described in previous question using $FormulaClass) to list all the design elements.. And treat them as document and read it !
Jean Marie GeeraertsApplication EngineerAuthor Commented:
I don't expect it to make a difference, since we now open the document by it's unid through api call NSFNoteOpen and then get the item info through NSFItemInfo.
ZvonkoSystems architectCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer
Jean Marie GeeraertsApplication EngineerAuthor Commented:
Hm, didn't get a chance to react, because I was at home sick all week, but don't mind the question being closed since we are no longer looking into it anyway.
Would have been nice to have had an answer, though :(
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.