WeStandWithUkraine

51 Posts
ostap
3 years ago
1
Topic

There is a list output in the form of a table. 2 fields: "date"and " value".The table is sorted by the «date» field.

At the output we have the following:

date | value

01.01.19 | val1

01.01.19 | val2

02.01.19 | val3

02.01.19 | val4

03.01.19 | val5

03.01.19 | val6

Can Seblod be used to remove repetitions from a sorted column? I. e. to make so:

date | value

01.01.19 | val1

| val2

02.01.19 | val3

| val4

03.01.19 | val5

| val6

Get a Book for SEBLOD
1279 Posts
Bucklash
3 years ago
0
Level 1

Hi

Have you tried using 

- sql query field, 

- mode as standalone query in the search form

- manually create search query using  SELECT DISTINCT....

Get a Book for SEBLOD