2. PHPRunner General questions
  3. [SOLVED] Link to Another Custom View
This topic is locked
[SOLVED]

Link to Another Custom View

 		9/15/2022 3:39:45 PM
PHPRunner General questions
A
 Ace Drummond author

I have a summary table (states_provinces) showing states and member counts for each member status (Active, Inactive, No Charge).

State Abbv State Description Active Count Inactive Count No Charge Count Region

AK Alaska 2 4 1 NW

I want to click on one of the counts i.e. Active Count which in this case is 2 and display all members from the members table that are active.

I set up 'view as a hyper link' and set url prefix as 'members_list.php?state=, status='

I also set up field events before as:
params["state"] = row.getFieldText("state_abbv");
params["status"] = 'A';

When I try to execute this it generates a url like so: http://localhost/new_vrcs/members_list.php?state=,%20status=2

How can I get this to work?
A
 		Ace Drummond author 9/15/2022

I found the answer.

It needs to be as view/as-edit/as custom field with a hyperlink and not a hyperlink.

My code now is:

$count = $data["active_count"];
$state = $data["state_abbv"];
$value = "<a href='members_list.php?q=(mbr_status~equals~A)(state~equals~$state)'>$count</a>";