DMXzone App Connect Support Product Page
Paging Traversal By Letter
07 Feb 2018 13:10:27
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
HELP ASAP PLEASE
07 Feb 2018 14:51:22
07 Feb 2018 14:51:22 Teodor Kuduschiev replied:
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.
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:
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'
07 Feb 2018 16:13:29
07 Feb 2018 16:13:29 Teodor Kuduschiev replied:
As i explained above - apply the the group by filter on the repeat region for that .
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.
08 Feb 2018 07:54:09
08 Feb 2018 07:54:09 Teodor Kuduschiev 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
08 Feb 2018 14:17:43
08 Feb 2018 14:17:43 Teodor Kuduschiev replied:
Do you want to enter static text?
08 Feb 2018 14:44:50
08 Feb 2018 14:44:50 Dan Everton replied:
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 Dan
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....
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? thanks Dan
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 Login to Reply