Re: Status Reason field values in API

2013-11-26 Thread Sweety
Hello Misi I did as you suggested but I am getting the error. Failure during SQL operation to the database;Invalid column name 'C15'.(SQL Server 207) I have adding like this entryListFieldList.AddField(15, 150, ) like other fields but getting error for only this field. I fee this field does

Re: Status Reason field values in API

2013-11-26 Thread Misi Mladoniczky
Hi, My guess is that you need to get it using a GetEntry-call instead of the GetListEntry-call. The GetListEntry-call can not return unlimited length fields, and the code on the Remedy-side might not be designed to work with field 15. So the solution is GetEntry/GetMultipleEntries instead of

Re: Status Reason field values in API

2013-11-26 Thread SUBSCRIBE arslist Sweety
GetEntry worked. Thanks Misi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years

Re: Status Reason field values in API

2013-11-25 Thread Misi Mladoniczky
Hi, That would be the Status-History field. It always has field id 15. Just get data for that field, and you have the information. You will get all data combined in a single character string, and you need to decode this string. In the C-API there is a helper function called

Re: Status Reason field values in API

2013-11-25 Thread Sweety
Thanks Misi for your inputs. I will fetch the data and do the string manipulation on it but curious to know if other APIs also have ARStatusHistoryList like JAVA and .Net ? ___ UNSUBSCRIBE or access ARSlist Archives at

Re: Status Reason field values in API

2013-11-25 Thread Misi Mladoniczky
Hi, The Java API certainly has classes to deal with this. The .Net API should have similar methods and classes. Otherwise it is just a matter of splitting the string first on chr(3) and you will get each value-pair (User/Timestamp), and then split each entry again on chr(4). The result is a

Re: Status Reason field values in API

2013-11-24 Thread Roger Justice
, Nov 24, 2013 1:10 pm Subject: Status Reason field values in API Hello List, I want to fetch the specific values from status reason field like time when the status changed or the user who changed the status. Could you please guide me how to do this ? See the screenshot attached, it may tell