This, that and the other (may contain nuts)

XPages: Hide Detail Rows

Steve Castledine  February 16 2010 08:41:42 AM
Very quiet around here as very busy (some very cool stuff) and still catching up on "I will document that for you" from Lotusphere. So here's one off that list "Hide Detail Rows".

So in Notes development we have the ability to add numeric values to columns and add totals. Often we are not interested in the number per row but just the totals, maybe by category:

Image:XPages: Hide Detail Rows
So we set the view column property "Hide Detail Rows" to achieve this:

Image:XPages: Hide Detail Rows
When we want to do the same for XPages, this particular property is not carried forward and so when creating a default view we get:

Image:XPages: Hide Detail Rows
So the first thing we need to do for this example is to make it a whole number. To do this we navigate to the column properties and section "data" and set display type to Number, and format as Decimal, Integer only.

Image:XPages: Hide Detail Rows
We then need to hide the detail rows, but before that we need to assign a "name" to our row data so we can reference it. We do this in the view panel properties under data and "var" (set to "rowData" below).

Image:XPages: Hide Detail Rows
We then change our totals column to display a computed value. Our computed value would then detect whether we are a category or document row (using isCategory()) and display a value accordingly:

Image:XPages: Hide Detail Rows
Image:XPages: Hide Detail Rows

if(rowData.isCategory()){return rowData.getColumnValue("$2")}


Image:XPages: Hide Detail Rows
Comments

1Mark Hughes  2/16/2010 11:45:03 AM GMT -6  XPages: Hide Detail Rows

Do you have any idea how long i have wanted to do this? Thanks for the solution!!

2Erik Brooks  2/16/2010 7:18:06 PM GMT -6  XPages: Hide Detail Rows

Please tell me there's a very obvious reason why all of the popular, technically-focused IBMers have been blogging about views in the past several months. :-)

3Steve Castledine  2/17/2010 3:44:52 AM GMT -6  XPages: Hide Detail Rows

I just blog as questions come up Erik :)

4Jimmy Jiang  6/17/2010 5:20:54 AM GMT -6  XPages: Hide Detail Rows

I followed step by step, and I got this error:"Script interpreter error, line=1, col=14: Error calling method 'isCategory()': 'rowData' is not a valid object"

I don't know why. I already defined "rowData".

Please tell me what I missed, Thank you very much!

(My Lotus Notes Version is R8.5)

Orz

5Jimmy Jiang  6/18/2010 2:55:26 AM GMT -6  XPages: Hide Detail Rows

Hi Steve, your help is urgently needed.

a thousand thanks!

6Jimmy Jiang  6/21/2010 5:46:34 AM GMT -6  XPages: Hide Detail Rows

I solved this problem.

7Ian Mannion  1/4/2011 4:30:29 AM GMT -6  XPages: Hide Detail Rows

Good tip - Thanks...

8Andrew Reynolds  5/24/2011 8:59:04 PM GMT -6  XPages: Hide Detail Rows

Great tip here, however when I use it removes the count (total) from the end. Any ideas why? (on 8.5.2)

9Tim Wellman  4/9/2013 8:09:13 AM GMT -6  XPages: Hide Detail Rows

Just found this. Thank you!

10Marc Daft  4/12/2013 1:50:08 PM GMT -6  XPages: Hide Detail Rows

This is great, but as 8Andrew Reynolds mentions this removes the Total count at the bottom. I need to fill a requirement that shows this exactly plus the total of all the categorized columns at the bottom, like you can do in the Notes Client. Any ideas? Thanks.

11  12/19/2013 6:49:36 AM GMT -6  XPages: Hide Detail Rows

thank you man

12Manoj  1/4/2014 12:10:08 AM GMT -6  XPages: Hide Detail Rows

Hi

I used this code.

When you have a link to open as next column , this link will not display the success xpage with values.

View level it is working.

Is there any updates?

13Azhar khan  3/8/2014 3:33:19 AM GMT -6  XPages: Hide Detail Rows

You can use this code to your Total column.

Please change the below Xpage view column formula, according to your totals column name.

viewEntry.isDocument()? '' : viewEntry.getColumnValue('<totalColumnName>')

14Himanshu  6/24/2014 11:14:40 PM GMT -6  XPages: Hide Detail Rows

