Hi,
As Joe indicates, the $LASTID$ is not useful for what you want.
The question is how you want to use it. Why do you need the Request ID in a
separate field?
One scenario would be if you want to create related records with the Request
ID as key. The solution is to do a Push-Fields and use the actual $1$ (Request
ID) as value.
Another one I have seen is when you want to have a stripped version of the
Request ID, without leading zeros, in a separate field. The solution I saw
also used Push-Fields:
FLTR
Push-Fields: To the same schema
Qual: ('1' = $1$)
MyField = $1$
This will create an update immediately following the create of the record,
which will update 'MyField' with the contents of the $1$ (Request ID) field.
Note however that you might need to ensure that a bunch of Modify-filters does
not fire by mistake...
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12):
* 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.
> The LASTID is the ID that is in the thread at the time the thread is
> committing the transaction to the database. So it may not be the same when
> you are trying to display it as opposed to when you are actually committing
> the transaction, as there might have been a search or something between that
> time and the commit and the LASTID will have the ID of the last record that
> was referenced before the commit.
>
>
>
> Joe
>
>
>
> _____
>
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of sriram pm
> Sent: Saturday, September 21, 2013 2:24 PM
> To: [email protected]
> Subject: Capturing the $LASTID$ in a Field using Filters
>
>
>
> **
>
> Hi All,
>
>
>
> I am trying to Capture the $LASTID$ using a Filter.
>
>
>
> I am able to display the $LASTID$ using a Filter but when I try to assign
> the value to a Character Field I get some different set of numbers stored in
> it.
>
>
>
> Is there any work-around to assign the value to a field using a Filter?
>
>
>
> Kindly check and advice.
>
>
>
> Thank you,
>
> Sriram
>
>
> _______________________________________________________________________________
> 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"
