Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Can Text 64kB be search on in Service Desk?

Highlighted
Iceman_1
Super Collector

Can Text 64kB be search on in Service Desk?

I'm pretty sure this feature is not available on purpose, but why can't we do an advanced find search in Text64kB field? I also noticed that some of the third party software don't do it either!

Please let me know if there are any workarounds for it....
5 REPLIES
Iceman_1
Super Collector

Re: Can Text 64kB be search on in Service Desk?

In addition to the entry above... we have installed SD 4.5 SP11.
Ramaprasad N
Esteemed Contributor

Re: Can Text 64kB be search on in Service Desk?

Hi,

64K text fields cannot be used in advanced search, DB rules, UI rules, neither can they be audited. This is because, the 64K fields can hold large amount of data and any search on such a large field can have adverse impact on the DB/OVSD. Even history is a 64K field and hence, we cannot use the history field in any of the search, rules, etc.

I don't think we have an alternate solution. Or at least, I am not aware of.
Gretar_Palsson
Collector

Re: Can Text 64kB be search on in Service Desk?

We have SD4.5 with SP15 and we are able to search 64kb fields. I cant remember what SP it was fixed in.
Ruth Porter
Honored Contributor

Re: Can Text 64kB be search on in Service Desk?

Hi there,

As far as I am aware but I could well be out of date, you cannot search 64kB fields if using an Oracle DB as it is Oracle that does not allow it. If using a SQL server DB, I have used sd_dataform to search in a smart action.

Hope this helps

Ruth
http://www.teamultra.net
Iceman_1
Super Collector

Re: Can Text 64kB be search on in Service Desk?

Thanks to everyone for their input. I will do some research and investigate on a possible service pack upgrade.
//Add this to "OnDomLoad" event