Date Range in Worksite MP not working

Hi,

I'm having trouble getting the Date Range option of the Advanced search to work. If I specify a date range for either the 'Created Date' or the 'Modified Date', then I always get no results back.

It's possible that this is a bug we've introduced in our customization, but it doesn't look likely. Has anyone seen this before?

Find more posts tagged with

Comments

InfiChat

I am experiencing the same issue.

jfincke

Me as well - I've tracked the issue down to the fact that my date field (extPm_target_date) has underscores in the name. The underscores are stripped out when the dateRangePicker loads, so the range is going against a field called "extPmtargetdate" which of course isn't on the form.

I don't have a fix yet but am working on a way to encode and then decode the underscore so it passes through the web request intact. I'll post again if this works.

Has anyone else been able to resolve this issue?

wiel

I encountered the same problem. I found out that it was introduced when I added the document-name field to the search-form. To fix this I added a fixed onDateChange function to my custom.js:

/*
 *  Fix for error searching date-range when search-criteria holds the field "name" 
 * form.name then refers to the element instaed of the form property "name"
 */

function onchangeDate(field)
{
 var value = getSelectedOptionValue(field);
 var context=field.name
 if (value == 'range')
 {
      var objectId=this["$parentId"]
      if(!objectId || objectId == "null")
              objectId=this["$objectId"]
        var url = 'dispatch?datasource=search&operation=dateRangeDialog&callback=rangeCallback&context='+context+'&formName='+$formName+'&decorate=false&storeUrl=false&timezone=' + this['$timezone'] + '&returnUrl=' + this['$thisUrl'] +  '&parentId=' + this['$parentId'];
        openWindow(url, "dateRangeWnd", 300, 200)
 }
}

jfincke

The good news is there's a technote for this. The bad news is that I can't figure out how to find worksite technotes on the devnet site Smiley Sad

I've asked our WS contact for help and I'll post the link when I get it.

wiel

These are 2 different issues:

1 with the underscores in the extended prtoperty name (this is what technote 52007-1859 is about; it is on the support site)
1 where the date-range does not work for standard Created Date and Modified Date fields. For this one the javascript fix should work

Migrateduser

Guys, you can get to the technotes through http://worksitesupport.interwoven.com/WorkSite/

User is Icustomermp and the password is the standard one. There is a technote search in the top right. We are looking at getting technotes available through this forum.

Chris
IWOV EMEA Support

jfincke

Thanks for your posts.

We ended up getting one of the technotes (#52007-1859); the instructions were to edit the field in registrations.xml.

In /webapps/worksitemp/views//registrations.xml, find the field and edit the "id" property to remove the underscores.

Restart Tomcat, problem solved.