Re: Re: Re: CLOB search
ahmy historical recollection of the when/why of FTS being included was wrong then :) On Fri, May 10, 2019 at 8:12 AM Adams, Peter wrote: > In general, it’s pricing model dependent. > > > > However, I should have qualified my earlier statement: the “no extra cost” > in the newer pricing models applies only, if you are on versions 7.6.03 or > higher, which hopefully everyone is. > > Has nothing to do with Hub & Spoke. If you recall, in 7.6.03 we made a > change in technology around FTS – moving to Lucene. > > > > Peter > > > > > > *From: *ARSList on behalf of LJ LongWing < > lj.longw...@gmail.com> > *Reply-To: *ARSList > *Date: *Friday, May 10, 2019 at 6:55 AM > *To: *ARSList > *Subject: *[EXTERNAL] Re: Re: CLOB search > > > > Peter, > > Thank you for thatI thought that the FTS got included with the > specific version of Remedy where 'Hub and Spoke' model was > introducedthanks for the clarification. > > > > On Fri, May 10, 2019 at 7:47 AM Adams, Peter wrote: > > About FTS pricing: > > > > That depends on the pricing model that you’re using to license Remedy. > > The vast majority of our customers are on one of solution pricing models > that were first introduced in 2007. For those customers, FTS is no extra > cost. > > Only the few customers that remain on the very original pricing model for > Remedy – sometimes referred to as “green pricing” – would have to purchase > separate licenses for FTS. > > > > Peter > > > > > > *From: *ARSList on behalf of Thomas > Miskiewicz > *Reply-To: *ARSList > *Date: *Friday, May 10, 2019 at 6:30 AM > *To: *ARSList > *Subject: *[EXTERNAL] Re: CLOB search > > > > Does FTS cost extra? What’s the downside/ drawbacks? > > > On 10. May 2019, at 15:25, LJ LongWing wrote: > > If you have a CLOB, performance of searches is going to suck if doing it > directly at the DB level, if it's even possibleadding FTS to the field > indexes the field with a lucene index (FTS flat file), and a query against > that field doesn't go to the DB, instead it does the flatfile index search, > which is significantly more efficient and quicker than a db search > > > > So...yes it's avoidable if you don't want to take advantage of the things > that fts gives youbut your options of improving the effort with the DB > when searching a CLOB are very limited... > > > > On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz > wrote: > > Is FTS avoidable? > > > > On May 10, 2019, at 3:03 PM, LJ LongWing wrote: > > > > Would FTS help you in any way? I know it would help, but the question is > are you willing to make that change. > > > > On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz > wrote: > > Hi All > > we had to increase the size of a char field to over 4000 with huge > performance degradation when using this field for search. > > Does anyone know how to heal this? Would the Oracle 12 Text Option help? > > > Thomas > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006Q
Re: Re: Re: CLOB search
In general, it’s pricing model dependent. However, I should have qualified my earlier statement: the “no extra cost” in the newer pricing models applies only, if you are on versions 7.6.03 or higher, which hopefully everyone is. Has nothing to do with Hub & Spoke. If you recall, in 7.6.03 we made a change in technology around FTS – moving to Lucene. Peter From: ARSList on behalf of LJ LongWing Reply-To: ARSList Date: Friday, May 10, 2019 at 6:55 AM To: ARSList Subject: [EXTERNAL] Re: Re: CLOB search Peter, Thank you for thatI thought that the FTS got included with the specific version of Remedy where 'Hub and Spoke' model was introducedthanks for the clarification. On Fri, May 10, 2019 at 7:47 AM Adams, Peter mailto:peter_ad...@bmc.com>> wrote: About FTS pricing: That depends on the pricing model that you’re using to license Remedy. The vast majority of our customers are on one of solution pricing models that were first introduced in 2007. For those customers, FTS is no extra cost. Only the few customers that remain on the very original pricing model for Remedy – sometimes referred to as “green pricing” – would have to purchase separate licenses for FTS. Peter From: ARSList mailto:arslist-boun...@arslist.org>> on behalf of Thomas Miskiewicz mailto:tmisk...@gmail.com>> Reply-To: ARSList mailto:arslist@arslist.org>> Date: Friday, May 10, 2019 at 6:30 AM To: ARSList mailto:arslist@arslist.org>> Subject: [EXTERNAL] Re: CLOB search Does FTS cost extra? What’s the downside/ drawbacks? On 10. May 2019, at 15:25, LJ LongWing mailto:lj.longw...@gmail.com>> wrote: If you have a CLOB, performance of searches is going to suck if doing it directly at the DB level, if it's even possibleadding FTS to the field indexes the field with a lucene index (FTS flat file), and a query against that field doesn't go to the DB, instead it does the flatfile index search, which is significantly more efficient and quicker than a db search So...yes it's avoidable if you don't want to take advantage of the things that fts gives youbut your options of improving the effort with the DB when searching a CLOB are very limited... On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz mailto:tmisk...@gmail.com>> wrote: Is FTS avoidable? On May 10, 2019, at 3:03 PM, LJ LongWing mailto:lj.longw...@gmail.com>> wrote: Would FTS help you in any way? I know it would help, but the question is are you willing to make that change. On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz mailto:tmisk...@gmail.com>> wrote: Hi All we had to increase the size of a char field to over 4000 with huge performance degradation when using this field for search. Does anyone know how to heal this? Would the Oracle 12 Text Option help? Thomas -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=Dyi2CvdczdMFXw4D0H9QxXXhHFaCSz2jpU-ki94goho&s=OO54jdtog5TzRPbqYwPO_HkLzc_qTQi0H9TSfwGYfxo&e=> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Re: CLOB search
Peter, Thank you for thatI thought that the FTS got included with the specific version of Remedy where 'Hub and Spoke' model was introducedthanks for the clarification. On Fri, May 10, 2019 at 7:47 AM Adams, Peter wrote: > About FTS pricing: > > > > That depends on the pricing model that you’re using to license Remedy. > > The vast majority of our customers are on one of solution pricing models > that were first introduced in 2007. For those customers, FTS is no extra > cost. > > Only the few customers that remain on the very original pricing model for > Remedy – sometimes referred to as “green pricing” – would have to purchase > separate licenses for FTS. > > > > Peter > > > > > > *From: *ARSList on behalf of Thomas > Miskiewicz > *Reply-To: *ARSList > *Date: *Friday, May 10, 2019 at 6:30 AM > *To: *ARSList > *Subject: *[EXTERNAL] Re: CLOB search > > > > Does FTS cost extra? What’s the downside/ drawbacks? > > > On 10. May 2019, at 15:25, LJ LongWing wrote: > > If you have a CLOB, performance of searches is going to suck if doing it > directly at the DB level, if it's even possibleadding FTS to the field > indexes the field with a lucene index (FTS flat file), and a query against > that field doesn't go to the DB, instead it does the flatfile index search, > which is significantly more efficient and quicker than a db search > > > > So...yes it's avoidable if you don't want to take advantage of the things > that fts gives youbut your options of improving the effort with the DB > when searching a CLOB are very limited... > > > > On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz > wrote: > > Is FTS avoidable? > > > > On May 10, 2019, at 3:03 PM, LJ LongWing wrote: > > > > Would FTS help you in any way? I know it would help, but the question is > are you willing to make that change. > > > > On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz > wrote: > > Hi All > > we had to increase the size of a char field to over 4000 with huge > performance degradation when using this field for search. > > Does anyone know how to heal this? Would the Oracle 12 Text Option help? > > > Thomas > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > <https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Re: CLOB search
About FTS pricing: That depends on the pricing model that you’re using to license Remedy. The vast majority of our customers are on one of solution pricing models that were first introduced in 2007. For those customers, FTS is no extra cost. Only the few customers that remain on the very original pricing model for Remedy – sometimes referred to as “green pricing” – would have to purchase separate licenses for FTS. Peter From: ARSList on behalf of Thomas Miskiewicz Reply-To: ARSList Date: Friday, May 10, 2019 at 6:30 AM To: ARSList Subject: [EXTERNAL] Re: CLOB search Does FTS cost extra? What’s the downside/ drawbacks? On 10. May 2019, at 15:25, LJ LongWing mailto:lj.longw...@gmail.com>> wrote: If you have a CLOB, performance of searches is going to suck if doing it directly at the DB level, if it's even possibleadding FTS to the field indexes the field with a lucene index (FTS flat file), and a query against that field doesn't go to the DB, instead it does the flatfile index search, which is significantly more efficient and quicker than a db search So...yes it's avoidable if you don't want to take advantage of the things that fts gives youbut your options of improving the effort with the DB when searching a CLOB are very limited... On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz mailto:tmisk...@gmail.com>> wrote: Is FTS avoidable? On May 10, 2019, at 3:03 PM, LJ LongWing mailto:lj.longw...@gmail.com>> wrote: Would FTS help you in any way? I know it would help, but the question is are you willing to make that change. On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz mailto:tmisk...@gmail.com>> wrote: Hi All we had to increase the size of a char field to over 4000 with huge performance degradation when using this field for search. Does anyone know how to heal this? Would the Oracle 12 Text Option help? Thomas -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=-p3bdWG7vYdkTt7drxJU1lGabyBnkFDsCeyI4HR-08o&m=4iIYJMbiqpycmHYCnNd3mbBjjKaJf7XeIn95G-079rU&s=EK_h8006QuYaOBYRzv6ZLC1rMVSBEHe5Vm1cEIzK1P0&e=> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CLOB search
if you are on a modern version (9.x I know for sure, maybe even 8.1.02, but not 100% sure on that one) FTS is included with Remedy server...so, no extra monetary costthe cost you will bear is that of hard disk spacedepending on what all you have that's currently set to be indexed, your fts collections directory can get quite large (several hundred gig in large installations). I have a tool that'll give you an output that tells you everything that's currently set to be indexed ( http://remedylegacy.com/tools/fts-index/ ) and even provides a bulk option to turn off any/all of those indexesBMC has an article that contains some sql scripts that you can run that'll guestimate how much space will be taken by enabling fts ( https://communities.bmc.com/docs/DOC-49700 )...so, between the two you should be able to reasonably understand the impact of enabling FTS on your serverother than the resources necessary to store and maintain the indexes, the overall impact should be positive in your situation. On Fri, May 10, 2019 at 7:30 AM Thomas Miskiewicz wrote: > Does FTS cost extra? What’s the downside/ drawbacks? > > On 10. May 2019, at 15:25, LJ LongWing wrote: > > If you have a CLOB, performance of searches is going to suck if doing it > directly at the DB level, if it's even possibleadding FTS to the field > indexes the field with a lucene index (FTS flat file), and a query against > that field doesn't go to the DB, instead it does the flatfile index search, > which is significantly more efficient and quicker than a db search > > So...yes it's avoidable if you don't want to take advantage of the things > that fts gives youbut your options of improving the effort with the DB > when searching a CLOB are very limited... > > On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz > wrote: > >> Is FTS avoidable? >> >> On May 10, 2019, at 3:03 PM, LJ LongWing wrote: >> >> Would FTS help you in any way? I know it would help, but the question is >> are you willing to make that change. >> >> On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz >> wrote: >> >>> Hi All >>> >>> we had to increase the size of a char field to over 4000 with huge >>> performance degradation when using this field for search. >>> >>> Does anyone know how to heal this? Would the Oracle 12 Text Option help? >>> >>> >>> Thomas >>> -- >>> ARSList mailing list >>> ARSList@arslist.org >>> https://mailman.rrr.se/cgi/listinfo/arslist >>> >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist >> >> >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist >> > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CLOB search
Does FTS cost extra? What’s the downside/ drawbacks? > On 10. May 2019, at 15:25, LJ LongWing wrote: > > If you have a CLOB, performance of searches is going to suck if doing it > directly at the DB level, if it's even possibleadding FTS to the field > indexes the field with a lucene index (FTS flat file), and a query against > that field doesn't go to the DB, instead it does the flatfile index search, > which is significantly more efficient and quicker than a db search > > So...yes it's avoidable if you don't want to take advantage of the things > that fts gives youbut your options of improving the effort with the DB > when searching a CLOB are very limited... > >> On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz wrote: >> Is FTS avoidable? >> >>> On May 10, 2019, at 3:03 PM, LJ LongWing wrote: >>> >>> Would FTS help you in any way? I know it would help, but the question is >>> are you willing to make that change. >>> >>> On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz >>> wrote: >>>> Hi All >>>> >>>> we had to increase the size of a char field to over 4000 with huge >>>> performance degradation when using this field for search. >>>> >>>> Does anyone know how to heal this? Would the Oracle 12 Text Option help? >>>> >>>> >>>> Thomas >>>> -- >>>> ARSList mailing list >>>> ARSList@arslist.org >>>> https://mailman.rrr.se/cgi/listinfo/arslist >>> -- >>> ARSList mailing list >>> ARSList@arslist.org >>> https://mailman.rrr.se/cgi/listinfo/arslist >> >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CLOB search
If you have a CLOB, performance of searches is going to suck if doing it directly at the DB level, if it's even possibleadding FTS to the field indexes the field with a lucene index (FTS flat file), and a query against that field doesn't go to the DB, instead it does the flatfile index search, which is significantly more efficient and quicker than a db search So...yes it's avoidable if you don't want to take advantage of the things that fts gives youbut your options of improving the effort with the DB when searching a CLOB are very limited... On Fri, May 10, 2019 at 7:07 AM Thomas Miskiewicz wrote: > Is FTS avoidable? > > On May 10, 2019, at 3:03 PM, LJ LongWing wrote: > > Would FTS help you in any way? I know it would help, but the question is > are you willing to make that change. > > On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz > wrote: > >> Hi All >> >> we had to increase the size of a char field to over 4000 with huge >> performance degradation when using this field for search. >> >> Does anyone know how to heal this? Would the Oracle 12 Text Option help? >> >> >> Thomas >> -- >> ARSList mailing list >> ARSList@arslist.org >> https://mailman.rrr.se/cgi/listinfo/arslist >> > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CLOB search
Would FTS help you in any way? I know it would help, but the question is are you willing to make that change. On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz wrote: > Hi All > > we had to increase the size of a char field to over 4000 with huge > performance degradation when using this field for search. > > Does anyone know how to heal this? Would the Oracle 12 Text Option help? > > > Thomas > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CLOB search
Is FTS avoidable? > On May 10, 2019, at 3:03 PM, LJ LongWing wrote: > > Would FTS help you in any way? I know it would help, but the question is are > you willing to make that change. > > On Fri, May 10, 2019 at 6:53 AM Thomas Miskiewicz <mailto:tmisk...@gmail.com>> wrote: > Hi All > > we had to increase the size of a char field to over 4000 with huge > performance degradation when using this field for search. > > Does anyone know how to heal this? Would the Oracle 12 Text Option help? > > > Thomas > -- > ARSList mailing list > ARSList@arslist.org <mailto:ARSList@arslist.org> > https://mailman.rrr.se/cgi/listinfo/arslist > <https://mailman.rrr.se/cgi/listinfo/arslist> > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
CLOB search
Hi All we had to increase the size of a char field to over 4000 with huge performance degradation when using this field for search. Does anyone know how to heal this? Would the Oracle 12 Text Option help? Thomas -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Inconsistent FTS Search Results
Hey Kevin, We've been having some similar FTS issues, as well. We just applied a BMC Hot Fix and it looks like it fixed our issues. Not sure if it will fix yours. I've attached the readme doc so you can take a look. Good Luck! Dylan On Tue, Oct 9, 2018 at 6:03 AM wrote: > Send ARSList mailing list submissions to > arslist@arslist.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.rrr.se/cgi/listinfo/arslist > or, via email, send a message with subject or body 'help' to > arslist-requ...@arslist.org > > You can reach the person managing the list at > arslist-ow...@arslist.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of ARSList digest..." > > > Today's Topics: > > 1. Inconsistent FTS Search Results (Kevin Shaffer) >2. Re: Inconsistent FTS Search Results (LJ LongWing) >3. RE: Inconsistent FTS Search Results (Joel D Sender) > > > -- > > Message: 1 > Date: Mon, 8 Oct 2018 19:37:10 + > From: Kevin Shaffer > To: ARSList > Subject: Inconsistent FTS Search Results > Message-ID: > < > bn6pr05mb3492dbb5e442825168937649de...@bn6pr05mb3492.namprd05.prod.outlook.com > > > > Content-Type: text/plain; charset="us-ascii" > > 8.1.02 > Oracle > Solaris > Just finished a full reindex > > > When I query for a full incident number in the Global Search field from > the any console, i.e.Overview Console, sometimes it find a match and other > times it does not. For example, INC002000102345 returns a match and > INC002000102346 does not. It is not a permission issue or a tenancy issue > because I see both incidents in my console. I just cant query them both > from the Global Search field. > > What I notice is that the one that does get returned, INC002000102345, the > incident number is highlighted in the Excerpt column so I think FTS is > searching the Excerpt field not the actual incident number field. > > Has anyone seen a similar issue and is this working as expected? I would > assume that I can type any valid incident number and get a result, but > maybe not? Are there use cases that this is not true? How does the > Excerpt column in the FTS results get populated? > > TIA > Keviin > > -- next part -- > An HTML attachment was scrubbed... > URL: < > https://mailman.rrr.se/arslist/attachments/20181008/4f96fae9/attachment.html > > > > -- > > Message: 2 > Date: Mon, 8 Oct 2018 13:45:33 -0600 > From: LJ LongWing > To: arslist@arslist.org > Subject: Re: Inconsistent FTS Search Results > Message-ID: > < > canwtrtq+ukpuzdn4i3-ssn3wnmvntvsokok-evijbrsujae...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Kevin, > If you check the HPD:HelpDesk form and find the Incident Number field, if > you check the DB properties, there should be a value of 'ARticleId', or > something similar in the MSF Category field (I think that's it's > name)either way, having that value in there should populate it as the > first column in the global search column list > > On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer > wrote: > > > 8.1.02 > > > > Oracle > > > > Solaris > > > > Just finished a full reindex > > > > > > > > > > > > When I query for a full incident number in the Global Search field from > > the any console, i.e.Overview Console, sometimes it find a match and > other > > times it does not. For example, INC002000102345 returns a match and > > INC002000102346 does not. It is not a permission issue or a tenancy > issue > > because I see both incidents in my console. I just cant query them both > > from the Global Search field. > > > > > > > > What I notice is that the one that does get returned, INC002000102345, > the > > incident number is highlighted in the Excerpt column so I think FTS is > > searching the Excerpt field not the actual incident number field. > > > > > > > > Has anyone seen a similar issue and is this working as expected? I would > > assume that I can type any valid incident number and get a result, but > > maybe not? Are there use cases that this is not true? How does the > > Excerpt column in the FTS results get populated? > > > > > > > > TIA > > > > Keviin > > > > > > -- > > ARSList mailing list > > A
RE: Inconsistent FTS Search Results
Kevin, On the outside chance that LJ didn’t solve your issue, you might check to see if an active link is (occasionally) setting a field that should not be included in the search. I solved a similar issue when we discovered an A/L that, for some records, set the ‘Assigned To Group’ in the search window. HTH, Joel Joel Sender * jdsen...@earthlink.net From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: Monday, October 8, 2018 12:46 PM To: arslist@arslist.org Subject: Re: Inconsistent FTS Search Results Kevin, If you check the HPD:HelpDesk form and find the Incident Number field, if you check the DB properties, there should be a value of 'ARticleId', or something similar in the MSF Category field (I think that's it's name)either way, having that value in there should populate it as the first column in the global search column list On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer wrote: 8.1.02 Oracle Solaris Just finished a full reindex When I query for a full incident number in the Global Search field from the any console, i.e.Overview Console, sometimes it find a match and other times it does not. For example, INC002000102345 returns a match and INC002000102346 does not. It is not a permission issue or a tenancy issue because I see both incidents in my console. I just cant query them both from the Global Search field. What I notice is that the one that does get returned, INC002000102345, the incident number is highlighted in the Excerpt column so I think FTS is searching the Excerpt field not the actual incident number field. Has anyone seen a similar issue and is this working as expected? I would assume that I can type any valid incident number and get a result, but maybe not? Are there use cases that this is not true? How does the Excerpt column in the FTS results get populated? TIA Keviin -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Inconsistent FTS Search Results
Kevin, If you check the HPD:HelpDesk form and find the Incident Number field, if you check the DB properties, there should be a value of 'ARticleId', or something similar in the MSF Category field (I think that's it's name)either way, having that value in there should populate it as the first column in the global search column list On Mon, Oct 8, 2018 at 1:39 PM Kevin Shaffer wrote: > 8.1.02 > > Oracle > > Solaris > > Just finished a full reindex > > > > > > When I query for a full incident number in the Global Search field from > the any console, i.e.Overview Console, sometimes it find a match and other > times it does not. For example, INC002000102345 returns a match and > INC002000102346 does not. It is not a permission issue or a tenancy issue > because I see both incidents in my console. I just cant query them both > from the Global Search field. > > > > What I notice is that the one that does get returned, INC002000102345, the > incident number is highlighted in the Excerpt column so I think FTS is > searching the Excerpt field not the actual incident number field. > > > > Has anyone seen a similar issue and is this working as expected? I would > assume that I can type any valid incident number and get a result, but > maybe not? Are there use cases that this is not true? How does the > Excerpt column in the FTS results get populated? > > > > TIA > > Keviin > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Inconsistent FTS Search Results
8.1.02 Oracle Solaris Just finished a full reindex When I query for a full incident number in the Global Search field from the any console, i.e.Overview Console, sometimes it find a match and other times it does not. For example, INC002000102345 returns a match and INC002000102346 does not. It is not a permission issue or a tenancy issue because I see both incidents in my console. I just cant query them both from the Global Search field. What I notice is that the one that does get returned, INC002000102345, the incident number is highlighted in the Excerpt column so I think FTS is searching the Excerpt field not the actual incident number field. Has anyone seen a similar issue and is this working as expected? I would assume that I can type any valid incident number and get a result, but maybe not? Are there use cases that this is not true? How does the Excerpt column in the FTS results get populated? TIA Keviin -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
My IT search returns too many selections
Hi All. When user running search on the My IT (DWP) screen, the search is returning information for all words using 'OR' option instead of the 'AND'. As an example, if user would type something like "Configure Remedy Group", the DWP brings all services that have any of 3 of the listed words. So instead of shrinking search like people would expect (the Amazon-like), user will get expended list. If there an option or any recommendation of how to change the "OR" option into "AND" option? Thank you, Mike -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Google Chrome and Advanced Search error
Tauf, I think the issue he's dealing with is not a blocking, but a truncating.more than likely he will find that if he uses something like Fiddler to look at the backchannel calls that are being made, his Chrome is not allowing the full URL to be played out to the Mid-Tier server whereas the other browsers are, and that's what's causing the issue at hand. On Fri, Feb 9, 2018 at 3:51 PM, Tauf Chowdhury wrote: > It actually sounds like the Chrome build you are using is blocking an HTTP > request causing the 404 error. You can try disabling some security features > to see if that works. > > Sent from my iPhone > > On Feb 9, 2018, at 5:20 PM, Joel D Sender wrote: > > I usually see that message when a slow server appears to have timed-out, > or after a long period of inactivity (on my part). > > You can wait for the server to respond, or hit refresh. > > HTH, > > *Joel* > > Joel Sender * jdsen...@earthlink.net > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org > ] *On Behalf Of *Fawver, Dustin > *Sent:* Friday, February 9, 2018 1:30 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Google Chrome and Advanced Search error > > > > Greetings! > > > > I’m sending this out to see if anyone else has encountered this. Part of > what I have to do involves long strings in the Advanced Search field. > Normally this is not a problem. Recently I’ve encountered this error in > Google Chrome when trying to run a search with a string that’s a little > over 1k characters long. > > > > > > > > Firefox and MS Edge have no issues with processing the string. Before > this error occurs, there’s an empty pop-up window that hangs there for > about 5 seconds. Right now I have a single AR and Mid-Tier server, so the > load balancing things that I saw when searching wouldn’t apply. Nothing’s > changed on the server aside from Windows updates. Fortunately this really > isn’t affecting anyone else but me and of course there’s an easy workaround. > > > > Thanks! > > Dustin Fawver > > Sr. Help Desk Technician > > Information Technology Services > > > > P: 423-439-4648 <(423)%20439-4648> > > itsh...@etsu.edu > > <http://www.etsu.edu/helpdesk> > > > > > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> > Virus-free. > www.avast.com > <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> > <#m_-6331059606662127474_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Google Chrome and Advanced Search error
It actually sounds like the Chrome build you are using is blocking an HTTP request causing the 404 error. You can try disabling some security features to see if that works. Sent from my iPhone > On Feb 9, 2018, at 5:20 PM, Joel D Sender wrote: > > I usually see that message when a slow server appears to have timed-out, or > after a long period of inactivity (on my part). > You can wait for the server to respond, or hit refresh. > HTH, > Joel > Joel Sender * jdsen...@earthlink.net > > From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fawver, Dustin > Sent: Friday, February 9, 2018 1:30 PM > To: arslist@ARSLIST.ORG > Subject: Google Chrome and Advanced Search error > > Greetings! > > I’m sending this out to see if anyone else has encountered this. Part of > what I have to do involves long strings in the Advanced Search field. > Normally this is not a problem. Recently I’ve encountered this error in > Google Chrome when trying to run a search with a string that’s a little over > 1k characters long. > > > > Firefox and MS Edge have no issues with processing the string. Before this > error occurs, there’s an empty pop-up window that hangs there for about 5 > seconds. Right now I have a single AR and Mid-Tier server, so the load > balancing things that I saw when searching wouldn’t apply. Nothing’s changed > on the server aside from Windows updates. Fortunately this really isn’t > affecting anyone else but me and of course there’s an easy workaround. > > Thanks! > Dustin Fawver > Sr. Help Desk Technician > Information Technology Services > > P: 423-439-4648 > itsh...@etsu.edu > > > > Virus-free. www.avast.com > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Google Chrome and Advanced Search error
I usually see that message when a slow server appears to have timed-out, or after a long period of inactivity (on my part). You can wait for the server to respond, or hit refresh. HTH, Joel Joel Sender *<mailto:jdsen...@earthlink.net> jdsen...@earthlink.net From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fawver, Dustin Sent: Friday, February 9, 2018 1:30 PM To: arslist@ARSLIST.ORG Subject: Google Chrome and Advanced Search error Greetings! I'm sending this out to see if anyone else has encountered this. Part of what I have to do involves long strings in the Advanced Search field. Normally this is not a problem. Recently I've encountered this error in Google Chrome when trying to run a search with a string that's a little over 1k characters long. Firefox and MS Edge have no issues with processing the string. Before this error occurs, there's an empty pop-up window that hangs there for about 5 seconds. Right now I have a single AR and Mid-Tier server, so the load balancing things that I saw when searching wouldn't apply. Nothing's changed on the server aside from Windows updates. Fortunately this really isn't affecting anyone else but me and of course there's an easy workaround. Thanks! Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648 itsh...@etsu.edu <http://www.etsu.edu/helpdesk> itslogo --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Google Chrome and Advanced Search error
Greetings! I'm sending this out to see if anyone else has encountered this. Part of what I have to do involves long strings in the Advanced Search field. Normally this is not a problem. Recently I've encountered this error in Google Chrome when trying to run a search with a string that's a little over 1k characters long. [cid:image001.png@01D3A1C2.E7E1F930] Firefox and MS Edge have no issues with processing the string. Before this error occurs, there's an empty pop-up window that hangs there for about 5 seconds. Right now I have a single AR and Mid-Tier server, so the load balancing things that I saw when searching wouldn't apply. Nothing's changed on the server aside from Windows updates. Fortunately this really isn't affecting anyone else but me and of course there's an easy workaround. Thanks! Dustin Fawver Sr. Help Desk Technician Information Technology Services P: 423-439-4648 itsh...@etsu.edu [itslogo]<http://www.etsu.edu/helpdesk> -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
I am getting confused now... Apparently I did something wrong yesterday, and I am now unable to repeat all of what I stated earlier... I am now able to get two formats to work on my sv_SE locale: mm/dd/ H:MM:SS AM/PM -mm-dd HH.MM.SS I also tried, as per Jarl Grönengs suggestion, to add -Duser.language=en/sv -Duser.country=US/EN, but without any change to the result. So the question is if these are fixed formats in the Java API or if it can be controlled from outside the Java program. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 14, 2017 9:53 AM, "Misi Mladoniczky" wrote: Hi, I was not over informative of what programs I used, because I was hoping to find a general way to do this as in the Remedy C-API using env variable ARDATE. Maybe by changing the locale settings. But I am using the artools/arexport.{sh,bat} included with the server. In this case version 9.1, with the -q qualifier option set. My investigation tells me that the format is kind of flexible, but can not be controlled. The date portion is parsed as one of three depending on these delimiters, and possibly others: -mm-dd .mm.dd mm/dd/ The time portion on these delimiters: HH.MM.SS (24-hour time) H:MM:SS AM/PM (12-hour am/pm time) And this is for the parseQualification helper method and nothing else. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 14, 2017 12:03 AM, "Carl Wilson" wrote: Then the date format is taken from the AR Server format. -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of LJ LongWing Sent: 13 December 2017 22:51 To: ARSList Subject: Re: Date format in Java API search criteria The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson wrote: Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org (mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 6:01 PM, "Grooms, Frederick W" wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D
Re: Date format in Java API search criteria
Hi, I was not over informative of what programs I used, because I was hoping to find a general way to do this as in the Remedy C-API using env variable ARDATE. Maybe by changing the locale settings. But I am using the artools/arexport.{sh,bat} included with the server. In this case version 9.1, with the -q qualifier option set. My investigation tells me that the format is kind of flexible, but can not be controlled. The date portion is parsed as one of three depending on these delimiters, and possibly others: -mm-dd .mm.dd mm/dd/ The time portion on these delimiters: HH.MM.SS (24-hour time) H:MM:SS AM/PM (12-hour am/pm time) And this is for the parseQualification helper method and nothing else. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 14, 2017 12:03 AM, "Carl Wilson" wrote: Then the date format is taken from the AR Server format. -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of LJ LongWing Sent: 13 December 2017 22:51 To: ARSList Subject: Re: Date format in Java API search criteria The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson wrote: Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org (mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 6:01 PM, "Grooms, Frederick W" wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_T
RE: Date format in Java API search criteria
if this is 9.1 then you have arserverd.conf under /bin you need to define date format there. See if that helps. Sent from my Android phone using TouchDown (www.symantec.com) From: ARSList on behalf of Carl Wilson Sent: Wednesday, December 13, 2017 11:01:44 PM To: 'ARSList' Subject: RE: Date format in Java API search criteria Then the date format is taken from the AR Server format. -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: 13 December 2017 22:51 To: ARSList Subject: Re: Date format in Java API search criteria The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson mailto:carlbwil...@gmail.com>> wrote: Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList mailto:arslist@arslist.org>> Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 6:01 PM, "Grooms, Frederick W" mailto:%22Grooms,%20frederick%20w%22%20%3cfrederick.w.gro...@xo.com%3e>> wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org<mailto:mailto:arslist-boun...@arslist.org>] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList mailto:arslist@arslist.org>> Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:29 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e>> wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I
RE: Date format in Java API search criteria
BTW: where is it stated he is using a BMC provided tool in the thread, did not see that with his original question - maybe I a missing some of the thread? -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: 13 December 2017 22:51 To: ARSList Subject: Re: Date format in Java API search criteria The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson mailto:carlbwil...@gmail.com> > wrote: Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> ] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList mailto:arslist@arslist.org> > Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 6:01 PM, "Grooms, Frederick W" mailto:%22Grooms,%20frederick%20w%22%20%3cfrederick.w.gro...@xo.com%3e> > wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org <mailto:mailto:arslist-boun...@arslist.org> ] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList mailto:arslist@arslist.org> > Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:29 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e> > wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky mailto:m...@rrr.se> > wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is
RE: Date format in Java API search criteria
Then the date format is taken from the AR Server format. -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of LJ LongWing Sent: 13 December 2017 22:51 To: ARSList Subject: Re: Date format in Java API search criteria The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson mailto:carlbwil...@gmail.com> > wrote: Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org <mailto:arslist-boun...@arslist.org> ] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList mailto:arslist@arslist.org> > Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 6:01 PM, "Grooms, Frederick W" mailto:%22Grooms,%20frederick%20w%22%20%3cfrederick.w.gro...@xo.com%3e> > wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org <mailto:mailto:arslist-boun...@arslist.org> ] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList mailto:arslist@arslist.org> > Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:29 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e> > wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky mailto:m...@rrr.se> > wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable
Re: Date format in Java API search criteria
The problem here is that he's not writing a java application, he's using an existing BMC provided tool, he just wants to be able to specify the date format for his queries On Wed, Dec 13, 2017 at 3:46 PM, Carl Wilson wrote: > Hi Misi, > > When using dates in Java, I predefine the date format to use with the > following: > > > > *Declarations* > > > > *static* DateFormat *dateFormat* = *new* SimpleDateFormat("/MM/dd > HH:mm:ss"); > > > > Then when invoking, use the following to convert the date(s) correctly: > > > > Date dateLicenseDate = *dateFormat*.parse(*strLicenseDate*); > > > > Other examples: > > > > Date date = *new* Date(); > > String strDateNow = *dateFormat*.format(date); > > Date dateNow = *dateFormat*.parse(strDateNow); > > > > > > -- > > > > Kind Regards, > > > > *Carl Wilson* > > > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Misi > Mladoniczky > *Sent:* 13 December 2017 18:10 > > *To:* ARSList > *Subject:* Re: Date format in Java API search criteria > > > > Hi, > > Some further testing seems to indicate that the following different > formats always works in any combination: > > Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" > > Time portion: "23.59.59" or "11:59:59 PM" > > There might be more that works, but the question about controlling the > format still remains... > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs > Find these products, and many free tools and utilities, at http://rrr.se > > > > > December 13, 2017 6:01 PM, "Grooms, Frederick W" < > frederick.w.gro...@xo.com > <%22Grooms,%20frederick%20w%22%20%3cfrederick.w.gro...@xo.com%3e>> wrote: > > What if you do set ARDATE? > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Misi > Mladoniczky > *Sent:* Wednesday, December 13, 2017 10:46 AM > *To:* ARSList > *Subject:* Re: Date format in Java API search criteria > > Hi, > > Well, on my Ubuntu-machine it apparently defaults to the Swedish format > "-MM-DD HH:mm:ss". One of my clients using that same program are > successfully using the format "M/D/ h:mm:ss a"... > > I tried changing my LANG environment variable without success. It seems to > pick up some other system setting. > > My standard setting: > locale > LANG=sv_SE.UTF-8 > LANGUAGE=sv > LC_CTYPE="sv_SE.UTF-8" > LC_NUMERIC=sv_SE.UTF-8 > LC_TIME=sv_SE.UTF-8 > LC_COLLATE="sv_SE.UTF-8" > LC_MONETARY=sv_SE.UTF-8 > LC_MESSAGES="sv_SE.UTF-8" > LC_PAPER=sv_SE.UTF-8 > LC_NAME=sv_SE.UTF-8 > LC_ADDRESS=sv_SE.UTF-8 > LC_TELEPHONE=sv_SE.UTF-8 > LC_MEASUREMENT=sv_SE.UTF-8 > LC_IDENTIFICATION=sv_SE.UTF-8 > LC_ALL= > > I reset LC_ALL and get this, but the parseQualification still uses the > same -MM-DD format: > locale > LANG=en_US.UTF-8 > LANGUAGE=sv > LC_CTYPE="en_US.UTF-8" > LC_NUMERIC="en_US.UTF-8" > LC_TIME="en_US.UTF-8" > LC_COLLATE="en_US.UTF-8" > LC_MONETARY="en_US.UTF-8" > LC_MESSAGES="en_US.UTF-8" > LC_PAPER="en_US.UTF-8" > LC_NAME="en_US.UTF-8" > LC_ADDRESS="en_US.UTF-8" > LC_TELEPHONE="en_US.UTF-8" > LC_MEASUREMENT="en_US.UTF-8" > LC_IDENTIFICATION="en_US.UTF-8" > LC_ALL=en_US.UTF-8 > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs > Find these products, and many free tools and utilities, at http://rrr.se > > > > > December 13, 2017 5:29 PM, "LJ LongWing" <%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e>> wrote: > > okthat's a very good question that I've never had to explore.the > API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in > America (and just about nowhere else)I've never had to deal with > date/time formatting in the Java APIso sorry, I don't have a ready > answer for you :| > > On Wed, Dec 13, 2017 at 9:1
RE: Date format in Java API search criteria
Hi Misi, When using dates in Java, I predefine the date format to use with the following: Declarations static DateFormat dateFormat = new SimpleDateFormat("/MM/dd HH:mm:ss"); Then when invoking, use the following to convert the date(s) correctly: Date dateLicenseDate = dateFormat.parse(strLicenseDate); Other examples: Date date = new Date(); String strDateNow = dateFormat.format(date); Date dateNow = dateFormat.parse(strDateNow); -- Kind Regards, Carl Wilson From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Misi Mladoniczky Sent: 13 December 2017 18:10 To: ARSList Subject: Re: Date format in Java API search criteria Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 6:01 PM, "Grooms, Frederick W" mailto:%22Grooms,%20frederick%20w%22%20%3cfrederick.w.gro...@xo.com%3e> > wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org <mailto:mailto:arslist-boun...@arslist.org> ] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList mailto:arslist@arslist.org> > Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:29 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e> > wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky mailto:m...@rrr.se> > wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:11 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3E> > wrote: I'm sorry Misi, I'm not sure I understand your inq
Re: Date format in Java API search criteria
Hi, Some further testing seems to indicate that the following different formats always works in any combination: Date portion: "2017-01-31", "2017.01.31" or "01/31/2017" Time portion: "23.59.59" or "11:59:59 PM" There might be more that works, but the question about controlling the format still remains... Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 6:01 PM, "Grooms, Frederick W" wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:29 PM, "LJ LongWing" wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- AR
Re: Date format in Java API search criteria
Hi, I have tried this without being able to control it: ARDATE="%Y;%m;%d %H;%M;%S" ARDATEONLY=";MM;dd" ARTIMEONLY="HH;MM;ss" export ARDATE export ARDATEONLY export ARTIMEONLY I can supply "2016-01-31 ..." and "2016.01.31 ..." and these both works. If I use "/" it seems to interpret it in another order so the year is wrong. As for the time portion I can get "23.59.59" to work, but "23:59:59" does not work. The faulty one does not give an error but seems to default to "00:00:00". So there seems to be some "smart" things going on trying different formats before giving up. Specifying the ";" delimiter after setting the above variables does not work at all. The program I am using is the {serverinstall}/artools/arexport.sh script in 9.1.0 where you can specify a -q option to do a qualification. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 6:01 PM, "Grooms, Frederick W" wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:29 PM, "LJ LongWing" wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java
Re: Date format in Java API search criteria
Nothing changes, I tried it. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 6:01 PM, "Grooms, Frederick W" wrote: What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org (mailto:mailto:arslist-boun...@arslist.org)] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:29 PM, "LJ LongWing" wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Date format in Java API search criteria
What if you do set ARDATE? From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Wednesday, December 13, 2017 10:46 AM To: ARSList Subject: Re: Date format in Java API search criteria Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:29 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3e>> wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky mailto:m...@rrr.se>> wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se December 13, 2017 5:11 PM, "LJ LongWing" mailto:%22lj%20longwing%22%20%3clj.longw...@gmail.com%3E>> wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky mailto:m...@rrr.se>> wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
Hi, Well, on my Ubuntu-machine it apparently defaults to the Swedish format "-MM-DD HH:mm:ss". One of my clients using that same program are successfully using the format "M/D/ h:mm:ss a"... I tried changing my LANG environment variable without success. It seems to pick up some other system setting. My standard setting: locale LANG=sv_SE.UTF-8 LANGUAGE=sv LC_CTYPE="sv_SE.UTF-8" LC_NUMERIC=sv_SE.UTF-8 LC_TIME=sv_SE.UTF-8 LC_COLLATE="sv_SE.UTF-8" LC_MONETARY=sv_SE.UTF-8 LC_MESSAGES="sv_SE.UTF-8" LC_PAPER=sv_SE.UTF-8 LC_NAME=sv_SE.UTF-8 LC_ADDRESS=sv_SE.UTF-8 LC_TELEPHONE=sv_SE.UTF-8 LC_MEASUREMENT=sv_SE.UTF-8 LC_IDENTIFICATION=sv_SE.UTF-8 LC_ALL= I reset LC_ALL and get this, but the parseQualification still uses the same -MM-DD format: locale LANG=en_US.UTF-8 LANGUAGE=sv LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8 Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:29 PM, "LJ LongWing" wrote: okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky wrote: Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
okthat's a very good question that I've never had to explore.the API defaults to MM-DD- HH:MM:SS type of formatwhich is standard in America (and just about nowhere else)I've never had to deal with date/time formatting in the Java APIso sorry, I don't have a ready answer for you :| On Wed, Dec 13, 2017 at 9:15 AM, Misi Mladoniczky wrote: > Hi, > > You sort of understood. > > It concerns controlling the date+time format when the Java-API program is > calling the parseQualification method. > > In a C-API program, you just set the environment variable ARDATE before > running it, and it will use the specified format. > > So how can you control this before running a Java-API program? > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs > Find these products, and many free tools and utilities, at http://rrr.se > > > > > December 13, 2017 5:11 PM, "LJ LongWing" <%22lj%20longwing%22%20%3clj.longw...@gmail.com%3E>> wrote: > > I'm sorry Misi, I'm not sure I understand your inquiry...are you asking > how do you tell the Java api that when using the parseQualification method > what format a date, included in that string is? > On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: > > Hi, > > How do you control which date format is used by a client Java ARAPI > program when parsing the qualifier string before q query? > > In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or > similar. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs > Find these products, and many free tools and utilities, at http://rrr.se > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
Hi again, In this specific situation I could also rephrase the question. How do you know which format will be used in the parseQualification when executing a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
Hi, You sort of understood. It concerns controlling the date+time format when the Java-API program is calling the parseQualification method. In a C-API program, you just set the environment variable ARDATE before running it, and it will use the specified format. So how can you control this before running a Java-API program? Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) December 13, 2017 5:11 PM, "LJ LongWing" wrote: I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- ARSList mailing list ARSList@arslist.org (mailto:ARSList@arslist.org) https://mailman.rrr.se/cgi/listinfo/arslist (https://mailman.rrr.se/cgi/listinfo/arslist) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Date format in Java API search criteria
I'm sorry Misi, I'm not sure I understand your inquiry...are you asking how do you tell the Java api that when using the parseQualification method what format a date, included in that string is? On Wed, Dec 13, 2017 at 9:04 AM, Misi Mladoniczky wrote: > Hi, > > How do you control which date format is used by a client Java ARAPI > program when parsing the qualifier string before q query? > > In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or > similar. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs > Find these products, and many free tools and utilities, at http://rrr.se > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Date format in Java API search criteria
Hi, How do you control which date format is used by a client Java ARAPI program when parsing the qualifier string before q query? In the C-API you would set environment ARDATE="%Y-%m-%d %H:%M:%S" or similar. Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se (http://rrr.se) -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Not able to search PKE on Global Search
please can some one tell me where is this option in remedy -global search configuration. is it the backend form knowledge sources whis is refered here. rkm search dialog where settings for selecting knowledge sources and save as user preference ThanksGiri From: "Mueller, Doug" To: arslist@ARSLIST.ORG Sent: Wednesday, November 30, 2016 11:49 PM Subject: Re: Not able to search PKE on Global Search Rajesh, I am not sure what you mean by PKE so I don't know what subsystem this is. But, that is really not the critical issue here. First, I would check settings for how the fields on the form you are interested in are configured. There is a configuration for Search that can be set to FTS, MFS, or both. MFS stands for Multi-form search. If a field is only indexed for FTS, a search on the form will use FTS to search it. However, the field will not participate in a global search -- which is a multi-form search. If you want the field to be involved in a multi-form search, it must be configured for either MFS or for both MFS and FTS. This is a single configuration setting with multiple options. Check the options on all the fields of interest as it could be that none of the fields or the field that has the data you are searching for are not MFS indexed. Second, I would check the global search configuration to make sure that you have specified that ALL forms should be searched. You are allowed to specify which forms are included in a global search. So, if you have not included the PKE form in the list of forms that are being searched, that form will not be searched regardless of how indexed. You can specify that ALL forms that have MFS indexed fields should be searched. Check the configuration here to make sure that your form is included. Third, if both of the above are correctly configured, can you create a dummy entry where you put some clear string in a field that is MFS indexed and make sure that the form is included in the global search. Does it find it? If so, then if other data is not being found, you should consider reindexing that table -- maybe the index is corrupted. If that is not found, then a careful look at the flow is needed. You can turn on FTS logging to confirm that the new entry gets indexed. There are other logs where you can start tracking searches and other operations to see where things are breaking down. I would look at involving the support team to help here if you have confirmed the configuration above and tested an individual item and it still isn't finding anything. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Sent: Monday, November 28, 2016 6:19 AM To: arslist@ARSLIST.ORG Subject: Not able to search PKE on Global Search Hello Expert, I'm trying to search PKE on global search but did get any result. I m able to successfully perform global search for other items( INC, Problem, change etc...) apart from PKE. I have checked and found FTS is running without any issues. Please guide me where else can be checked for this issue. Regards, Rajesh. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Not-able-to-search-PKE-on-Global-Search-tp125068.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Not able to search PKE on Global Search
Rajesh, I am not sure what you mean by PKE so I don't know what subsystem this is. But, that is really not the critical issue here. First, I would check settings for how the fields on the form you are interested in are configured. There is a configuration for Search that can be set to FTS, MFS, or both. MFS stands for Multi-form search. If a field is only indexed for FTS, a search on the form will use FTS to search it. However, the field will not participate in a global search -- which is a multi-form search. If you want the field to be involved in a multi-form search, it must be configured for either MFS or for both MFS and FTS. This is a single configuration setting with multiple options. Check the options on all the fields of interest as it could be that none of the fields or the field that has the data you are searching for are not MFS indexed. Second, I would check the global search configuration to make sure that you have specified that ALL forms should be searched. You are allowed to specify which forms are included in a global search. So, if you have not included the PKE form in the list of forms that are being searched, that form will not be searched regardless of how indexed. You can specify that ALL forms that have MFS indexed fields should be searched. Check the configuration here to make sure that your form is included. Third, if both of the above are correctly configured, can you create a dummy entry where you put some clear string in a field that is MFS indexed and make sure that the form is included in the global search. Does it find it? If so, then if other data is not being found, you should consider reindexing that table -- maybe the index is corrupted. If that is not found, then a careful look at the flow is needed. You can turn on FTS logging to confirm that the new entry gets indexed. There are other logs where you can start tracking searches and other operations to see where things are breaking down. I would look at involving the support team to help here if you have confirmed the configuration above and tested an individual item and it still isn't finding anything. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Sent: Monday, November 28, 2016 6:19 AM To: arslist@ARSLIST.ORG Subject: Not able to search PKE on Global Search Hello Expert, I'm trying to search PKE on global search but did get any result. I m able to successfully perform global search for other items( INC, Problem, change etc...) apart from PKE. I have checked and found FTS is running without any issues. Please guide me where else can be checked for this issue. Regards, Rajesh. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Not-able-to-search-PKE-on-Global-Search-tp125068.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Not able to search PKE on Global Search
Hello Expert, I'm trying to search PKE on global search but did get any result. I m able to successfully perform global search for other items( INC, Problem, change etc...) apart from PKE. I have checked and found FTS is running without any issues. Please guide me where else can be checked for this issue. Regards, Rajesh. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Not-able-to-search-PKE-on-Global-Search-tp125068.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Relating RKM Articles To Incidents From RKM Search Results
Hello Listers, In RKM 8.1, does anyone know if there is a way to relate a RKM article to an incident from RKM search results? If not please visit our colleague's idea submissions to BMC Communities - Please go vote for my Ideas on BMC Communities: RKM and FTS search preferences: https://communities.bmc.com/ideas/14674 Relating an Knowledge Mgmt article to a record in Remedy from RKM Search https://communities.bmc.com/ideas/14676 RKM Approval Limitations: https://communities.bmc.com/ideas/14677 Please share with your team and spread the word. The more votes the more likely BMC will add these features to a future release. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: How to prioritise the Knowledge Articles while search from the Requestor Console for the End Users?
https://docs.bmc.com/docs/display/public/srm81/Displaying+popular+articles -- Kind Regards, Carl Wilson -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand Sent: 31 May 2016 08:44 To: arslist@ARSLIST.ORG Subject: Re: How to prioritise the Knowledge Articles while search from the Requestor Console for the End Users? Still waiting for the response. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: How to prioritise the Knowledge Articles while search from the Requestor Console for the End Users?
Still waiting for the response. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
How to prioritise the Knowledge Articles while search from the Requestor Console for the End Users?
Hi Experts, How to prioritize the Knowledge Articles while search for the related item from the Requester Console for the End Users? We are in ITSM 8.1 version & need to prioritize the Knowledge Articles for all searches so that when anyone " End user" as well as "Support Staff " search for the related Items then the Knowledge Articles should appear FIRST in the result list anytime. The FTS should prioritize the KA's first all in all searches then rest ex. INC...,PBM, PKE,CRQ...etc. Early response will be highly appreciated. Cheers, AA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Not able to search the recently published Knowledge Articles...
Can the RKM admin search/find the articles? If so then it sounds like a permission/visibility issue with the new articles. If RKM admin cannot search/find articles then look at server FTS logs. You might try reindexing just the RKM articles or unpublish the new articles and the republish them which should trigger FTS. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Not able to search the recently published Knowledge Articles...
Hi Experts, We are not able to search the current published KA's and even two days back published articles and there versions are not searchable. Rest all the searhc/global search are working fine but only impact is with the recent published KA's. Please provide your valuable input on the same ASAP and will be highly appreciated. Cheers, AA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: It's not enough memory to load the search results. (ARERR 9308)
So this oddly worded error was very misleading for me. It was a date only field, not a datetime with the date only displayed, but a date field. Records that didn't have a value were fine to retrieve, but any record in the search result set that had a value in that date field produced that error. Create a datetime field, transfer all your date data to it then delete it! No more date fields for me! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440)
If it is happening for valid values, I would suggest turn on SQL logging and see what's going on in the backend. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Abhi$hek Sent: Wednesday, August 12, 2015 1:05 PM To: arslist@ARSLIST.ORG Subject: Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440) ** It's happening not only for clear option but for any option On 12 Aug 2015 21:45, "Joe D'Souza" wrote: ** The (clear) option is to clear a value previously set in that field during a submit or modify transaction - not for use during a search transaction to search for NULL values. If you want to search for a null value, you would be better off using the Advanced Query Bar and specify 'Field' = $NULL$ in your search. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Candace DeCou Sent: Wednesday, August 12, 2015 7:28 AM To: arslist@ARSLIST.ORG Subject: Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440) ** Abhi - that error occurs if you inadvertently select the (clear) option from the Filter By dropdown menu. All it means is that you must select a real value from the Defined Searches - By Status area. There is also a (clear) option under both the Show and the Roles menus, but they also cannot be set to (clear) and will present another, but similar error. So why BMC has a (clear) option on 3 menus for the console where (clear) isn't allowed is beyond me, but that is what I see. As for how you are selecting a real value from the Filter By menu and then getting the error is beyond me to explain (if that is what is happening). I might guess that (clear) was selected but the value shown in the field didn't actually change to clear. I would recommend that you precisely select a real value (not the clear option) from each of the 3 menu selections on the console and check also the More Filters and make sure to Clear All there, just in case there was something making a call in that area. Hope this helps Candace On Wed, Aug 12, 2015 at 1:55 AM, Abhishek Anand wrote: Hi Experts, We are getting warning messages whenever trying out the search by filters in change management console (version 8.1). The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440). Also sometime its even not retaining the selected values from the drop down like Filter By - By Status > All Open Changes. Early response will be highly appreciated. Regards, Abhi.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440)
It's happening not only for clear option but for any option On 12 Aug 2015 21:45, "Joe D'Souza" wrote: > ** > > The (clear) option is to clear a value previously set in that field > during a submit or modify transaction – not for use during a search > transaction to search for NULL values. If you want to search for a null > value, you would be better off using the Advanced Query Bar and specify > ‘Field’ = $NULL$ in your search. > > > > Joe > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Candace DeCou > *Sent:* Wednesday, August 12, 2015 7:28 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: The Filter By menu may not be cleared, please only select > valid search filters (ARWARN 48440) > > > > ** > > Abhi - that error occurs if you inadvertently select the (clear) option > from the Filter By dropdown menu. All it means is that you must select a > real value from the Defined Searches - By Status area. There is also a > (clear) option under both the Show and the Roles menus, but they also > cannot be set to (clear) and will present another, but similar error. > > So why BMC has a (clear) option on 3 menus for the console where (clear) > isn't allowed is beyond me, but that is what I see. As for how you are > selecting a real value from the Filter By menu and then getting the error > is beyond me to explain (if that is what is happening). I might guess that > (clear) was selected but the value shown in the field didn't actually > change to clear. > > I would recommend that you precisely select a real value (not the clear > option) from each of the 3 menu selections on the console and check also > the More Filters and make sure to Clear All there, just in case there was > something making a call in that area. > > Hope this helps > > Candace > > > > On Wed, Aug 12, 2015 at 1:55 AM, Abhishek Anand > wrote: > > Hi Experts, > > > > We are getting warning messages whenever trying out the search by filters > in change management console (version 8.1). > > > > The Filter By menu may not be cleared, please only select valid search > filters (ARWARN 48440). > > Also sometime its even not retaining the selected values from the drop > down like Filter By - By Status > All Open Changes. > > > > Early response will be highly appreciated. > > > > Regards, > > Abhi.. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Weird FTS search results isse
Hi all - System = ARS/ITSM 8.1.02 with the FTS fortifications and hotfixes in place. We have a bizarre issue. I added a FTS index to CTM:People on the Corporate ID field. It is indexed for both FTS and MFS. We have incident management configured so that Customer ID is searching using the Corporate ID. Or, in other words, when you enter an ID in the Customer ID field in a new incident it searches CTM:People using the Corporate ID. That's an out of the box option. Without FTS turned on it works fine, but I have to search in all uppercase because that is how our ID's are stored. For example mine is something similar to this: GHTY78. With FTS turned on it's not working. I as an administrator can log in and it works for me. I can enter the first three characters of my ID in either upper or lower case and it returns two possible entries in the type-ahead list. If I enter the entire ID it finds only one result (which makes sense, since our ID's are unique). Howeverwhen I login to our test environment as a regular user and enter the same three characters (or even all 6) we get a message that says "The query matched more than the maximum number of entries specified for retrieval ARWARN 66". This makes zero sense, for two reasons. First, this is a test server, and the limit set in the server configuration for "Max entries returned by GetList" is at 5,000,000. That's 10X the number of records in CTM:People. Second, there should only be two matches total, or one when I enter the entire thing. Plus, an administrator should see more records than a regular user or at least the same number. Never less BMC is working on it but they have not found any results yet. It's interesting to note that there are no errors in the SQL/API/Filter logs from this, so I'm starting to think it's some kind of limit on the mid-tier. However, there's still only 1 or 2 search results, depending on how you do the test. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440)
The (clear) option is to clear a value previously set in that field during a submit or modify transaction - not for use during a search transaction to search for NULL values. If you want to search for a null value, you would be better off using the Advanced Query Bar and specify 'Field' = $NULL$ in your search. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Candace DeCou Sent: Wednesday, August 12, 2015 7:28 AM To: arslist@ARSLIST.ORG Subject: Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440) ** Abhi - that error occurs if you inadvertently select the (clear) option from the Filter By dropdown menu. All it means is that you must select a real value from the Defined Searches - By Status area. There is also a (clear) option under both the Show and the Roles menus, but they also cannot be set to (clear) and will present another, but similar error. So why BMC has a (clear) option on 3 menus for the console where (clear) isn't allowed is beyond me, but that is what I see. As for how you are selecting a real value from the Filter By menu and then getting the error is beyond me to explain (if that is what is happening). I might guess that (clear) was selected but the value shown in the field didn't actually change to clear. I would recommend that you precisely select a real value (not the clear option) from each of the 3 menu selections on the console and check also the More Filters and make sure to Clear All there, just in case there was something making a call in that area. Hope this helps Candace On Wed, Aug 12, 2015 at 1:55 AM, Abhishek Anand wrote: Hi Experts, We are getting warning messages whenever trying out the search by filters in change management console (version 8.1). The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440). Also sometime its even not retaining the selected values from the drop down like Filter By - By Status > All Open Changes. Early response will be highly appreciated. Regards, Abhi.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440)
Abhi - that error occurs if you inadvertently select the (clear) option from the Filter By dropdown menu. All it means is that you must select a real value from the Defined Searches - By Status area. There is also a (clear) option under both the Show and the Roles menus, but they also cannot be set to (clear) and will present another, but similar error. So why BMC has a (clear) option on 3 menus for the console where (clear) isn't allowed is beyond me, but that is what I see. As for how you are selecting a real value from the Filter By menu and then getting the error is beyond me to explain (if that is what is happening). I might guess that (clear) was selected but the value shown in the field didn't actually change to clear. I would recommend that you precisely select a real value (not the clear option) from each of the 3 menu selections on the console and check also the More Filters and make sure to Clear All there, just in case there was something making a call in that area. Hope this helps Candace On Wed, Aug 12, 2015 at 1:55 AM, Abhishek Anand wrote: > Hi Experts, > > > > We are getting warning messages whenever trying out the search by filters > in change management console (version 8.1). > > > > The Filter By menu may not be cleared, please only select valid search > filters (ARWARN 48440). > > Also sometime its even not retaining the selected values from the drop > down like Filter By - By Status > All Open Changes. > > > > Early response will be highly appreciated. > > > > Regards, > > Abhi.. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440)
Hi Experts, We are getting warning messages whenever trying out the search by filters in change management console (version 8.1). The Filter By menu may not be cleared, please only select valid search filters (ARWARN 48440). Also sometime its even not retaining the selected values from the drop down like Filter By - By Status > All Open Changes. Early response will be highly appreciated. Regards, Abhi.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Question on search engine for Remedy
Hi Anne, Effective Technologies, a BMC partner, did the following for searching through Remedy Data. Product Name is : Platform Advisor Description: BMC Remedy Platform Advisor Splunk application allows Remedy administrators to see what’s possible. This sample application includes searches and dashboards that show how Remedy administrators can better manage their Remedy platform with real-time data insights from their environment. In some cases we’ve leveraged DBConnect to collect critical data from within the Remedy applications that is currently difficult to monitor and manage. >> http://www.effect-tech.com/products/platform-advisor-for-remedy/ What is Does: * AR Server performance monitoring * AR Server Error and issue monitoring * AR search performance (which users are running the longest running searches, top forms searched, etc.) * User activity and license usage * Notification activity and issues * Ease of troubleshooting workflow issues (filter and escalation) when they occur Additional areas of interest we've implemented for customers include some of the following: * AR Report performance monitoring * Mid tier performance and errors * CMDB reconciliation activity and errors * AR Plugin monitoring Scott Buntin Effective Technologies | www.effect-tech.com 925-719-6560 sco...@effect-tech.com On 7/1/2015 10:23:21 AM, William Du Chene wrote: ** Why not use Apache Solr to do the job for you? If you use Solr, combine it with the freely downloadable JDBC drivers from Microsoft and you can index data in the underlying database at will. The indexing process can be controlled and it can do delta updates so your performance is not negatively impacted. With a little time spent customizing the Velocity templating, you can present a pretty usable, google-style, search interface out of the box. Similarly, Solr supports web services, so if had a developer team handy, they could create a custom web interface for you. Solr can also be configured into single installation, multi-core configuration, or a multiple node installation on a private solr cloud (using Apache Zookeeper for communications) with multiple collections (think of them as being collections of books) so that each database or application can have it's own search engine. The appliation is entirely written with Java, and I can speak from personal experience (I've built installations in both configurations to search databases, sharepoint, office documents, network shares, rss feeds, etc.) that the software runs like a mint on both Windows, or *nix platforms. Take the combination one step further and use Apache ManifoldCF, and not only can you index the web, but also file shares, office documents, sharepoint installations, other database, imap servers, etc. Add the replacement search handler that ManifoldCF has, and it can authenticate users against your internal domain before they search. Add Banana and get near real time dashboards of your server with clickable charts. And if you add logstash and lumberjack, you can also add log data from your servers into the search index. Just asking... I mean, all of these applications are open source and cost nothing, not to mention that they routinely get used in many major companies. Solr: http://lucene.apache.org/solr/ [http://lucene.apache.org/solr/] Zookeeper: http://zookeeper.apache.org/ [http://zookeeper.apache.org/] ManifoldCF: https://manifoldcf.apache.org/ [https://manifoldcf.apache.org/] MS JDBC for SQL Server: https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx [https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx] Banana: https://github.com/LucidWorks/banana [https://github.com/LucidWorks/banana] Logstash: https://github.com/LucidWorks/solrlogmanager [https://github.com/LucidWorks/solrlogmanager] On Wed, Jul 1, 2015 at 11:39 AM, Brock, Anne mailto:anne_br...@bmc.com]> wrote: ** Hi, all – I remember at WWRUG one of our partners had a very robust search engine/tool that could be used to go though Remedy data and, I think, data external to Remedy. I can’t remember the partner, of course; anyone know who it is? Apologize for vagueness, but it’s been a few years… Anne Brock Principal SC BMC Software 209-417-0481 [tel:209-417-0481] anne_br...@bmc.com [mailto:anne_br...@bmc.com] _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Question on search engine for Remedy
Why not use Apache Solr to do the job for you? If you use Solr, combine it with the freely downloadable JDBC drivers from Microsoft and you can index data in the underlying database at will. The indexing process can be controlled and it can do delta updates so your performance is not negatively impacted. With a little time spent customizing the Velocity templating, you can present a pretty usable, google-style, search interface out of the box. Similarly, Solr supports web services, so if had a developer team handy, they could create a custom web interface for you. Solr can also be configured into single installation, multi-core configuration, or a multiple node installation on a private solr cloud (using Apache Zookeeper for communications) with multiple collections (think of them as being collections of books) so that each database or application can have it's own search engine. The appliation is entirely written with Java, and I can speak from personal experience (I've built installations in both configurations to search databases, sharepoint, office documents, network shares, rss feeds, etc.) that the software runs like a mint on both Windows, or *nix platforms. Take the combination one step further and use Apache ManifoldCF, and not only can you index the web, but also file shares, office documents, sharepoint installations, other database, imap servers, etc. Add the replacement search handler that ManifoldCF has, and it can authenticate users against your internal domain before they search. Add Banana and get near real time dashboards of your server with clickable charts. And if you add logstash and lumberjack, you can also add log data from your servers into the search index. Just asking... I mean, all of these applications are open source and cost nothing, not to mention that they routinely get used in many major companies. Solr: http://lucene.apache.org/solr/ Zookeeper: http://zookeeper.apache.org/ ManifoldCF: https://manifoldcf.apache.org/ MS JDBC for SQL Server: https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx Banana: https://github.com/LucidWorks/banana Logstash: https://github.com/LucidWorks/solrlogmanager On Wed, Jul 1, 2015 at 11:39 AM, Brock, Anne wrote: > ** > > Hi, all – > > > I remember at WWRUG one of our partners had a very robust search > engine/tool that could be used to go though Remedy data and, I think, data > external to Remedy. I can’t remember the partner, of course; anyone know > who it is? > > > > Apologize for vagueness, but it’s been a few years… > > > > Anne Brock > > Principal SC > > BMC Software > > 209-417-0481 > > anne_br...@bmc.com > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Question on search engine for Remedy
Hi, all - I remember at WWRUG one of our partners had a very robust search engine/tool that could be used to go though Remedy data and, I think, data external to Remedy. I can't remember the partner, of course; anyone know who it is? Apologize for vagueness, but it's been a few years... Anne Brock Principal SC BMC Software 209-417-0481 anne_br...@bmc.com<mailto:anne_br...@bmc.com> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: CI Search Issue when viewing through Individual Class
Hi Babajan, I faced the similar kind of issue year back. The issue was the class id of these CI's were coming as blank. After fixing the same we were able to search the CI at our end. Could you please check the same for your CI's. Regards, Harsh On Wed, Jun 17, 2015 at 7:49 PM, babajan baig wrote: > ** > > Hello Team, > > > > If I search the CI's using advanced search I can able to view those CI's > under the search table. But If I try to view those CI's, system says "No > matching Critieria" > > > > But I can see those CI's in the core Base Element Class. > > > > Can anybody suggest how might be the root cause? > > > > Thanks in Advance. > > > > Regards, > > -Babajan. > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- *Thanks & regards* *“Harsh Chaudhary”* *"Impatience never commanded success**"* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
CI Search Issue when viewing through Individual Class
Hello Team, If I search the CI's using advanced search I can able to view those CI's under the search table. But If I try to view those CI's, system says "No matching Critieria" But I can see those CI's in the core Base Element Class. Can anybody suggest how might be the root cause? Thanks in Advance. Regards, -Babajan. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Adding Line feed to search menu items
Hi, When I have things like that, I like to show them in table fields instead of plain text. You create a left/right table with buttons to add/remove items. You can then store the data in a hidden character field with spaces or some other delimiter of your choise. The tables search a form where you have your possible selections stored. You probably have this already. The left table with added items has the following qualification: $Added Items$ LIKE "%" + 'ItemName' + "%" The right table with items not yet selected has the following qualification: NOT $Added Items$ LIKE "%" + 'ItemName' + "%" Two simple Active Links can add/remove items and refresh the tables. If the ItemNames are not selective enough, you can use some other unique identifier. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > I have a search menu that has over 200 possible items that can be selected. > It's set to append after each item. I'd like to format it so it looks like: > > Item1 > Item2 > > instead of: Item1 Item2... > > Has anyone don't this? > > Thanks, > > Dave > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Adding Line feed to search menu items
If your menu items don’t have spaces you can do a REPLACE as well to change them to carriage returns REPLACE($field$, " ", " ") -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, May 18, 2015 8:43 AM To: arslist@ARSLIST.ORG Subject: Re: Adding Line feed to search menu items ** David, You could do some workflow on 'Menu' that auto appends a carriage return after each linethis would leave a blank line at the end of your selection that you would need to 'clean up', maybe on loose focus...but in theory, possible. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Boylan Sent: Monday, May 18, 2015 8:25 AM To: arslist@ARSLIST.ORG Subject: Adding Line feed to search menu items I have a search menu that has over 200 possible items that can be selected. It's set to append after each item. I'd like to format it so it looks like: Item1 Item2 instead of: Item1 Item2... Has anyone don't this? Thanks, Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Adding Line feed to search menu items
David, You could do some workflow on 'Menu' that auto appends a carriage return after each linethis would leave a blank line at the end of your selection that you would need to 'clean up', maybe on loose focus...but in theory, possible. On Mon, May 18, 2015 at 7:24 AM, David Boylan wrote: > I have a search menu that has over 200 possible items that can be > selected. It's set to append after each item. I'd like to format it so it > looks like: > > Item1 > Item2 > > instead of: Item1 Item2... > > Has anyone don't this? > > Thanks, > > Dave > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Adding Line feed to search menu items
I have a search menu that has over 200 possible items that can be selected. It's set to append after each item. I'd like to format it so it looks like: Item1 Item2 instead of: Item1 Item2... Has anyone don't this? Thanks, Dave ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
Virtual servers Sent from Samsung mobile William Rentfrow wrote: ** What kind of servers are you running? Physical or virtual? William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mahmoud Mahdy-Mohamed, Vodafone Egypt Sent: Friday, October 31, 2014 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: Knowledge Management Search ** Yes I'm running in a server group, so is there special configuration to handle FTS? Sent from Samsung mobile Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Ahh that is your issue. Searching for RKM articles outside of the console requires the FTS to be indexed. There are various docs on this as well as best practices. You'll need to enable it from the AR Server config. You'll need to take into other configs if you are running in a server group. Sent from my iPhone On Oct 31, 2014, at 10:26 AM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Yes I can see it in the console and it is already published, however I didn't run FTS engine and I don't know from where I can run it. Sent from Samsung mobile Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Can you see the article in the Knowledge Console? Is it Published? If so, then it probably hasn't been indexed yet by your FTS engine. Are you running FTS indexing? On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Dears, I created a lot of knowledge articles and try to use “Knowledge Management Search” either simple nor advanced search return value, I tried all options. Note:- I’m using version 7.6.04 SP4 Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg<http://www.vodafone.com.eg/> * _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Tauf Chowdhury _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4765 / Virus Database: 4040/8433 - Release Date: 10/22/14 Internal Virus Database is out of date. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
What kind of servers are you running? Physical or virtual? William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mahmoud Mahdy-Mohamed, Vodafone Egypt Sent: Friday, October 31, 2014 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: Knowledge Management Search ** Yes I'm running in a server group, so is there special configuration to handle FTS? Sent from Samsung mobile Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Ahh that is your issue. Searching for RKM articles outside of the console requires the FTS to be indexed. There are various docs on this as well as best practices. You'll need to enable it from the AR Server config. You'll need to take into other configs if you are running in a server group. Sent from my iPhone On Oct 31, 2014, at 10:26 AM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Yes I can see it in the console and it is already published, however I didn't run FTS engine and I don't know from where I can run it. Sent from Samsung mobile Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Can you see the article in the Knowledge Console? Is it Published? If so, then it probably hasn't been indexed yet by your FTS engine. Are you running FTS indexing? On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Dears, I created a lot of knowledge articles and try to use "Knowledge Management Search" either simple nor advanced search return value, I tried all options. Note:- I'm using version 7.6.04 SP4 Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg<http://www.vodafone.com.eg/> * _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Tauf Chowdhury _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com<http://www.avg.com> Version: 2014.0.4765 / Virus Database: 4040/8433 - Release Date: 10/22/14 Internal Virus Database is out of date. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
Yes I'm running in a server group, so is there special configuration to handle FTS? Sent from Samsung mobile Tauf Chowdhury wrote: ** Ahh that is your issue. Searching for RKM articles outside of the console requires the FTS to be indexed. There are various docs on this as well as best practices. You'll need to enable it from the AR Server config. You'll need to take into other configs if you are running in a server group. Sent from my iPhone On Oct 31, 2014, at 10:26 AM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Yes I can see it in the console and it is already published, however I didn't run FTS engine and I don't know from where I can run it. Sent from Samsung mobile Tauf Chowdhury mailto:taufc...@gmail.com>> wrote: ** Can you see the article in the Knowledge Console? Is it Published? If so, then it probably hasn't been indexed yet by your FTS engine. Are you running FTS indexing? On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Dears, I created a lot of knowledge articles and try to use “Knowledge Management Search” either simple nor advanced search return value, I tried all options. Note:- I’m using version 7.6.04 SP4 Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg<http://www.vodafone.com.eg/> * _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Tauf Chowdhury _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
Ahh that is your issue. Searching for RKM articles outside of the console requires the FTS to be indexed. There are various docs on this as well as best practices. You'll need to enable it from the AR Server config. You'll need to take into other configs if you are running in a server group. Sent from my iPhone > On Oct 31, 2014, at 10:26 AM, Mahmoud Mahdy-Mohamed, Vodafone Egypt > wrote: > > ** > > Yes I can see it in the console and it is already published, however I didn't > run FTS engine and I don't know from where I can run it. > > > > Sent from Samsung mobile > > Tauf Chowdhury wrote: > ** > Can you see the article in the Knowledge Console? Is it Published? If so, > then it probably hasn't been indexed yet by your FTS engine. Are you running > FTS indexing? > >> On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt >> wrote: >> ** >> Dears, >> >> >> >> I created a lot of knowledge articles and try to use “Knowledge Management >> Search” either simple nor advanced search return value, I tried all options. >> >> Note:- I’m using version 7.6.04 SP4 >> >> >> >> Thanks, >> >> Best Regards, >> >> >> >> Mahmoud Mahdy Mohammed,PMP | Business Process Automation >> Technology | Products & Services Delivery >> Phone: +20(0)1004999638 >> Mail: mahmoud.mahdy-moha...@vodafone.com >> >> >> >> * >> >> The content of this document is classified as Vodafone Egypt S.A.E. >> Confidential and Proprietary Information. >> >> The recipient hereby is committed to hold in strict confidence the contents >> of this (e-mail, document, information) and not to disclose to any third >> party without the prior written consent of Vodafone Egypt S.A.E. Recipient >> will be held liable for any unauthorized disclosure. >> >> If you have received this message in error, please notify the sender by >> return e-mail and delete the message in its entirety, including any >> attachments. >> >> http://www.vodafone.com.eg >> >> * >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > -- > Tauf Chowdhury > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
Yes I can see it in the console and it is already published, however I didn't run FTS engine and I don't know from where I can run it. Sent from Samsung mobile Tauf Chowdhury wrote: ** Can you see the article in the Knowledge Console? Is it Published? If so, then it probably hasn't been indexed yet by your FTS engine. Are you running FTS indexing? On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt mailto:mahmoud.mahdy-moha...@vodafone.com>> wrote: ** Dears, I created a lot of knowledge articles and try to use “Knowledge Management Search” either simple nor advanced search return value, I tried all options. Note:- I’m using version 7.6.04 SP4 Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg<http://www.vodafone.com.eg/> * _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Tauf Chowdhury _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Knowledge Management Search
Can you see the article in the Knowledge Console? Is it Published? If so, then it probably hasn't been indexed yet by your FTS engine. Are you running FTS indexing? On Thu, Oct 30, 2014 at 2:47 PM, Mahmoud Mahdy-Mohamed, Vodafone Egypt < mahmoud.mahdy-moha...@vodafone.com> wrote: > ** > > Dears, > > > > I created a lot of knowledge articles and try to use “Knowledge Management > Search” either simple nor advanced search return value, I tried all options. > > Note:- I’m using version 7.6.04 SP4 > > > > *Thanks,* > > *Best Regards,* > > > > *Mahmoud Mahdy Mohammed,PMP* | Business Process Automation > *Technology | Products & Services Delivery* > *Phone:* +20(0)1004999638 > * Mail:* *mahmoud.mahdy-moha...@vodafone.com > * > > > > > * > > The content of this document is classified as Vodafone Egypt S.A.E. > Confidential and Proprietary Information. > > The recipient hereby is committed to hold in strict confidence the > contents of this (e-mail, document, information) and not to disclose to any > third party without the prior written consent of Vodafone Egypt S.A.E. > Recipient will be held liable for any unauthorized disclosure. > > If you have received this message in error, please notify the sender by > return e-mail and delete the message in its entirety, including any > attachments. > > http://www.vodafone.com.eg > > > * > > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- *Tauf Chowdhury* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Knowledge Management Search
Dears, I created a lot of knowledge articles and try to use "Knowledge Management Search" either simple nor advanced search return value, I tried all options. Note:- I'm using version 7.6.04 SP4 Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products & Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.com<mailto:mohamed.abdel-haf...@vodafone.com> * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
RESOLVED: Strange search results
Dale, That was it! Thank you so much. Have a great day! David Morrison East Tennessee State University From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Jones Sent: Wednesday, October 15, 2014 2:39 PM To: arslist@ARSLIST.ORG Subject: Re: Strange search results ** When you use the menus hidden fields are set by active links used for validation. Ie the instance id of the Asset cti is set in a hidden field This value does not match your record for some reason. (Usually a delete and recreate of the cti in question) To clean up - manually type in CTI and search. You can manually reselect cti and save each record or perform a modify all and set cti by using the menu. Take Care Dale Jones 919-523-6034 On Oct 15, 2014, at 2:08 PM, "Morrison, David A." mailto:morri...@mail.etsu.edu>> wrote: ** Good day list, Having a strange search problem. Using ARS 7.1 with SQL. Have a basic Asset form with equipment CTI. When user does a search selecting from the pull down menu, the results only show part of the assets. If you manually type the CTI in the fields, it shows all of the assets for that CTI. Any ideas? Thanks in advance. David Morrison East Tennessee State University _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Strange search results
When you use the menus hidden fields are set by active links used for validation. Ie the instance id of the Asset cti is set in a hidden field This value does not match your record for some reason. (Usually a delete and recreate of the cti in question) To clean up - manually type in CTI and search. You can manually reselect cti and save each record or perform a modify all and set cti by using the menu. Take Care Dale Jones 919-523-6034 > On Oct 15, 2014, at 2:08 PM, "Morrison, David A." > wrote: > > ** > Good day list, > > Having a strange search problem. Using ARS 7.1 with SQL. Have a basic Asset > form with equipment CTI. When user does a search selecting from the pull > down menu, the results only show part of the assets. If you manually type > the CTI in the fields, it shows all of the assets for that CTI. Any ideas? > Thanks in advance. > > David Morrison > East Tennessee State University > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Strange search results
Good day list, Having a strange search problem. Using ARS 7.1 with SQL. Have a basic Asset form with equipment CTI. When user does a search selecting from the pull down menu, the results only show part of the assets. If you manually type the CTI in the fields, it shows all of the assets for that CTI. Any ideas? Thanks in advance. David Morrison East Tennessee State University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
The same happened to me. After talking to my support vendor, we concluded that there is different behavior in FTS depending on how you loaded your articles. If you load them using UDM (DMT), then FTS picks them up right away. If you load them using AR Import, like I did, FTS never picks up the new entries. You have to "Rebuild Index" the particular source in the Manage Knowledge Source form. Try that and see if it works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Del Wester Sent: Friday, September 05, 2014 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Unable to search the published Knowledge Articles in RKM 8.1.01 Is the AR server running FTS in a server group? On Wed, Sep 3, 2014 at 9:41 PM, Mayuresh Wagh wrote: > ** > You may want to log a Issue with BMC Remedy Support. I think this > issue requires configuration check. Support should look at the > arftsindex logging for find out what's happening. > > > On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: >> >> ** >> Its 8.1.01 version. >> And not working for long. >> And its OOTB only. >> >> >> On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh >> wrote: >>> >>> ** >>> what is the AR server version & patch you have? Any fixes/hot fixes >>> applied? Was it working fine? If yes, then what are the known >>> changes made to the configuration or environment? >>> >>> >>> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: >>>> >>>> ** >>>> The concern now is that only KA's which are one day old are >>>> searchable only and recent created KA's are still not searchable. >>>> >>>> >>>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: >>>>> >>>>> Any clue on how to resolve it? >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>>> >>>>> wrote: >>>>>> >>>>>> ** >>>>>> >>>>>> It could be problem with the FTS writer server plugin performance. >>>>>> >>>>>> sent using Galaxy Nexus >>>>>> >>>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>>>> >>>>>>> ** >>>>>>> FTS is working fine as required for the old articles but not >>>>>>> working for the newly created articles. >>>>>>> And also one thing noticed that the articles which are created >>>>>>> yesterday are now searchable. >>>>>>> >>>>>>> But still the Articles which are created today are not >>>>>>> searchable as of now. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>>> >>>>>>> wrote: >>>>>>>> >>>>>>>> ** >>>>>>>> check the FTS logging to find out whether the index is created >>>>>>>> for this record or not. Also is it a server group? Is it the >>>>>>>> case Article is searchable from 1 server & not from other(s)? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi Team, >>>>>>>>> >>>>>>>>> >>>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>>> changing the status to Published. >>>>>>>>> Not able to search them in the list. >>>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>>> created were not retrieved in the list. >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Abhishek Anand >>>>>>>>> >>>>>>>>> >>>>>>>>> __ >>>>>>>>> _ UNSUBSCRIBE or access ARSlist Archives at >>>>>>>>> www.arslist.org "Where the Answers Are, and have been for 20 >>>>>>>>> years" >>>>>>>> >>>>>>>> >>>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> Abhishek Anand >>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> >> >> -- >> >> >> >> >> Regards, >> Abhishek Anand >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Hi, One more thing about QBE and the Request ID field (Field id 1). You can indeed just type ('Record Number' = 1234), and this will actually result in the following search to the database ('Record Number' = "PREFIX1234"). So if the actual prefix of your specific record matches the current prefix defined for the form, you should get a match. Kathy, it seems that you mistyped something, as you talk about both 1425, REC1425 and INC1425 at the same time. The minimum length of the number-part is 5 digits. But maybe the field you are talking about is not field id 1... I use this kind of search very often: '1' = 1234 Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Kathy, > > It was not clear from your last message whether you had the answer you needed. > > I will expand on LJ's comments. > > QBE Anywhere applies to the QBE section of the screen. That is the field > layout section or the "Query by > Example" area. The Advanced Search bar is exactly that an advanced ADDITIONAL > search to any criteria > specified in the QBE area. There are no options or qualifications there. You > must enter exactly what you > want to do in the Advanced search bar. > > If you want to find something with a partial match, you must use the LIKE > operator (that is done for you > automatically in the QBE section). > > So, your search would be > > 'Record Number' LIKE "%1234" > > The LIKE operator indicates you are doing a pattern match vs. an = which is an > exact match. When using LIKE, > you use wildcard characters to specify the pattern you want. > > 'a' LIKE "1234" > no wildcards so it is equivalent to 'a' = "1234" > > 'a' LIKE "%1234" > wildcard of % means match any 0 or more characters so anything ENDING in > 1234 would be found > > 'a' LIKE "%1234%" > wildcard of % at start and end means match anything having 1234 anywhere > in the value > > You need to use the right syntax in the Advanced query bar to accomplish what > you are looking for. > > > Now, if you have QBE set to Anywhere, you could have just put 1234 in the > Record Number field up in the > screen area and it would have found the right match for you. > > I hope this helps, > > Doug Mueller > > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris > Sent: Wednesday, September 10, 2014 8:36 AM > To: arslist@ARSLIST.ORG > Subject: Search > > ** > Hi, > > There is record in the Form A REC1425. > When I Advanced Search in the form : > > 'Record Number = 1425 (this does not work) > 'Record Number = INC1425 (this works, the record appears). > > The field is set to QBE=Anywhere. > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Kathy, It was not clear from your last message whether you had the answer you needed. I will expand on LJ's comments. QBE Anywhere applies to the QBE section of the screen. That is the field layout section or the "Query by Example" area. The Advanced Search bar is exactly that an advanced ADDITIONAL search to any criteria specified in the QBE area. There are no options or qualifications there. You must enter exactly what you want to do in the Advanced search bar. If you want to find something with a partial match, you must use the LIKE operator (that is done for you automatically in the QBE section). So, your search would be 'Record Number' LIKE "%1234" The LIKE operator indicates you are doing a pattern match vs. an = which is an exact match. When using LIKE, you use wildcard characters to specify the pattern you want. 'a' LIKE "1234" no wildcards so it is equivalent to 'a' = "1234" 'a' LIKE "%1234" wildcard of % means match any 0 or more characters so anything ENDING in 1234 would be found 'a' LIKE "%1234%" wildcard of % at start and end means match anything having 1234 anywhere in the value You need to use the right syntax in the Advanced query bar to accomplish what you are looking for. Now, if you have QBE set to Anywhere, you could have just put 1234 in the Record Number field up in the screen area and it would have found the right match for you. I hope this helps, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 8:36 AM To: arslist@ARSLIST.ORG Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
LJ is correct Advanced search overrides (ignores if you prefer) the QBE property of the field Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, September 10, 2014 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Search ** Kathy, QBE applies solely to values entered IN the field, so if your QBE is set to Anywhere, that means that you can put 1425 into the field, and it'll do an 'anywhere' search and return any results specified. When you are using the Advanced Search bar, you are specifying your own qualification, so you are saying =, which the request id doesn't =, so no results. if you want to 'replicate' the QBE in the Advanced Search using 1425, you need to specify 'Record Number LIKE "%1425%" From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 10:36 AM To: arslist@ARSLIST.ORG Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Sorry – did a copy/paste. Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, September 10, 2014 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: Search ** You can't use = with % On Wed, Sep 10, 2014 at 10:19 AM, Hennigan, Sandra mailto:sandra.henni...@usdoj.gov>> wrote: ** How about 'Record Number’ = %1425 Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 12:03 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Search ** Yes I had tried this with the double quote. In a message dated 9/10/2014 11:57:19 A.M. Eastern Daylight Time, lisa.kemes@dla.mil<mailto:lisa.kemes@dla.mil> writes: Did you try 'Record Number' = "1425" (with double quotes?) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 11:36 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
You can't use = with % On Wed, Sep 10, 2014 at 10:19 AM, Hennigan, Sandra < sandra.henni...@usdoj.gov> wrote: > ** > > How about > > 'Record Number’ = %1425 > > > > Thank you, > > > > Sandra Hennigan > > Remedy Developer > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Kathy Morris > *Sent:* Wednesday, September 10, 2014 12:03 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Search > > > > ** > > Yes I had tried this with the double quote. > > > > In a message dated 9/10/2014 11:57:19 A.M. Eastern Daylight Time, > lisa.kemes@dla.mil writes: > > Did you try 'Record Number' = "1425" (with double quotes?) > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG ] On Behalf Of Kathy > Morris > Sent: Wednesday, September 10, 2014 11:36 AM > To: arslist@ARSLIST.ORG > Subject: Search > > ** > Hi, > > There is record in the Form A REC1425. > When I Advanced Search in the form : > > 'Record Number = 1425 (this does not work) > 'Record Number = INC1425 (this works, the record appears). > > The field is set to QBE=Anywhere. > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
How about 'Record Number' = %1425 Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 12:03 PM To: arslist@ARSLIST.ORG Subject: Re: Search ** Yes I had tried this with the double quote. In a message dated 9/10/2014 11:57:19 A.M. Eastern Daylight Time, lisa.kemes@dla.mil<mailto:lisa.kemes@dla.mil> writes: Did you try 'Record Number' = "1425" (with double quotes?) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 11:36 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Yes I had tried this with the double quote. In a message dated 9/10/2014 11:57:19 A.M. Eastern Daylight Time, lisa.kemes@dla.mil writes: Did you try 'Record Number' = "1425" (with double quotes?) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 11:36 AM To: arslist@ARSLIST.ORG Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Did you try 'Record Number' = "1425" (with double quotes?) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Wednesday, September 10, 2014 11:36 AM To: arslist@ARSLIST.ORG Subject: Search ** Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Search
Kathy, QBE applies solely to values entered IN the field, so if your QBE is set to Anywhere, that means that you can put 1425 into the field, and it'll do an 'anywhere' search and return any results specified. When you are using the Advanced Search bar, you are specifying your own qualification, so you are saying =, which the request id doesn't =, so no results. if you want to 'replicate' the QBE in the Advanced Search using 1425, you need to specify 'Record Number LIKE "%1425%" On Wed, Sep 10, 2014 at 9:35 AM, Kathy Morris wrote: > ** > Hi, > > There is record in the Form A REC1425. > When I Advanced Search in the form : > > 'Record Number = 1425 (this does not work) > 'Record Number = INC1425 (this works, the record appears). > > The field is set to QBE=Anywhere. > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Search
Hi, There is record in the Form A REC1425. When I Advanced Search in the form : 'Record Number = 1425 (this does not work) 'Record Number = INC1425 (this works, the record appears). The field is set to QBE=Anywhere. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Refresh search results list programmatically
PERFORM-ACTION-TABLE-REFRESH 1020 field 1020 is the reserved id for results list...it doesn't matter if you have a field with that ID on the form, it'll cause a refresh on the results list. On Tue, Sep 9, 2014 at 2:26 PM, Ray Gellenbeck wrote: > We all know how to refresh a table field on a form via an Active Link. > > But what about refreshing a *search results list* on a regular form via an > active link as if the user had hit the "refresh" button in the results list? > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Refresh search results list programmatically
We all know how to refresh a table field on a form via an Active Link. But what about refreshing a *search results list* on a regular form via an active link as if the user had hit the "refresh" button in the results list? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Is the AR server running FTS in a server group? On Wed, Sep 3, 2014 at 9:41 PM, Mayuresh Wagh wrote: > ** > You may want to log a Issue with BMC Remedy Support. I think this issue > requires configuration check. Support should look at the arftsindex logging > for find out what's happening. > > > On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: >> >> ** >> Its 8.1.01 version. >> And not working for long. >> And its OOTB only. >> >> >> On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh >> wrote: >>> >>> ** >>> what is the AR server version & patch you have? Any fixes/hot fixes >>> applied? Was it working fine? If yes, then what are the known changes made >>> to the configuration or environment? >>> >>> >>> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: >>>> >>>> ** >>>> The concern now is that only KA's which are one day old are searchable >>>> only and recent created KA's are still not searchable. >>>> >>>> >>>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: >>>>> >>>>> Any clue on how to resolve it? >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>>> wrote: >>>>>> >>>>>> ** >>>>>> >>>>>> It could be problem with the FTS writer server plugin performance. >>>>>> >>>>>> sent using Galaxy Nexus >>>>>> >>>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>>>> >>>>>>> ** >>>>>>> FTS is working fine as required for the old articles but not working >>>>>>> for the newly created articles. >>>>>>> And also one thing noticed that the articles which are created >>>>>>> yesterday are now searchable. >>>>>>> >>>>>>> But still the Articles which are created today are not searchable as >>>>>>> of now. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>>> wrote: >>>>>>>> >>>>>>>> ** >>>>>>>> check the FTS logging to find out whether the index is created for >>>>>>>> this record or not. Also is it a server group? Is it the case Article >>>>>>>> is >>>>>>>> searchable from 1 server & not from other(s)? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi Team, >>>>>>>>> >>>>>>>>> >>>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>>> changing the status to Published. >>>>>>>>> Not able to search them in the list. >>>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>>> created were not retrieved in the list. >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Abhishek Anand >>>>>>>>> >>>>>>>>> >>>>>>>>> ___ >>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>>> >>>>>>>> >>>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> Abhishek Anand >>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> >> >> -- >> >> >> >> >> Regards, >> Abhishek Anand >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
You may want to log a Issue with BMC Remedy Support. I think this issue requires configuration check. Support should look at the arftsindex logging for find out what's happening. On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: > ** > Its 8.1.01 version. > And not working for long. > And its OOTB only. > > > On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh > wrote: > >> ** >> what is the AR server version & patch you have? Any fixes/hot fixes >> applied? Was it working fine? If yes, then what are the known changes made >> to the configuration or environment? >> >> >> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: >> >>> ** >>> The concern now is that only KA's which are one day old are searchable >>> only and recent created KA's are still not searchable. >>> >>> >>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: >>> >>>> Any clue on how to resolve it? >>>> >>>> >>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>> wrote: >>>> >>>>> ** >>>>> >>>>> It could be problem with the FTS writer server plugin performance. >>>>> >>>>> sent using Galaxy Nexus >>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>> >>>>>> ** >>>>>> FTS is working fine as required for the old articles but not working >>>>>> for the newly created articles. >>>>>> And also one thing noticed that the articles which are created >>>>>> yesterday are now searchable. >>>>>> >>>>>> But still the Articles which are created today are not searchable as >>>>>> of now. >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>> wrote: >>>>>> >>>>>>> ** >>>>>>> check the FTS logging to find out whether the index is created for >>>>>>> this record or not. Also is it a server group? Is it the case Article is >>>>>>> searchable from 1 server & not from other(s)? >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand < >>>>>>> abhi.masc...@gmail.com> wrote: >>>>>>> >>>>>>>> Hi Team, >>>>>>>> >>>>>>>> >>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>> changing the status to Published. >>>>>>>> Not able to search them in the list. >>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>> created were not retrieved in the list. >>>>>>>> >>>>>>>> >>>>>>>> Regards, >>>>>>>> Abhishek Anand >>>>>>>> >>>>>>>> >>>>>>>> ___ >>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>>> >>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> Regards, >>>>>> Abhishek Anand >>>>>> >>>>>> <http://www.vyomlabs.com/> >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> <http://www.vyomlabs.com/> >>>> >>>> >>> >>> >>> -- >>> >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> <http://www.vyomlabs.com/> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Also is it possible to add KA's in the overview console search list as it is working for rest all applications. Early response is highly appreciated. -Abhi On Wed, Sep 3, 2014 at 12:31 PM, Abhi$hek wrote: > Hi Team, > > Is there any config. in RKM:KnowledgeArticleManager form so that we can > access the KA's irrespective of the KA status. > Or any config some where else so that i can restrict the KA search in > accordance to the status of KA. > > Currently i can search only published KA and the KA is global one with > required visibility access settings. > Please help out to how can i access all the KA irrespective of its status. > > Early response will be highly appreciated. > > -Abhi > > > On Wed, Sep 3, 2014 at 11:14 AM, Abhi$hek wrote: > >> Also how can i view all the KA's of any status...draft,published...etc. >> >> Currently i can view only published KA's with having all the required >> permissions and visibility well defined. >> >> >> On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: >> >>> Its 8.1.01 version. >>> And not working for long. >>> And its OOTB only. >>> >>> >>> On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh >>> wrote: >>> >>>> ** >>>> what is the AR server version & patch you have? Any fixes/hot fixes >>>> applied? Was it working fine? If yes, then what are the known changes made >>>> to the configuration or environment? >>>> >>>> >>>> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek >>>> wrote: >>>> >>>>> ** >>>>> The concern now is that only KA's which are one day old are searchable >>>>> only and recent created KA's are still not searchable. >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek >>>>> wrote: >>>>> >>>>>> Any clue on how to resolve it? >>>>>> >>>>>> >>>>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>>>> wrote: >>>>>> >>>>>>> ** >>>>>>> >>>>>>> It could be problem with the FTS writer server plugin performance. >>>>>>> >>>>>>> sent using Galaxy Nexus >>>>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>>>> >>>>>>>> ** >>>>>>>> FTS is working fine as required for the old articles but not >>>>>>>> working for the newly created articles. >>>>>>>> And also one thing noticed that the articles which are created >>>>>>>> yesterday are now searchable. >>>>>>>> >>>>>>>> But still the Articles which are created today are not searchable >>>>>>>> as of now. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>>> > wrote: >>>>>>>> >>>>>>>>> ** >>>>>>>>> check the FTS logging to find out whether the index is created for >>>>>>>>> this record or not. Also is it a server group? Is it the case Article >>>>>>>>> is >>>>>>>>> searchable from 1 server & not from other(s)? >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand < >>>>>>>>> abhi.masc...@gmail.com> wrote: >>>>>>>>> >>>>>>>>>> Hi Team, >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>>>> changing the status to Published. >>>>>>>>>> Not able to search them in the list. >>>>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>>>> created were not retrieved in the list. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> Abhishek Anand >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> ___ >>>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>>>>> >>>>>>>>> >>>>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Regards, >>>>>>>> Abhishek Anand >>>>>>>> >>>>>>>> <http://www.vyomlabs.com/> >>>>>>>> >>>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> Regards, >>>>>> Abhishek Anand >>>>>> >>>>>> <http://www.vyomlabs.com/> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>>> >>>>> <http://www.vyomlabs.com/> >>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> >>> >>> -- >>> >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> <http://www.vyomlabs.com/> >>> >>> >> >> >> -- >> >> >> >> Regards, >> Abhishek Anand >> >> <http://www.vyomlabs.com/> >> >> > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Hi Team, Is there any config. in RKM:KnowledgeArticleManager form so that we can access the KA's irrespective of the KA status. Or any config some where else so that i can restrict the KA search in accordance to the status of KA. Currently i can search only published KA and the KA is global one with required visibility access settings. Please help out to how can i access all the KA irrespective of its status. Early response will be highly appreciated. -Abhi On Wed, Sep 3, 2014 at 11:14 AM, Abhi$hek wrote: > Also how can i view all the KA's of any status...draft,published...etc. > > Currently i can view only published KA's with having all the required > permissions and visibility well defined. > > > On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: > >> Its 8.1.01 version. >> And not working for long. >> And its OOTB only. >> >> >> On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh >> wrote: >> >>> ** >>> what is the AR server version & patch you have? Any fixes/hot fixes >>> applied? Was it working fine? If yes, then what are the known changes made >>> to the configuration or environment? >>> >>> >>> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: >>> >>>> ** >>>> The concern now is that only KA's which are one day old are searchable >>>> only and recent created KA's are still not searchable. >>>> >>>> >>>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek >>>> wrote: >>>> >>>>> Any clue on how to resolve it? >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>>> wrote: >>>>> >>>>>> ** >>>>>> >>>>>> It could be problem with the FTS writer server plugin performance. >>>>>> >>>>>> sent using Galaxy Nexus >>>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>>> >>>>>>> ** >>>>>>> FTS is working fine as required for the old articles but not working >>>>>>> for the newly created articles. >>>>>>> And also one thing noticed that the articles which are created >>>>>>> yesterday are now searchable. >>>>>>> >>>>>>> But still the Articles which are created today are not searchable as >>>>>>> of now. >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>>> wrote: >>>>>>> >>>>>>>> ** >>>>>>>> check the FTS logging to find out whether the index is created for >>>>>>>> this record or not. Also is it a server group? Is it the case Article >>>>>>>> is >>>>>>>> searchable from 1 server & not from other(s)? >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand < >>>>>>>> abhi.masc...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Hi Team, >>>>>>>>> >>>>>>>>> >>>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>>> changing the status to Published. >>>>>>>>> Not able to search them in the list. >>>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>>> created were not retrieved in the list. >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> Abhishek Anand >>>>>>>>> >>>>>>>>> >>>>>>>>> ___ >>>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>>>> >>>>>>>> >>>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> Abhishek Anand >>>>>>> >>>>>>> <http://www.vyomlabs.com/> >>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>>> >>>>> <http://www.vyomlabs.com/> >>>>> >>>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> <http://www.vyomlabs.com/> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> >> >> -- >> >> >> >> Regards, >> Abhishek Anand >> >> <http://www.vyomlabs.com/> >> >> > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Also how can i view all the KA's of any status...draft,published...etc. Currently i can view only published KA's with having all the required permissions and visibility well defined. On Wed, Sep 3, 2014 at 11:03 AM, Abhi$hek wrote: > Its 8.1.01 version. > And not working for long. > And its OOTB only. > > > On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh > wrote: > >> ** >> what is the AR server version & patch you have? Any fixes/hot fixes >> applied? Was it working fine? If yes, then what are the known changes made >> to the configuration or environment? >> >> >> On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: >> >>> ** >>> The concern now is that only KA's which are one day old are searchable >>> only and recent created KA's are still not searchable. >>> >>> >>> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: >>> >>>> Any clue on how to resolve it? >>>> >>>> >>>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>>> wrote: >>>> >>>>> ** >>>>> >>>>> It could be problem with the FTS writer server plugin performance. >>>>> >>>>> sent using Galaxy Nexus >>>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>>> >>>>>> ** >>>>>> FTS is working fine as required for the old articles but not working >>>>>> for the newly created articles. >>>>>> And also one thing noticed that the articles which are created >>>>>> yesterday are now searchable. >>>>>> >>>>>> But still the Articles which are created today are not searchable as >>>>>> of now. >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>>> wrote: >>>>>> >>>>>>> ** >>>>>>> check the FTS logging to find out whether the index is created for >>>>>>> this record or not. Also is it a server group? Is it the case Article is >>>>>>> searchable from 1 server & not from other(s)? >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand < >>>>>>> abhi.masc...@gmail.com> wrote: >>>>>>> >>>>>>>> Hi Team, >>>>>>>> >>>>>>>> >>>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>>> changing the status to Published. >>>>>>>> Not able to search them in the list. >>>>>>>> Also other related articles are searched at ease but the newly >>>>>>>> created were not retrieved in the list. >>>>>>>> >>>>>>>> >>>>>>>> Regards, >>>>>>>> Abhishek Anand >>>>>>>> >>>>>>>> >>>>>>>> ___ >>>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>>> >>>>>>> >>>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> >>>>>> >>>>>> >>>>>> Regards, >>>>>> Abhishek Anand >>>>>> >>>>>> <http://www.vyomlabs.com/> >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> <http://www.vyomlabs.com/> >>>> >>>> >>> >>> >>> -- >>> >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> <http://www.vyomlabs.com/> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Its 8.1.01 version. And not working for long. And its OOTB only. On Wed, Sep 3, 2014 at 9:58 AM, Mayuresh Wagh wrote: > ** > what is the AR server version & patch you have? Any fixes/hot fixes > applied? Was it working fine? If yes, then what are the known changes made > to the configuration or environment? > > > On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: > >> ** >> The concern now is that only KA's which are one day old are searchable >> only and recent created KA's are still not searchable. >> >> >> On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: >> >>> Any clue on how to resolve it? >>> >>> >>> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >>> wrote: >>> >>>> ** >>>> >>>> It could be problem with the FTS writer server plugin performance. >>>> >>>> sent using Galaxy Nexus >>>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>>> >>>>> ** >>>>> FTS is working fine as required for the old articles but not working >>>>> for the newly created articles. >>>>> And also one thing noticed that the articles which are created >>>>> yesterday are now searchable. >>>>> >>>>> But still the Articles which are created today are not searchable as >>>>> of now. >>>>> >>>>> >>>>> >>>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>>> wrote: >>>>> >>>>>> ** >>>>>> check the FTS logging to find out whether the index is created for >>>>>> this record or not. Also is it a server group? Is it the case Article is >>>>>> searchable from 1 server & not from other(s)? >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand < >>>>>> abhi.masc...@gmail.com> wrote: >>>>>> >>>>>>> Hi Team, >>>>>>> >>>>>>> >>>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>>> changing the status to Published. >>>>>>> Not able to search them in the list. >>>>>>> Also other related articles are searched at ease but the newly >>>>>>> created were not retrieved in the list. >>>>>>> >>>>>>> >>>>>>> Regards, >>>>>>> Abhishek Anand >>>>>>> >>>>>>> >>>>>>> ___ >>>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>>> "Where the Answers Are, and have been for 20 years" >>>>>>> >>>>>> >>>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>>> >>>>> <http://www.vyomlabs.com/> >>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> >>> >>> -- >>> >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> <http://www.vyomlabs.com/> >>> >>> >> >> >> -- >> >> >> >> Regards, >> Abhishek Anand >> >> <http://www.vyomlabs.com/> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
what is the AR server version & patch you have? Any fixes/hot fixes applied? Was it working fine? If yes, then what are the known changes made to the configuration or environment? On Tue, Sep 2, 2014 at 6:20 PM, Abhi$hek wrote: > ** > The concern now is that only KA's which are one day old are searchable > only and recent created KA's are still not searchable. > > > On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: > >> Any clue on how to resolve it? >> >> >> On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh >> wrote: >> >>> ** >>> >>> It could be problem with the FTS writer server plugin performance. >>> >>> sent using Galaxy Nexus >>> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >>> >>>> ** >>>> FTS is working fine as required for the old articles but not working >>>> for the newly created articles. >>>> And also one thing noticed that the articles which are created >>>> yesterday are now searchable. >>>> >>>> But still the Articles which are created today are not searchable as of >>>> now. >>>> >>>> >>>> >>>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>>> wrote: >>>> >>>>> ** >>>>> check the FTS logging to find out whether the index is created for >>>>> this record or not. Also is it a server group? Is it the case Article is >>>>> searchable from 1 server & not from other(s)? >>>>> >>>>> >>>>> >>>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >>>> > wrote: >>>>> >>>>>> Hi Team, >>>>>> >>>>>> >>>>>> We have created the KA in Knowledge mgmt. app. and even after >>>>>> changing the status to Published. >>>>>> Not able to search them in the list. >>>>>> Also other related articles are searched at ease but the newly >>>>>> created were not retrieved in the list. >>>>>> >>>>>> >>>>>> Regards, >>>>>> Abhishek Anand >>>>>> >>>>>> >>>>>> ___ >>>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>>> "Where the Answers Are, and have been for 20 years" >>>>>> >>>>> >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> <http://www.vyomlabs.com/> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> >> >> -- >> >> >> >> Regards, >> Abhishek Anand >> >> <http://www.vyomlabs.com/> >> >> > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
The concern now is that only KA's which are one day old are searchable only and recent created KA's are still not searchable. On Tue, Sep 2, 2014 at 1:20 PM, Abhi$hek wrote: > Any clue on how to resolve it? > > > On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh > wrote: > >> ** >> >> It could be problem with the FTS writer server plugin performance. >> >> sent using Galaxy Nexus >> On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: >> >>> ** >>> FTS is working fine as required for the old articles but not working for >>> the newly created articles. >>> And also one thing noticed that the articles which are created yesterday >>> are now searchable. >>> >>> But still the Articles which are created today are not searchable as of >>> now. >>> >>> >>> >>> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >>> wrote: >>> >>>> ** >>>> check the FTS logging to find out whether the index is created for this >>>> record or not. Also is it a server group? Is it the case Article is >>>> searchable from 1 server & not from other(s)? >>>> >>>> >>>> >>>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >>>> wrote: >>>> >>>>> Hi Team, >>>>> >>>>> >>>>> We have created the KA in Knowledge mgmt. app. and even after changing >>>>> the status to Published. >>>>> Not able to search them in the list. >>>>> Also other related articles are searched at ease but the newly created >>>>> were not retrieved in the list. >>>>> >>>>> >>>>> Regards, >>>>> Abhishek Anand >>>>> >>>>> >>>>> ___ >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> "Where the Answers Are, and have been for 20 years" >>>>> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> >>> >>> -- >>> >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> <http://www.vyomlabs.com/> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Any clue on how to resolve it? On Tue, Sep 2, 2014 at 1:11 PM, Mayuresh Wagh wrote: > ** > > It could be problem with the FTS writer server plugin performance. > > sent using Galaxy Nexus > On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: > >> ** >> FTS is working fine as required for the old articles but not working for >> the newly created articles. >> And also one thing noticed that the articles which are created yesterday >> are now searchable. >> >> But still the Articles which are created today are not searchable as of >> now. >> >> >> >> On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh >> wrote: >> >>> ** >>> check the FTS logging to find out whether the index is created for this >>> record or not. Also is it a server group? Is it the case Article is >>> searchable from 1 server & not from other(s)? >>> >>> >>> >>> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >>> wrote: >>> >>>> Hi Team, >>>> >>>> >>>> We have created the KA in Knowledge mgmt. app. and even after changing >>>> the status to Published. >>>> Not able to search them in the list. >>>> Also other related articles are searched at ease but the newly created >>>> were not retrieved in the list. >>>> >>>> >>>> Regards, >>>> Abhishek Anand >>>> >>>> >>>> ___ >>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>> "Where the Answers Are, and have been for 20 years" >>>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> >> >> -- >> >> >> >> Regards, >> Abhishek Anand >> >> <http://www.vyomlabs.com/> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
It could be problem with the FTS writer server plugin performance. sent using Galaxy Nexus On Sep 2, 2014 11:26 AM, "Abhi$hek" wrote: > ** > FTS is working fine as required for the old articles but not working for > the newly created articles. > And also one thing noticed that the articles which are created yesterday > are now searchable. > > But still the Articles which are created today are not searchable as of > now. > > > > On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh > wrote: > >> ** >> check the FTS logging to find out whether the index is created for this >> record or not. Also is it a server group? Is it the case Article is >> searchable from 1 server & not from other(s)? >> >> >> >> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >> wrote: >> >>> Hi Team, >>> >>> >>> We have created the KA in Knowledge mgmt. app. and even after changing >>> the status to Published. >>> Not able to search them in the list. >>> Also other related articles are searched at ease but the newly created >>> were not retrieved in the list. >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Also one query is that KA's are searchable only when published or else.. please respond asap...? On Tue, Sep 2, 2014 at 11:26 AM, Abhi$hek wrote: > FTS is working fine as required for the old articles but not working for > the newly created articles. > And also one thing noticed that the articles which are created yesterday > are now searchable. > > But still the Articles which are created today are not searchable as of > now. > > > > On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh > wrote: > >> ** >> check the FTS logging to find out whether the index is created for this >> record or not. Also is it a server group? Is it the case Article is >> searchable from 1 server & not from other(s)? >> >> >> >> On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand >> wrote: >> >>> Hi Team, >>> >>> >>> We have created the KA in Knowledge mgmt. app. and even after changing >>> the status to Published. >>> Not able to search them in the list. >>> Also other related articles are searched at ease but the newly created >>> were not retrieved in the list. >>> >>> >>> Regards, >>> Abhishek Anand >>> >>> >>> ___ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> "Where the Answers Are, and have been for 20 years" >>> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
FTS is working fine as required for the old articles but not working for the newly created articles. And also one thing noticed that the articles which are created yesterday are now searchable. But still the Articles which are created today are not searchable as of now. On Tue, Sep 2, 2014 at 7:10 AM, Mayuresh Wagh wrote: > ** > check the FTS logging to find out whether the index is created for this > record or not. Also is it a server group? Is it the case Article is > searchable from 1 server & not from other(s)? > > > > On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand > wrote: > >> Hi Team, >> >> >> We have created the KA in Knowledge mgmt. app. and even after changing >> the status to Published. >> Not able to search them in the list. >> Also other related articles are searched at ease but the newly created >> were not retrieved in the list. >> >> >> Regards, >> Abhishek Anand >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
check the FTS logging to find out whether the index is created for this record or not. Also is it a server group? Is it the case Article is searchable from 1 server & not from other(s)? On Mon, Sep 1, 2014 at 5:40 PM, Abhishek Anand wrote: > Hi Team, > > > We have created the KA in Knowledge mgmt. app. and even after changing the > status to Published. > Not able to search them in the list. > Also other related articles are searched at ease but the newly created > were not retrieved in the list. > > > Regards, > Abhishek Anand > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Visibility group is set fine and also FTS indexer is working fine. But still the problem exists. On Mon, Sep 1, 2014 at 6:53 PM, Tauf Chowdhury wrote: > ** > Then it's probably the visibility groups within the article or your FTS > indexer is stopped or errored out before indexing the article for searching > > Sent from my iPhone > > On Sep 1, 2014, at 9:14 AM, Abhi$hek wrote: > > ** > yes > > > On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury wrote: > >> Also, .. Can the admin see it in the KM console view? >> >> Sent from my iPhone >> >> > On Sep 1, 2014, at 8:10 AM, Abhishek Anand >> wrote: >> > >> > Hi Team, >> > >> > >> > We have created the KA in Knowledge mgmt. app. and even after changing >> the status to Published. >> > Not able to search them in the list. >> > Also other related articles are searched at ease but the newly created >> were not retrieved in the list. >> > >> > >> > Regards, >> > Abhishek Anand >> > >> > >> ___ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > "Where the Answers Are, and have been for 20 years" >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > > > > -- > > > > Regards, > Abhishek Anand > > <http://www.vyomlabs.com/> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
Then it's probably the visibility groups within the article or your FTS indexer is stopped or errored out before indexing the article for searching Sent from my iPhone > On Sep 1, 2014, at 9:14 AM, Abhi$hek wrote: > > ** > yes > > >> On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury wrote: >> Also, .. Can the admin see it in the KM console view? >> >> Sent from my iPhone >> >> > On Sep 1, 2014, at 8:10 AM, Abhishek Anand wrote: >> > >> > Hi Team, >> > >> > >> > We have created the KA in Knowledge mgmt. app. and even after changing the >> > status to Published. >> > Not able to search them in the list. >> > Also other related articles are searched at ease but the newly created >> > were not retrieved in the list. >> > >> > >> > Regards, >> > Abhishek Anand >> > >> > ___ >> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> > "Where the Answers Are, and have been for 20 years" >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" > > > > -- > > > > > Regards, > Abhishek Anand > _ARSlist: "Where the Answers Are" and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Unable to search the published Knowledge Articles in RKM 8.1.01
yes On Mon, Sep 1, 2014 at 6:02 PM, Tauf Chowdhury wrote: > Also, .. Can the admin see it in the KM console view? > > Sent from my iPhone > > > On Sep 1, 2014, at 8:10 AM, Abhishek Anand > wrote: > > > > Hi Team, > > > > > > We have created the KA in Knowledge mgmt. app. and even after changing > the status to Published. > > Not able to search them in the list. > > Also other related articles are searched at ease but the newly created > were not retrieved in the list. > > > > > > Regards, > > Abhishek Anand > > > > > ___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > "Where the Answers Are, and have been for 20 years" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > -- Regards, Abhishek Anand <http://www.vyomlabs.com/> ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"