might be years late but this is first search result on google so here goes:

(rowData.isCategory()||rowData.isTotal())?rowData.getColumnValue('TotalColumnName'):''

15  8/6/2014 3:15:25 PM GMT -6  XPages: Hide Detail Rows

worked like a charm and saved me lots of time, thanks !!!

16buy_cialis  4/16/2015 2:33:08 AM GMT -6  buy cialis

Hello!

<a href="{ Link } cialis</a> ,

17cialis  4/19/2015 11:03:47 AM GMT -6  cialis

Hello!

<a href="{ Link } ,

18cialis  4/19/2015 4:01:49 PM GMT -6  cheap cialis online

Hello!

<a href="{ Link } cialis online</a> ,

19tadalafil  4/23/2015 3:01:34 PM GMT -6  tadalafil

Hello!

<a href="{ Link } , <a href="{ Link } ,

20cialis_canada  4/24/2015 1:35:02 PM GMT -6  cialis canada

Hello!

<a href="{ Link } canada</a> , <a href="{ Link } canada</a> ,

21cialis  4/25/2015 5:46:44 AM GMT -6  cialis

Hello!

<a href="{ Link } , <a href="{ Link } ,

22cialis_pills  4/27/2015 9:03:04 AM GMT -6  cialis pills

Hello!

<a href="{ Link } online pharmacy</a> , <a href="{ Link } pills</a> ,

23purchase_viagra  4/27/2015 11:47:26 AM GMT -6  purchase viagra

Hello!

<a href="{ Link } viagra</a> , <a href="{ Link } cialis</a> ,

24online  4/27/2015 11:03:14 PM GMT -6  viagra online pharmacy

Hello!

<a href="{ Link } online pharmacy</a> , <a href="{ Link } pills</a> ,

25prescription  4/28/2015 1:40:31 AM GMT -6  cialis prescription cheap

Hello!

<a href="{ Link } viagra online without prescription</a> , <a href="{ Link } prescription cheap</a> ,

26cialis_sample  5/1/2015 1:26:39 AM GMT -6  cialis sample

Hello!

{ Link } , , { Link } , ,

27generic_viagra  5/6/2015 10:46:44 AM GMT -6  generic viagra

Hello!

{ Link } , , { Link } , ,

28viagra  5/7/2015 3:57:28 PM GMT -6  natural viagra alternatives

Hello!

{ Link } , , { Link } , ,

29online  5/8/2015 3:27:24 AM GMT -6  viagra online shop in uk

Hello!

{ Link } , , { Link } , ,

30cialis  5/8/2015 3:27:26 AM GMT -6  cialis

Hello!

{ Link } , , { Link } , ,

31cialis_pills  5/8/2015 10:04:11 PM GMT -6  cialis pills

Hello!

{ Link } , , { Link } , ,

32of  5/15/2015 2:22:33 PM GMT -6  price of viagra

{ Link } , { Link } ,

33cialis_pills  5/15/2015 9:23:42 PM GMT -6  cialis pills

{ Link } , { Link } ,

34pharmacy  5/17/2015 9:34:21 AM GMT -6  online pharmacy viagra

{ Link } , { Link } ,

35viagra  5/17/2015 3:09:54 PM GMT -6  get viagra avoid prescription

{ Link } , { Link } ,

36online  5/17/2015 8:32:56 PM GMT -6  viagra online pharmacy

{ Link } , { Link } ,

37side  5/20/2015 6:28:44 PM GMT -6  viagra side effects

{ Link } , { Link } ,

38side  5/21/2015 2:04:49 PM GMT -6  viagra side effects

{ Link } , { Link } ,

39bo  6/19/2015 7:50:41 AM GMT -6  cialis bo script

{ Link } , { Link } ,

40viagra  6/20/2015 7:42:56 AM GMT -6  viagra

{ Link } , { Link } ,

41sildenafil  6/20/2015 11:45:18 AM GMT -6  sildenafil

{ Link } , { Link } ,

42cialis  7/6/2015 10:36:49 AM GMT -6  discount cialis pricesgeneric cialis 10mg

{ Link } , { Link } ,

43fast  7/8/2015 12:03:51 PM GMT -6  cialis fast delivery

