Problem with Link Address

[Rich Hartnett]

I'm trying to create a link which will take the user from the simple searchable grid that he is on, to the actual record in it's full length, which is normally available on a different grid.

My link field is called "Record_No." The page containing the secondary grid is "NCCEViolationSet.a5w." And the actual grid within that page is called "ViolationSet_ncce.a5wcmp."

My link address is as follows:

NCCEViolationSet.a5w?ViolationSet_ncce_filter=record_no="{Record_No}"

When the user clicks on the link, it takes him to the correct .a5w page, but the only thing showing is the search section of the grid. It is not opening the actual record.

My Record_No field is numeric. I've tried the above address with single quotation marks, double quotation marks, and with no quotation marks, and I get the same result every time.

Is my link address set up wrong?

[Rich Hartnett]

Re: Problem with Link Address

Steve W., any ideas on this one? There are examples on the grid link builder, but even following the examples I can't seem to get it to work.

[JerryBrightbill]

Re: Problem with Link Address

Rich, this thread may help you

http://msgboard.alphasoftware.com/al...ad.php?t=63306

[Rich Hartnett]

Re: Problem with Link Address

Thanks Jerry, but I still don't seem to be having any luck. In the example on the post you referred me to, the sample link address is:

customers.a5w?customers_filter=bill_state_region=%22NY%22

and based on that example, I came up with the following address for my situation:

My a5w page is: NCCEViolationSet.a5w
The grid name is: ViolationSet_ncce.a5wcmp
My filtering field is: Record_No (which is a numeric, auto-incrementing field)

NCCEViolationSet.a5w?ViolationSet_ncce_filter_Record_No={Record_No}

Instead of getting the filtered record, I get the first record in the database.
Any further thoughts?

[Peter.Greulich]

Re: Problem with Link Address

My filtering field is: Record_No (which is a numeric, auto-incrementing field)

Rich, Try the following syntax and let me know if it works in your situation:

NCCEViolationSet.a5w?ViolationSet_ncce_filter=Record_No='{Record_No}'

[Rich Hartnett]

Re: Problem with Link Address

Hi Pete,

No that didn't work. Same thing happens, I get the first record in the database.

[Rich Hartnett]

Re: Problem with Link Address

Sorry, hit the post button twice by accident.

[martin horzempa]

Re: Problem with Link Address

Hi Rich

what is actually returned in the address bar when you click on the link?

[Peter.Greulich]

Re: Problem with Link Address

How about this? (I'm just wild guessing):

NCCEViolationSet.a5w?ViolationSet_ncce_filter=trim(str(Record_No))='{Record_No}'

[Rich Hartnett]

Re: Problem with Link Address

Hi Martin,

Here's what shows in the address bar when I click on one of my links. In this case, it should return Record No. 16625.

http://10.1.10.40/NCCEViolationSet.a5w?ViolationSet_ncce_filter=Record%5FNo%3D%2716630%27

[Rich Hartnett]

Re: Problem with Link Address

Thanks for trying guys. No Pete, that didn't work either. :(

[Peter.Greulich]

Re: Problem with Link Address

FWIW: I meant to say:

NCCEViolationSet.a5w?ViolationSet_ncce_filter=[COLOR=Red][B]alltrim[/B][/COLOR](str(Record_No))='{Record_No}'

Because:

?trim(str(123))
= "       123"

?alltrim(str(123))
= "123"

[Rich Hartnett]

Re: Problem with Link Address

Same results Pete.

[martin horzempa]

Re: Problem with Link Address

Rich

http://10.1.10.40/NCCEViolationSet.a...%3D%2716630%27

if the link you clicked gave you the above
this would be the same as typing directly into the address bar
the following

http://10.1.10.40/NCCEViolationSet.a5w?ViolationSet_ncce_filter=Record_No='16630'

if the record_no is NUMERIC then type the following into a new blank browser window address bar
http://10.1.10.40/NCCEViolationSet.a...ecord_No=16630


if this doesnt return the record with the record_num equal to 16630

then
1) this record might not exist - but i am sure that it does so i would suspect that the destination component might be your problem possible the inclusion of the search part


one way to check this is to make another component based on the same info and
DONOT include a search part or a detail part - and set the number of rows to display to 1 and make sure you include the record_no field in the new grid and that it is displayed

then create a new page and see if you can get this to display the correct record

[Rich Hartnett]

Re: Problem with Link Address

Martin, I too was concerned about the fact that I had a search option in the grid, as well as having it set hide the grid when no seach was being conducted.

So at your advice, I created a duplicate a5w page containing a duplicate grid, but this time without a search component, and set to display one record. The new address is:

http://10.1.10.40/NCCEViolationSet2....ecord_No=16630

Unfortunately, I get the same result. First record of the database only. (And record #16630 does exist.)

Incidentally, my records are shown in a freefrom layout. That shouldn't make any difference, should it?