: 3499 | 87945 | 9828

XPages: @DBLookupBig & @DbColumnBig 
Now Available: "The Social Software Platform You Already Own" Position Paper from Elguji Software. A must read for every IBM Lotus Software customer.
Use this IdeaSpace to post ideas about Domino Designer.

: 27
: 28
: 1
: Domino Designer
: formula, xpages, @Dblookup, @DBcolumn
: Erik Brooks 11 Oct 2009
:
: / Email
XPages are here, they're big and bad and scalable. They integrate with @Formulas, which is extremely powerful. For things like repeat controls, type-ahead, etc. there are times when you use @DbLookup or @DbColumn.
 
But these functions are limited in returning 64K, like the days of old.
 
Two new @Formulas, @DbColumnBig and @DbLookupBig should be created to be able to return large amounts of data.
 
Presumably to incorporate this capability into the legacy design elements (<computed text>, fields, etc.) this would be a large amount of effort because of all the other 16/32/64K limits on those elements.  To ease the engineering effort on IBM's side the new @Formulas could be made available only within the context of XPages, similar to how @Unique has a completely different implementation on XPages than it does with legacy Domino design elements.
 

IdeaJam - Idea and Innovation Management Software for IBM Lotus Notes and Domino



1) Rob Goudvis (12 Oct 2009)
Why should there be a special @formula for this. Why not allow for more data to be returned in the existing @formulae? You could think of a new optional parameter that could limit your return size (like NotesDatabase.Search).
2) Oliver Regelmann (14 Oct 2009)
I agree with Rob. The original formulas should get enabled to return more data.
3) Erik Brooks (21 Oct 2009)
@1 & @2 - I thought I answered that? If you changed @DbColumn to return more data you'd potentially break all of the other design elements out there. At the very least they'd all be returning different error messages on large sets ("Formula is too large" instead of "@DbColumn returned more than 64K of data").

If they could rework the existing formulas, that'd be great. But what would likely be easier for IBM from an engineering and backwards-compatibility standpoint would be to add the new ones and surface those in the places (e.g. XPages) where they would work.

Or they could simply change @DbLookup / @DbColumn to "@V8DbLookup" and "@V8DbColumn" like they've done with other deprecated @Formulas.










:
:

Idea Management Software


You can run IdeaJam in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam works with:

  • Lotus Connections
  • Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam with other applications.

Learn more about IdeaJam >>

Welcome to IdeaJam


IdeaJam is a place where people can post and share their ideas, and gauge the marketability, popularity and viability with input from others.

When an idea gets posted, others can help promote or demote the idea and provide comments. Popular ideas will bubble to the top.

Make your opinion count.

Share


Post your idea - from ways we can improve IBM Lotus Software to things we've haven't even yet thought of.

Vote


Check out other people's ideas and vote on the ones you like best. The community votes. The community decides.


Discuss


Talk about ideas with your peers in the IBM Lotus Community and help make them even better.



0
Don't overwrite favicon.ico if it already exists
4
ideajam ideas - Lotusphere
23
All Design Elements view in Designer
-5
Make Ideajam database as default application on domino
15
Symphony API integration in Agents
6
In the view-quick-search dialog, there should an "advanced search" option to find a document in the current view based on the NoteID or UNID
11
Standardize Definition of Application
14
Cleanup process for mystery problems
4
DDM could benefit from addng Twitter or SMS to Notifications
17
license model for universities and schools (education)
-2
Launching Lotus Symphony in the 8.5.2 client hangs tightly
5
Dogear: Plugin for many browsers to store bookmark in dogear
8
Multi core control for licencing
9
Give Domino an up-to-date Servlet Engine
4
Place message on HOLD from the Mail.Box (Addition at end)
10
Notes Calendar - Show Calendars
2
Standalone Domino Designer Client
-2
Strange messages when using the Designer in the project, containing only the code LotusScript
12
Calendar overlay: documentation how to overlay application calendar
6
inbox: newest first
19
Get Rid of "Copy as Table" in instances where it doesn't work
7
Lotus Script: record call history for for informative debugging
18
Expose the SPR database to customers so others can easily get added to the request
-3
RunWithDocumentContext not work when run from LotusScript







IdeaJam developed by




Hosting by