Pre-filter makes form not find records

[arnor@icetips.com]

Hi guys,

I added a pre-filter to my list. Works fine. However, when I go to edit or view the rows, I get an error: "Error We are unable to find this record" If I remove the pre-filter the form works again. Add the pre-filter and I get the same error. The pre-filter I'm using is:

{$my-id}

It seems to work just fine, but the form stops working. I found another mention of this same problem from 2010: http://fabrikar.com/forums/index.ph...le-to-find-this-record-in-details-view.38862/

Any ideas?

Note that this pre-filter is on an INT column in the SQL table.

Best regards,

 

[troester]

Really {$my-id} ?
It must be {$my->id}

Do you have custom edit/view links in your list?

 

[arnor@icetips.com]

Hi,

Sorry, typo, it was {$my->id} see: https://www.screencast.com/t/aCFVRtZszP7i

No, no custom links. The links to the form do not change when I put the pre-filter in. But now it works with: https://www.screencast.com/t/Oin4bUkgSd1N

Don't know what it was having problems with, I can't see the difference, but it works now

Best regards,

 

[cheesegrits]

One thing to watch for when using {$my->id} in a pre-filter is that if the field you are filtering on is a join or a user element, make sure you use the "whatever (raw)" option for the field name. Joins (and user and CDD) can be filtered against the "value" (raw) or the "label". So if you have a 'user' element called (say) "User Name" set to display (say) the name, filtering on the "User Name" field option for the id won't work (it'd try and match the id with the name). You'd need "User Name (raw)".

-- hugh

 

[arnor@icetips.com]

Hi Hugh,

Thanks for the tip!

Best regards,