: 4582 | 108638 | 12353

DataGrid Control 
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.

: 44
: 44
: 0
: Domino Designer
: datagrid, view, folder, xpages
: Peter Presnell26659 17 Apr 2009
:
: / Email
As an alternative to Views/folders, provide the ability to execute a query at run time that returns a subset of documents in the database and allow me to display these documents in a control similar to a view/folder.  This is not unlike how datagrids work with SQL based languages.  I execute a specific SQL query and then display the nominated columns from the resuiltset in a grid control.  To allow performance tuning, the query should be able to be run against either the entire database or an existing view index.   This would be an ideal control to then add to an XPage design element (Web or Notes client versions).



1) Theo Heselmans6409 (20 Apr 2009)
This would be an awesomely useful control. Is already available in most development environments. If the user is capable of changing the column-width, re-sorting and re-ordering columns, and adding 'groups by's that would probably stretch it a bit, but one can only dream.
2) Richard Moy378 (29 Apr 2009)
This should have been in Notes and Domino a long time ago. Another example of features in Notes that does not get updated to meet the needs.
3) charles ross287 (13 May 2009)
Isn't this possible with XPages?
4) Peter Presnell26659 (13 Sep 2009)
@Charles, No Xpages largely runs against existing views.
5) Bill Hanson178 (08 Feb 2010)
Actually, you can bind to almost any data source. Simple Binding only allows you to bind to a Document or View. But using JavaScript, you can bind to anything that you can access via JavaScript.

For example, the following JavaScript data source may be used to populate a data table with 10 rows and 3 columns of data.

var results = new Array();
for (var i = 0; i < 10; i++) {
results = new Array();
results[0] = "row" + i + ", col1";
results[1] = "row" + i + ", col2";
results[2] = "row" + i + ", col3";
}
return results;
6) Bill Hanson178 (08 Feb 2010)
That code didn't post right. Let me try again...

var results = new Array();
for (var i = 0; i < 10; i++) {
results = new Array();
results[0] = "row" + i + ", col1";
results[1] = "row" + i + ", col2";
results[2] = "row" + i + ", col3";
}
return results;
7) Bill Hanson178 (08 Feb 2010)
Nope, wrong again! How can I post source code so that it won't strip out any charachters?










:
:




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 >>


13
Two-week Calendar view
3
@Formula library
2
New Hide-When property
3
Activity Logging for Quickr
5
"follow-up complete" flag
15
Remake Resource Reservation template using XPage
17
Store IP Address / remote host data in Password Lockout documents
18
Checking Out-Of-Office status of others
0
Use more customization features in ND9 NotesMail
7
DocumentCollection.search(@formula)
23
Tool to show unreferenced design elements for easy cleaup
5
Bring sametime audio and video into the web browser using WebRTC
17
"Window Title" for views
17
QuickR application/widgets for Android/iPhone
21
Create Computed Text with the same text style as the current paragraph
9
@Function and LotusScript to "View..Customize This View" dialog
8
Extend the 'User detail' info of a database
17
Print of calendar in color
6
Shared Actions belong under Shared Elements
20
Facelift all web enabled templates with xPages
3
Please extend WebDAV to include calDAV & cardDAV support for contacts/calendar syncing
2
Skin-ing Notes Design elemens
14
Add some views into the "Views" section of the Notes 8.5 mailbox
17
Display first line of code instead of "<computed text>"
8
Show Design last modified date in the properties of the database in the design section in the tab Inheritance






IdeaJam developed by

Elguji Software Logo