Hi

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 www.hkifa.co.uk/glossary.html

HELP ASAP PLEASE

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.

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:

www.hkifa.co.uk/glossary1.html#

but also hide 'B' if there were no records beginning with 'B'

Hi Dan,
As i explained above - apply the the group by filter on the repeat region for that .

Thanks for the reply

so the actual page looks like this www.hkifa.co.uk/glossary/

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.

thanks
Dan

There is a tutorial explaining how to use the group by filter: www.dmxzone.com/go/32971/using-the-group-by-filter

hIHi

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

Hello Dan,
Do you want to enter static text?

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
Dan

Well, just enter the static value in the filter value field....

i thought that was the case yes, i will retry it

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


thanks
Dan

Yes, Starts With - Value A will return all records starting with "A"?