*Hi Luksha Timothy,*
It's true that Request ID is the only implicitely indexed field in Remedy.
But,in form properties,what is the status of "Indexes" ?Are there any
fields indexed?Check that also.
There may be work flows related to "Direct SQL" action or "SQL Query in
set fields" action in which primary key may be configered.
Hope this helps...
Regards,
*
Sandeep
Vyom Labs Pvt. Ltd.
An ISO 20000 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
*
Luksha, Timothy wrote:
I was recently asked to check which columns of one of our remedy forms
were indexed. The documentation gave me the impression that only
"Request Id" would be indexed automatically, which makes sense since it
is the primary key. Remedy administrator indicated that two other
columns had indexes. When I looked at the Oracle table in a database
tool I have, there were four indexes listed. The one that wasn't
appearing in remedy administrator mapped to the "Date Submitted" field.
Does this simply indicate that someone added the index through Oracle
without asking remedy to create it or is something more funny going on?
Thanks,
Tim
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
