SingleSearchResponse object not returning requested values

Hey All,

I'm trying to hit the SearchService web service to get a document's OTMIMEType, OTName, and OTModifyDate by populating a SingleSearchRequest.ResultTransformationSpec object (see line of code below).

_queryRequest.ResultTransformationSpec = new string[] { "OTMIMEType", "OTName", "OTModifyDate" };

The SingleSearchResponse object returns all but the OTModifyDate attribute. I've double checked that the OTModifyDate is searchable and retrievable.

Also, is there a way to get the latest Revision Number via the above method? Is there a OTRevisionNumber attribute?

I'm using ECM 9.7.1.

Thanks.

Find more posts tagged with

Comments

Kyle_Swidrovich

Hi Christian,

It’s been a while since you posted this but I did a test here against my 9.7.1 instance and I’m seeing the same issue.

GetFieldInfo shows that OTModifyDate is “Retrievable”, however, it doesn’t seem to come back in the result set.

I included all regions listed in GetFieldInfo on my instance as a test:

query.ResultTransformationSpec =new string[] { "OTAssignedToName", "OTCreateDate", "OTCreatedBy", "OTCreatedByName", "OTDateAssigned", "OTDateCompleted", "OTDateDue", "OTDateStarted", "OTLocation", "OTMIMEType", "OTModifyDate", "OTName", "OTObject", "OTObjectDate", "OTObjectSize", "OTReservedByName", "OTReservedDate", "OTSubType", "Score" };

The returned hits include the following regions:

OTCreatedBy (as “Created By”)

OTLocation (as “Location”)

OTMIMEType (as “MIMEType”)

OTName (as “Name”)

OTObject

OTObjectSize (as “Size”)

Score

OTObjectDate (as “Date”)

GetFieldInfo shows that these regions are the only regions that have “Retrievable” set to TRUE, except OTModifyDate which should probably also be returned as it’s marked as retrievable.

I went to the Livelink 9.7.1 GUI (Advanced Search Page -> Display Options) and can see the same list noted above, except Modify Date, which is also missing from the list.

So this wasn’t specific to the Enterprise Web Services implementation on my system.

I check my Regions page of the Enterprise Search Manager, and the OTModifyDate region was not marked as Displayable.

Once marked as Displayable, the Display Options page then showed “Modification Date” as an option and my test EWS application started returning “Modification Date” in the results.

So I think the problem is on your system, the OTModifyDate region is not marked as Displayable on the Regions page of your Enterprise Search Manager.

Given that even when it’s not marked as Displayable it’s showing up as “Retrievable” through a GetFieldInfo call, I’d call that a bug.

I’ll log something in our bug tracking system for that error.

Cheers,

Kyle

Kyle_Swidrovich

Odd... I went back to gather details for a bug entry, but when I disabled Displayable for OTModifyDate, its "Retrievable" status went to false.
So I don't seem to have any bug to log. I must have misread my output.

Anyway, marking OTModifyDate as "Displayable" should do the trick.

Kyle_Swidrovich

In regards to your "Revision Number" attribute, could you clarify where in the GUI one would see this attribute?
The regions you have to play with are available on the Regions page of the Enterprise Search Manager.

Kyle_Swidrovich

If by "Revision Number" you mean the "Version Number", then yes, there is an OTVersion region that stores this number.
If you only want to search the most current versions of each item in your repository, simply search against the 'Enterprise' slice. That slice definition already contains a where clause fragment that limits the searches to the most current versions (of versionable items). If you want to search all versions, then search against the 'Enterprise [All Versions]' slice.

Nidhi_Patel

Hello There,

I am facing the same issue, will cross check Displayable, on that note.

I need to search based on OTModifyDate > certain date, but I am not able to exactly find the syntax for it.

Any idea of the syntax?

I had referred to :

https://knowledge.opentext.com/knowledge/cs.dll/fetch/2001/744073/6848762/19905386/Constructing_Search_Bar_Queries.pdf?nodeid=22490878&vernum=-2

Looking ahead to hear from you.

Thanks!