{ Link } , { Link } ,

44side  7/15/2015 9:01:14 PM GMT -6  viagra side effects

{ Link } , { Link } ,

45prescription  7/17/2015 8:59:38 AM GMT -6  cialis prescription price and benefits

{ Link } , cialis ,

46viagra_professional  7/17/2015 2:24:42 PM GMT -6  viagra professional

{ Link } , { Link } ,

47viagra  7/17/2015 7:02:05 PM GMT -6  viagra

{ Link } , cialis ,

48cheap_viagra  7/21/2015 10:01:20 AM GMT -6  cheap viagra

{ Link } , { Link } ,

49cialis  7/28/2015 5:30:58 PM GMT -6  cialis

{ Link } , { Link } ,

50erection  8/3/2015 1:03:47 PM GMT -6  viagra erection photos

{ Link } , { Link } ,

51cialis  9/6/2015 2:58:26 PM GMT -6  generic cialis paypal

Hello!

{ Link } , , { Link } , ,

52cheapest  9/23/2015 7:33:29 PM GMT -6  cialis cheapest lowest price

{ Link } , { Link } ,

53canadian_cialis  10/7/2015 11:55:44 AM GMT -6  canadian cialis

{ Link } , { Link } ,

54canadian_viagra  10/8/2015 3:50:26 AM GMT -6  canadian viagra

{ Link } , { Link } ,

55super  10/13/2015 5:40:55 PM GMT -6  http://pills10superactive.com/

{ Link } , { Link } ,

56generic_viagra  10/28/2015 3:09:53 PM GMT -6  generic viagra

Hello!

{ Link } , , { Link } , ,

57online  10/29/2015 2:33:02 AM GMT -6  cialis online online pharmacy

Hello!

{ Link } , , { Link } , ,

58viagra  11/7/2015 6:26:06 PM GMT -6  buy viagra without prescription

{ Link } , { Link } ,

59without  11/11/2015 4:39:18 AM GMT -6  viagra without a doctor prescription from canada

{ Link } , { Link } ,

60without  11/11/2015 5:39:18 PM GMT -6  viagra without a doctor prescription from canada

{ Link } , { Link } ,

61without  11/13/2015 5:51:31 AM GMT -6  viagra without a doctor prescription online pharmacies

{ Link } , { Link } ,

62online  11/18/2015 2:09:44 PM GMT -6  cialis online pharmacy

{ Link } , { Link } ,

63cialis  12/24/2015 8:20:08 AM GMT -6  generic cialis pills mexico

Hello!

{ Link } , , { Link } , ,

64buy_cialis  12/24/2015 4:50:09 PM GMT -6  buy cialis

Hello!

{ Link } , , { Link } , ,

65buy_cialis  12/25/2015 12:34:37 AM GMT -6  buy cialis

Hello!

{ Link } , , { Link } , ,

66discount_viagra  8/24/2016 5:52:59 AM GMT -6  discount viagra

Hello!

{ Link } , ,

67from  12/5/2016 9:44:37 AM GMT -6  cialis from india

Pharmacy Businesses For Sale > commander du { Link } , pas cher: Pharmacy Network.

68from  12/5/2016 9:44:57 AM GMT -6  cialis from india

{ Link } , for sale on-line - No prescription needed, Safe and secure (-for-sale.

69generic  12/6/2016 9:01:43 AM GMT -6  tadalafil generic cialis

Not all drugs work for everyone, including { Link } , .

70Daniel  12/6/2016 9:02:10 AM GMT -6  Daniel

Great blog! I am loving it!! Will come back again. I am taking your feeds also

71Daniel  12/6/2016 9:02:32 AM GMT -6  Daniel

Great blog! I am loving it!! Will come back again. I am taking your feeds also

72Nikki  2/7/2017 6:28:05 AM GMT -6  XPages: Hide Detail Rows

Very large dogs, the parody of Russia. I advise you to read about it on this site a lot of pictures and interesting facts about it

{ Link } Caucasian Shepherd

73Kent  2/7/2017 6:28:49 AM GMT -6  XPages: Hide Detail Rows

Very beautiful dog, this is a very old breed. On this website there is an interesting history of its occurrence

{ Link } australian shepherd