Manage Learn to apply best practices and optimize your operations.

32k limit workaround and using in field options

This technique allows you to make dynamical checkboxes for both Web and Notes.

This technique allows you to make dynamical checkboxes for both Web and Notes. As a feature it can be used as workaround for 32k limit. BTW, R6 won't have a limit for @dblookup/@dbcolumn.
First variant:
Dynamical checkbox field:

1. Field "dspAnames" Checkbox/Editable formula for field options: @DbColumn("":"NOCACHE";"";"pick_role";1)+"|"+@DbColumn("":"NOCACHE";"";"pick_role";2)

2. Field "Anames" Text/Multivalued/Computed/Hidden formula for field: aNames

3. View pick_role
The first column is sorted. Contains options. Their names. The second should contains aliases for options.

The screenshot below (in Russian) is example as $readers/$authors type fields may be arranged. Sure, all the roles are stored as documents and synchronization between them and ACL were realized. 

The other way of using this technique is getting more than 32k.

1. Some documents with field "Some"

2. View has some columns contain formulas breaking apart long string stored "Some".

 Then we can make smth. Like this: list1:=@dbcolumn(...1); list2:=@dbcolumn(...2); ... listN:=@dbcolumn(...N); result:=list1+list2+...+listN

The problem is only equal number of elements. Hmm... why don't we check if view column value is empty? This problem solution is replacing empty value by wowel.

Dig Deeper on Domino Resources - Part 2

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...