How to remove UNUSED fields in the programer's pane

HCL Domino Domino Forum
1

I am working over an old database. Now, when I work on a view I can chose which value to show by fields. But in the programer’s pane are many fields which are not used anymore and just bothering because some are similar. How can I remove them from appearig there?

Thanks for any help

2

Subject: How to remove UNUSED fields in the programer’s pane

Hi Christian,

you mean the fields aren’t used anymore at all (not in any forms, other views…)?

If so, just go to the form the field is in, mark it und press DEL - the field will be deleted and thus no longer in the programmers pane of any view.

If the field is still used in any part of the database there’s no possibility of removing it from the p.-pane.

HTH,

Peter

3

Subject: RE: How to remove UNUSED fields in the programer’s pane

I just discovered that the fields have illegal field names. The contain spaces. This also could be the reason why they still appear.

4

Subject: RE: How to remove UNUSED fields in the programer’s pane

Yes the fields are not used anymore in any documents. The problem is that mayn of those fields are created by angents. I assume at the very beginning as this database was developed there were some errors in the agents and so some strange fiels were then created in.

I checked some of the fields with a view which shows the documents where the field value is not empty. But I did not find any documents.

From my understanding this means that no documents has a value for thsi field.

I also checked with a an agent for a document with this field. I also could not find this way a document. I also checked all forms for such a field. There is also no shared field.

I also figured out that the fields are stored in the UNK table of the database. Is there a way to rebuild this table?

5

Subject: SOLVED How to remove UNUSED fields in the programer’s pane

I found the way to remove those fields.

The trick with the form, creating the field and delete it again does not work for all fields. Especially not for those which have a illegal field name (space inside) and created with agents.

The way it worked for me was to compact the database. But I had to delete all documents, otherwise, it did not work.

Thanks for all help