"MaxEntries" parameter for @DBLookup 
Use this IdeaSpace to post ideas about Domino Designer.

: 19
: 21
: 2
: Domino Designer
: @dbcolumn, @dbcolumn
: Mark Demicoli10736 27 Jun 2011
: / Email
 A parameter MaxEntries would be the maximum number of entries to return if @DBLookup hits multiple entries.
For example, I want to return the Last 5 entries in a discussion for web display, but don't want to use an embedded view (because I'm using pure HTML with <computed values> on a really fast web page), and I don't want to use x-pages because I can't achieve the same performance as I can this way, before you give me the political line about 'should be using x-pages' :)

1) Dave Navarre402 (27 Jun 2011)
I think it's a good idea, though I wonder about how it would pick the entries to display. Should it always be the last modified X number of entries? Or last X created? Or first/last X items by view sort order?

I think you could build the contents using XML ReadViewEntries (via AJAX, for example) and avoid using @DBLookup at all.
2) Mark Demicoli10736 (27 Jun 2011)
@1 The view sorting should be respected as is the case currently.
3) Stephan H. Wissel1981 (08 Jul 2011)
use ?OpenView&count=5 in an iframe. Mark the view as passthru HTML. The $$ViewTemplate does the surrounding HTML.

or use ?ReadViewEntries&count=5&Outputformat=JSON in an Ajax call

Much more efficient that the @dbLookup (where you could do @Subset(@db....;5)
4) Mark Demicoli10736 (09 Jul 2011)
iframes = code sequencing "readystate" issues. ie code must wait for data-bearing iframes to be ready. v-messy.
5) Dave Navarre402 (11 Jul 2011)
If you do it using AJAX and ReadViewEntries, I think you find that data retrieval is very fast.
6) Vladimir Anoufriyonok25 (18 Feb 2012)
it's very good idea for web design!

no ajax, no iframe, if need SEO optimization for my site on Domino
7) Kenneth Axi2537 (19 Feb 2012)
I don't like the idea of using @DbLookup for this. There are much more efficient ways to achieve this. I would definitly do as Stephan stated above; use the ReadViewEntries in Ajax call.


Welcome to IdeaJam

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:

  • IBM Connections
  • IBM 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 >>

IdeaJam developed by

Elguji Software Logo