DMXzone App Connect Support Product Page

Answered

Details page, filtered by an URL

Asked 30 Oct 2017 08:56:03
1
has this question
30 Oct 2017 08:56:03 Edgar Tossijn posted:
I followed the instructions on the Details Page, filtered by an URL video.

Now I like to adjust the following URL filter on my master page:
cvDETAILS.php?id={{lastname}}">details</a>

to a filter containing more information, like initials (or more), like:
cvDETAILS.php?id={{initial}}{{lastname}}">details</a>

What is the correct way to do so?

Replies

Replied 30 Oct 2017 09:10:19
30 Oct 2017 09:10:19 Teodor Kuduschiev replied:
Hello Edgar,
How would you like to use this - filtertwo different database fields by both "{{initial}} AND {{lastname}}" or filter one field by both values like: "{{initial}}{{lastname}}"?
Replied 30 Oct 2017 09:21:47
30 Oct 2017 09:21:47 Edgar Tossijn replied:
Hello Teodor,

The database contains different fields, as initial, firstname, lastname et cetera.

As, in my case, several employees do have the same lastname, I have to filter on a extra field, like initial.

I assume that I have to do something like ?id1={{initial}}&id2={{lastname}} but I do not know how to implement this in your, by the way excellent, extension.
Replied 30 Oct 2017 09:27:12
30 Oct 2017 09:27:12 Teodor Kuduschiev replied:
Hey Edgar,
First, create two GET vars in server connect, and in the query builder add both of them, using the AND operator:

So then in the link just bind them both:
cvDETAILS.php?id={{initial}}&id2={{lastname}}">details</a>
Just the same as you do it with one GET var but do it for 2
This reply was removed on 10/30/2017 11:11:14 AM.
See the changelog
Replied 30 Oct 2017 11:11:56
30 Oct 2017 11:11:56 Teodor Kuduschiev replied:
Hi Edgar,
I am not really sure i understand what do you need to achieve. Please send a lin k to your page, to with a detailed explanation what needs to be filtered and how.

Reply to this topic