Hi Joe,
Thanks for your valuable info.
I have wrote 2 filters. 1st filter showing below. Run if empty and set
field I mentioned below qualification 'Long group name' =$Support
Company$+-+$Assignee organization$+-+$Assignee Group$ and auto map
table declared as temp =group I'd from group form.
Hi Tony,
I have a client that runs a non-unicode DB on Oracle due to legacy reasons.
There are currently no plans to switch over as the general feeling is that
they do not stand to gain anything by doing so as their system is custom
built and only used in one timezone one language - English
Tony,
my customer is on 8.1 non-unicode server and the only REASON is
that the previous versions of ARS were non-Unicode. Customer wants Unicode
and hopefully when we upgrade next time, i expect a easier path to move
from a non-Unicode server to Unicode server.
Thanks,
Samir
On Tue,
Hi,
The only reason I can see for this is something I said in one of the other
zillion messages to this thread.
When you have anything but 'TR.Field' in the run-if clauses of filters, the
system will do a fetch of that fields DB-value before the filters are
processed.
So it could be a
Hi Randeep Misi,
I've performed a few tests and confirmed your propositions that the 'DB.'
construct causes a DB read. In a SQL log I can see a DB read before the
UPDATE only when I have a 'DB.' filter active (but not when I just have one
using 'TR.').
This is interesting and something I wasn't
Misi,
In regards to the argument that using TR values improves performance... if
the performance gain was measurable, then the logical extension of that
would be to re-engineer the Run-IFs of every filter in the system so that
they all use a TR value to avoid that database read. There is a long
Hi,
Just note that 'Field' and 'DB.Field' will cause exactly the same result. This
is because the 'Field' (most current value) will need to know the DB value to
work.
Best Regards - Misi, RRR AB, http://rrr.se
Hi Randeep Misi,
I've performed a few tests and confirmed your
Hi,
As discussed earlier, the TR-values are not foolproof to find a change.
Because of this you cant just redesign to use TR-values instead of 'DB.Field'
and 'Field' (Most Current) values.
Best Regards - Misi, RRR AB, http://rrr.se
Misi,
In regards to the argument that using TR
Totally agree with Misi. Putting all together in simple way
TR - Holds only transaction values coming from API or remedy workflow
DB - Holds the values present in database
Just a field - Checks the value changes/entered by user and if it is blank, a
check is made against database values.
Hope
Anybody help me in understanding this statement? Why is it read-only?
//docs.bmc(dot)com/docs/display/public/ars81/Table+fields
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and
Sweety,
I'm unsure why that statement is even in therebut data in ALL table
fields is read onlythe fact that some fields can be set as 'editable'
doesn't make it actually editable, you still need to loop through the table
and push values to the DB
What is your concern about that
Statement says, Data in server-side table fields is read-only? What does it
means? I can edit the record in a table by editing a record existing in a form
which is refering to the table.
It just says server side table field is ready-only, does it mean client side
table field is writable?
The statement is to allow a developer to create filter workflow that would
allow for the concept of walking a table field without having to create the
table field on the form and using Active Links to walk it.
-Original Message-
From: LJ LongWing lj.longw...@gmail.com
To: arslist
I have not said that I want to create a table field at all. It says data is
read only. Why I cannot update the data in server side table? I do not
understant the statement Data in server-side table fields is read-only. Make
me understand it please.
Hi folks, I am working with a legacy custom application on my ARS 7.0.1 system
(Oracle 10 back-end) where the initial developer created a Price field as a
decimal field. My problem is that now we are integrating this form with the
CMDB (ITSM 7.0.03) and I need to get that data into a currency
**
Check out the database Ref document for 7.0I recall that for currency fields, there are four columns that need updating. Value, Code, Date of conversion and value for the supported currencies.They all use the same field id with special suffixes, so it will be tricky with sql but ou could set it
Sweety
Are you using Chrome or IE as your browser?
I find the site to only support Chrome.
Phil
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sweety
Sent: Monday, May 19, 2014 3:05 PM
To:
Thanks Randeep, I only saw three fields in the DB associated with my new Cost
field: CostC (currency type such as USD), CostV (the numeric value) and CostD
(epoch time). That must be because I was lazy and was looking at the view
instead of the table itself. Once I looked directly at the table
**
I'd suggest just adding a record or updating one from the user tool with sql logging turned on and reverse engineer it from there once you see how AR is doing it.Hope this helpsRandeep
**
Sent from my BlackBerry 10
Hello Everyone,
ARSKit.com introduces new feature Field Usages to identify the usages of
field from remedy log.
Watch 5 minutes of Video tutorial (download it
nowhttp://arskit.com/download.php?filename=ARSKitRemedyLogAnalyzer_FieldUsages_Video.zip)
on how difficult it is to identify field usages
21 matches
Mail list logo