Discussion Forum

jesse.glaves

Member

Registered: June 28, 2014

Posts: 124

Module searchable list view excluding records with apostrophes

It appears that a module (searchable list) view is excluding any records that have text columns with apostrophes in them. If I check out the database, the apostrophe's are being escaped correctly in the database.

These three rows are visible in the database, but not in the view.

'63', '...', '...', 'Director\'s Assistant/Employee Recruitment Coordinator', '', '', '[]', '[]', '[]', '[]', '[]', 'Staff', '...'
'89', '...', '...', 'Director\'s Administrative Clerk', '', '', '[]', '[]', '[]', '[]', '[]', 'Staff', '...'
'120', '...', '...', 'Student Health Clinic Physician\'s Assistant', '', '', '[]', '[]', '[]', '[]', '[]', 'Staff', '...'

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 978

Re: Module searchable list view excluding records with apostrophes

Can you send me a dump of the table (or just those few rows) as well as the row from bigtree_module_views for that list view? I used some test data on my development copy and I'm not running into an issue with apostrophes.

Thanks!

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 978

Re: Module searchable list view excluding records with apostrophes

Looks like the issue is with your "position" column -- it's being used for text but it's one of BigTree's reserved columns. Not 100% sure why it's not caching those records into the view, but you wouldn't be able to show that column in the view due to it being a reserved column. I switched the column's name to "title" and it loaded in those records properly.

I also noticed your view parsers for each column were just a variable name -- not sure what the intention was there but it was throwing errors when caching.

jesse.glaves

Member

Registered: June 28, 2014

Posts: 124

Re: Module searchable list view excluding records with apostrophes

Oh man, of course. I can't believe I didn't catch that. Thanks.

I also noticed your view parsers for each column were just a variable name -- not sure what the intention was there but it was throwing errors when caching.

Not sure what you mean here. Where would I look to see this?

timbuckingham

Administrator

From: Baltimore, MD

Registered: April 2, 2012

Posts: 978

Re: Module searchable list view excluding records with apostrophes

Here's what I'm referring to (when editing the view):

jesse.glaves

Member

Registered: June 28, 2014

Posts: 124

Re: Module searchable list view excluding records with apostrophes

Oh yeah. Completely unnecessary. I think I did that before I had a good grasp on what the view parsers were used for. I deleted them.