DMXzone App Connect Support Product Page

Paging Traversal By Letter

Asked 07 Feb 2018 13:10:27
has this question
07 Feb 2018 13:10:27 Dan Everton posted:

I have a data set of a glossary of terms

I want to A) Show a navigation of letters relating to the term title (but only show active letters (so A B C D E H K L) where a title begins with that letter.

B) I then want to show just the items beginning with that letter.

C) On initial load i want to show some info text which is hidden when a record is selected.

Here is the page in question



Replied 07 Feb 2018 14:51:22
07 Feb 2018 14:51:22 Teodor Kuduschiev replied:
Hello Dan,
In order to show only letters in the repeat region you will need to the group by filter, select the value to group by and then apply the sub filter with start set to 0 and length of 1, to group by the first letter:

Then inside the repeat region apply the same sub filter to the value, in order to only display first letters.

The rest is simple filtering inside the detail region.
Replied 07 Feb 2018 15:43:30
07 Feb 2018 15:43:30 Dan Everton replied:
ok thanks for this

how would i show only one letter for each - so, for example

say there was 15 records with a title beginning with 'A'

I would only want to show one 'A'

But i'd like to show all 15 entries if 'A' was clicked on.

See my idea of navigation here now:
Replied 07 Feb 2018 15:44:15
07 Feb 2018 15:44:15 Dan Everton replied:
but also hide 'B' if there were no records beginning with 'B'
Replied 07 Feb 2018 16:13:29
07 Feb 2018 16:13:29 Teodor Kuduschiev replied:
Hi Dan,
As i explained above - apply the the group by filter on the repeat region for that .
Replied 07 Feb 2018 22:56:18
07 Feb 2018 22:56:18 Dan Everton replied:
Thanks for the reply

so the actual page looks like this

can you see what needs to be done for it work as i discuss please?

i'm not trying to be difficult and take up your time

how do i apply the group by filters as I do not see it in any tutorial

can you please explain step by step ?

once i have done it once i'll be fine but it is not very clear from your message what it is i need to do

my client is asking me a lot to finish this,

please help teodor.

Replied 08 Feb 2018 07:54:09
08 Feb 2018 07:54:09 Teodor Kuduschiev replied:
There is a tutorial explaining how to use the group by filter:
Replied 08 Feb 2018 13:37:11
08 Feb 2018 13:37:11 Dan Everton replied:

In query builder I want to create a filter that on Title (column) that is filtered with 'Starts With'

In the value i want to enter a value (eg Title R)

How do i do this on an entered value?

Help please

Replied 08 Feb 2018 14:17:43
08 Feb 2018 14:17:43 Teodor Kuduschiev replied:
Hello Dan,
Do you want to enter static text?
Replied 08 Feb 2018 14:44:50
08 Feb 2018 14:44:50 Dan Everton replied:
Hi Teodor

Yes - a static value

I could do it easily in php / mysql using legacy server behaviours but can't see how

can you clarify pls

Thanks again
Replied 08 Feb 2018 14:48:34
08 Feb 2018 14:48:34 Teodor Kuduschiev replied:
Well, just enter the static value in the filter value field....
Replied 08 Feb 2018 14:50:57
08 Feb 2018 14:50:57 Dan Everton replied:
i thought that was the case yes, i will retry it

Would - Starts With - Value A return all records begining with A?

Replied 08 Feb 2018 14:53:11
08 Feb 2018 14:53:11 Teodor Kuduschiev replied:
Yes, Starts With - Value A will return all records starting with "A"?

Reply to this topic