122
Views
8
Comments
Solved
First record doesnt show on table

My table never shows the first record when I filter it and appears 3 records in the service studio only 2 show on the table. The first record never shows.



2018-06-05 16-54-03
Maria da Graça Peixoto
Solution

Hi! 

Have you check the "Start Index" you are using? It is the current index of the source list. Normally if you have refreshed the aggregate that is the last record.  

Regards

Graça

2020-09-11 18-53-44
Stacey Levine

What do you mean that 3 records are shown? are you sure that record was committed and is actually in the database?

UserImage.jpg
David Oliveira

Stacey Levine wrote:

What do you mean that 3 records are shown? are you sure that record was committed and is actually in the database?

Check the second and third images.


UserImage.jpg
David Oliveira

For example, when I click view data as seen on image 2 I can see 2 records but when I actually see the table online it only shows me 1. I've filtered with different values and its always the first one that does not show.

2018-06-05 16-54-03
Maria da Graça Peixoto
Solution

Hi! 

Have you check the "Start Index" you are using? It is the current index of the source list. Normally if you have refreshed the aggregate that is the last record.  

Regards

Graça

2020-03-05 14-29-02
José Costa

Hi David,

As Graça has said the issue is the Start Index.

The value that you are using in the Start Index is the value that is on the first record. Since you have the value 1 in the first record, your results will start showing in the element with index 1 which is the second record. Thus the first record never shows.

Remove the value from the Start Index property and everything should be ok.

Cheers,

José

2019-03-13 23-11-47
Rui Encarnação

Hi David,


Change StartIndex to 

List_Navigation_GetStartIndex(Table.Id, True)


Regards!

2014-10-21 20-15-17
Alberto Ferreira

Hello David

I think you would like to read the following article

https://itnext.io/outsystems-how-to-1-2c677f7efb8d

pay attention to the 12 point


Regards

2014-10-21 20-15-17
Alberto Ferreira

Thanks David.

This can help others user to use the same solution

Regards

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.