: 4582 | 108609 | 12352

"MaxEntries" parameter for @DBLookup 
New idea submissions, commenting and voting are no longer available on this site. Logins have also been disabled.
Use this IdeaSpace to post ideas about Domino Designer.

: 19
: 21
: 2
: Domino Designer
: @dbcolumn, @dbcolumn
: Mark Demicoli11777 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 Navarre339 (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 Demicoli11777 (27 Jun 2011)
@1 The view sorting should be respected as is the case currently.
3) Stephan H. Wissel1692 (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 Demicoli11777 (09 Jul 2011)
iframes = code sequencing "readystate" issues. ie code must wait for data-bearing iframes to be ready. v-messy.
5) Dave Navarre339 (11 Jul 2011)
If you do it using AJAX and ReadViewEntries, I think you find that data retrieval is very fast.
6) Vladimir Anoufriyonok15 (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 Axi1694 (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 >>

XPages - allow view control to select a folder as a data source
Policy to Set File Types to Automatically Create with IBM Lotus Symphony
Explicit Policies
Process pressing of Ctrl+0 in chat window of integrated in LN 8.5 ST client
Switch beetwen opened windows by Ctrl+Tab
Separate frame for folders in navigator
Calendar Repeat Options
Add link to last page for iNotes Ultralite mode
Port the Admin Client multi-database tools to Working Sets.
Enable Editor Access Security on Auto Populate Fields on Group Documents
Enhance - Send Messages to All Invitees - feature in Calendar
Tell us whether LS and "old style" UI improvements will still be made
Live Text in the Browser/Xpages
User defined rules in DCT
Give us back a Lotusphere Europe
In Sametime Meeting, restrict chat to meeting members
Allow developers hide views from View-->>Goto to the end users in a much simple way.
Allow a database to be signed inside Designer
Server Notes.INI Settings Heirarchy

IdeaJam developed by

Elguji Software Logo