Omega,
I've run a quick test and as I suspected the ARGetListEntryWithFields API
is used to fill the table upon refresh, and it does NOT trigger the Get
Entry filters of the entries retrieved.
If you're interested, I've attached the form & filters I used for the test.
Similar to your own requirement, the Get Entry filters will simply set a
Display type selection field called 'Color Status' to "Very Old" if the
entry was modified more than 5 minutes ago, "Old" if it was modified more
than 3 minutes ago, otherwise "New".
Load these defs then add a few entries over the course of the next 5
minutes or so. Run a normal search list and move through them entry by
entry, running a filter log, to see that the Get Entry filters do in fact
run (which is also evident since the 'Color Status' is being set).
Then refresh the table while running a filter log and you will NOT see any
of the filters being run.
I think you'll need to consider one of the other solutions.
-charlie
On Tue, Dec 9, 2014 at 4:16 AM, Omega LiPO <[email protected]> wrote:
> **
> Thanks. I knew the enable/disable filter log at server side and client.
>
> However, I did not get the time to test today. I got a weird ideas to
> use on display active link to set the fields, and will try it tmr, to see
> if it can set the display-field under the table-field. Which I think it
> might works.
>
> And will let you all knew the result. .
>
> Thank you // Omega
> ------------------------------
> From: Charlie Lotridge <[email protected]>
> Sent: 9/12/14 12:29 PM
>
> To: [email protected]
> Subject: Re: need some ideas from you how to show incidents records
> over4hrinred color.
>
> **
> Omega,
>
> Here's a link
> <https://docs.bmc.com/docs/display/public/ars81/Enabling+logs+for+performance+issues>
> to relevant documentation on server side logging. I'm not quite clear on
> what you did not get, but to be clear I do mean that you should turn on the
> filter log, refresh the table, turn off the filter log, and examine the
> results. If things are working as you want them to, then you should see
> your Get Entry filter firing once for every entry retrieved in the table.
>
> This has actually got my curiosity peaked, so I'll probably try some
> testing myself tomorrow, though do let me know what you discover (or does
> someone else already know the answer...?).
>
> Thanks,
> Charlie
>
> On Mon, Dec 8, 2014 at 2:40 PM, Omega LiPO <[email protected]> wrote:
>
>> **
>> Hi Charlie,
>>
>> How to do the filter-log ? You mean turn on the filter log. I did not get
>> it.
>>
>> Thanks,
>> Omega
>> ------------------------------
>> From: Charlie Lotridge <[email protected]>
>> Sent: 9/12/14 5:53 AM
>>
>> To: [email protected]
>> Subject: Re: need some ideas from you how to show incidents records over
>> 4hrinred color.
>>
>> **
>> Omega, run a filter log to make sure that the Get Entry filter is
>> actually firing on each entry when you load (refresh) the table. I know
>> that it'll fire when you access an individual entry on the source form
>> (which uses the ARGetEntry API), but the table data retrieval probably uses
>> the one of the APIs that retrieves multiple entries in a single call (e.g.
>> ARGetListEntryWithFields, ARGetMultipleEntries, ARGetListEntryBlocks). I'm
>> not sure if these will invoke the Get Entry filter on the individual
>> entries (and don't have time to test it myself right now).
>>
>> Hope this helps.
>>
>> -charlie
>>
>> On Mon, Dec 8, 2014 at 1:43 PM, Omega LiPO <[email protected]> wrote:
>>
>>> **
>>> I found it out this morning . And try it out. If I open the joined form,
>>> I see the color= can set to red or yellow. However, when I open the table
>>> field of such fields using display only form , the value did not show.
>>> Hmmm. I even set the filter order=0. I bet some ordering problem.
>>>
>>> Need more time to go testing tmr. Tks for your help.
>>>
>>>
>>> Regards,
>>> Omega
>>> ------------------------------
>>> From: Grooms, Frederick W <[email protected]>
>>> Sent: 9/12/14 5:26 AM
>>>
>>> To: [email protected]
>>> Subject: Re: need some ideas from you how to show incidents records
>>> over 4hrin red color.
>>>
>>> **
>>>
>>> It is just a filter set to fire on Get Entry of your form. This filter
>>> fires each time a record is pulled from the database
>>>
>>>
>>>
>>>
>>>
>>> Fred
>>>
>>>
>>>
>>> *From:* Action Request System discussion list(ARSList) [mailto:
>>> [email protected]] *On Behalf Of *Omega LiPO
>>> *Sent:* Saturday, December 06, 2014 1:38 PM
>>> *To:* [email protected]
>>> *Subject:* Re: need some ideas from you how to show incidents records
>>> over 4 hrin red color.
>>>
>>>
>>>
>>> **
>>>
>>> Hi Fred,
>>>
>>> Cool. This is what in my original ideas but I don't know this "on get
>>> filter" any quick screen dump about this on Get filter" . Haha, I *only*
>>> know to use escalation to make the running-hr growth. Which needs to check
>>> the selection-color.
>>>
>>> Probably this is my first choice of testing on Monday morning. Thank
>>> you, Fred.
>>>
>>> Regards,
>>> Omega
>>> ------------------------------
>>>
>>> *From: *Grooms, Frederick W <[email protected]>
>>> *Sent: *6/12/14 1:30 AM
>>> *To: *[email protected]
>>> *Subject: *Re: need some ideas from you how to show incidents records
>>> over 4 hrin red color.
>>>
>>> **
>>>
>>> I was about to say
>>>
>>> You know … This would be so much easier if you could use Display
>>> Only fields from the “source” or underlying form in a table field.
>>>
>>>
>>>
>>> I just realized that you can select a Display Only selection field on
>>> the source form for the Color attributes of a table field. This
>>> should mean all you have to do is to add an “on Get” filter to the source
>>> form to set your color selection field. No Escalation needed.
>>>
>>>
>>>
>>> Create Display Only fields on your source form to hold running-hr and
>>> color selection
>>>
>>> Create one or more “on Get” filters on the source form to do your
>>> calculations
>>>
>>>
>>>
>>>
>>>
>>> NOTE: I would use $SERVERTIMESTAMP$ instead of $TIMESTAMP$ so you get
>>> the exact time when the filter fires
>>>
>>>
>>>
>>> Fred
>>>
>>>
>>>
>>> *From:* Action Request System discussion list(ARSList) [
>>> mailto:[email protected] <[email protected]>] *On Behalf Of *Charlie
>>> Lotridge
>>> *Sent:* Friday, December 05, 2014 10:35 AM
>>> *To:* [email protected]
>>> *Subject:* Re: need some ideas from you how to show incidents records
>>> over 4 hr in red color.
>>>
>>>
>>>
>>> **
>>>
>>> Anyone who's read anything I've written over the past year (that I've
>>> been contributing here) knows I'm a big fan of using Remedy views over SQL
>>> views. And I've used this mechanism to implement exactly what you're
>>> looking for here, but without the table walk logic...much (much much)
>>> faster and more efficient since the database is doing all the work.
>>>
>>>
>>>
>>> In my case I wanted to implement something that showed a more typical
>>> aging ( < 30 days, 30-60 days, 60-90 days, > 90 days) but like you I wanted
>>> these differences to show as colored rows in the table. And while your
>>> requirement is to show aging measured in hours and mine is in days, the
>>> difference is irrelevant to the underlying solution.
>>>
>>>
>>>
>>> I'm not going to get into any detail here unless there's some interest
>>> that I do (it would take a bit of research & review to put it all
>>> together). I will mention, though, that the solution requires that the
>>> DB "know" the current time as a Unix epoch timestamp (and *accurately*,
>>> especially for your fine grained requirement). Of course all DB's know the
>>> current time, but accurately converting that to an epoch time (accurately!)
>>> can be a challenge.
>>>
>>>
>>>
>>> Since I use SQL Server and I'm a .NET guy, I was able to write a set of
>>> CLR stored procedures that manipulate timestamps at the DB level very
>>> quickly & efficiently, including one that returns the current time as an
>>> epoch timestamp. If you're also using SQL Server you'd be welcome to the
>>> source code for this (or even the compiled assembly if you prefer). But I
>>> don't have a comparable solution for any other DB platform.
>>>
>>>
>>>
>>> If you're interested in learning more let me know and perhaps it would
>>> be most considerate to the rest of the community to take it offline.
>>>
>>>
>>>
>>> -charlie
>>>
>>>
>>>
>>> On Thu, Dec 4, 2014 at 12:38 PM, LJ LongWing wrote:
>>>
>>> **
>>>
>>> Omega,
>>>
>>> First off, I would be careful with an auto refresh every 5 min's....as
>>> well intentioned as that is, it can come with a cost, especially if the
>>> user that has that console up is a Floating user...
>>>
>>>
>>>
>>> Second...instead of an escalation keeping track of the age...I would
>>> think about using a 'local'
>>>
>>>
> [The entire original message is not included.]
> _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"
char-set: UTF-8
#
# File exported Tue Dec 09 14:52:42 2014
#
begin schema
name : Test8
core-version : 2
upgrade-version: 0
num-fields : 15
timestamp : 1418165048
owner : Admin
last-changed : Admin
default-vui : Default Administrator View
num-vuis : 1
export-version : 12
schema-type : 1
next-field-id : 536870912
permission : 0\2
vui {
id : 536870912
name : Default Administrator View
label : Default Administrator View
timestamp : 1418164805
vui-locale :
vui-type : 1
owner : Admin
last-changed : Admin
display-prop : 1\20\4\26\Default Administrator View\
}
field {
id : 1
name : Request ID
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1418164806
owner : Admin
last-changed : Admin
length-units : 0
maxlength : 15
clob-store-opt : 0
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
permission : 0\1
permission : 3\1
display-instance :
536870912\14\3\41\2\5399\2500\28233\4600\4\6\1\7\40\2147483640\20\4\10\Request
ID\21\41\2\0\400\7086\2100\27\8\16\28\6\4\29\6\1\60\40\1\65\41\2\0\0\0\0\143\4&
display-instance : 0\4294967295\151\41\2\7649\0\22834\2100\170\40\0\231\6\1\
}
field {
id : 2
name : Submitter
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1418164806
owner : Admin
last-changed : Admin
length-units : 0
maxlength : 254
clob-store-opt : 0
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
permission : 3\1
display-instance :
536870912\16\3\41\2\6074\5000\31158\7100\4\6\1\7\40\2147483641\20\4\9\Submitter\21\41\2\0\400\6411\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\30\65\41\2\0\0\0\&
display-instance :
0\66\41\2\22722\0\25084\2100\143\40\4294967295\151\41\2\6974\0\22159\2100\170\40\0\231\6\0\
}
field {
id : 3
name : Create Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1418164806
owner : Admin
last-changed : Admin
permission : 4\1
permission : 3\1
display-instance :
536870912\16\3\41\2\5061\7500\31157\9600\4\6\1\7\40\2147483642\20\4\11\Create
Date\21\41\2\0\400\7424\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\23\65\41\2\0\0&
display-instance :
\0\0\66\41\2\23734\0\26096\2100\143\40\4294967295\151\41\2\7986\0\23171\2100\170\40\0\231\6\0\
}
field {
id : 4
name : Assigned To
datatype : 4
fieldtype : 1
create-mode : 2
option : 2
timestamp : 1418164806
owner : Admin
last-changed : Admin
length-units : 0
maxlength : 254
clob-store-opt : 0
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance :
536870912\16\3\41\2\5511\10000\31157\12100\4\6\1\7\40\2147483643\20\4\11\Assigned
To\21\41\2\0\400\6974\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\30\65\41\2\0&
display-instance :
\0\0\0\66\41\2\23284\0\25646\2100\143\40\4294967295\151\41\2\7536\0\22721\2100\170\40\0\231\6\0\
}
field {
id : 5
name : Last Modified By
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1418164806
owner : Admin
last-changed : Admin
length-units : 0
maxlength : 254
clob-store-opt : 0
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
display-instance :
536870912\16\3\41\2\2699\12500\31157\14600\4\6\1\7\40\2147483644\20\4\16\Last
Modified By\21\41\2\0\400\9786\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\33\65\4&
display-instance :
1\2\0\0\0\0\66\41\2\26096\0\28458\2100\143\40\4294967295\151\41\2\10348\0\25533\2100\170\40\0\231\6\0\
}
field {
id : 6
name : Modified Date
datatype : 7
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1418164806
owner : Admin
last-changed : Admin
permission : 4\1
display-instance :
536870912\16\3\41\2\4049\15000\31158\17100\4\6\1\7\40\2147483645\20\4\13\Modified
Date\21\41\2\0\400\8436\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\23\65\41\2&
display-instance :
\0\0\0\0\66\41\2\24746\0\27108\2100\143\40\4294967295\151\41\2\8998\0\24183\2100\170\40\0\231\6\0\
}
field {
id : 7
name : Status
datatype : 6
fieldtype : 1
create-mode : 2
option : 1
timestamp : 1418164806
owner : Admin
last-changed : Admin
enum-value : New
enum-value : Assigned
enum-value : Fixed
enum-value : Rejected
enum-value : Closed
default : 0
permission : 4\2
permission : 3\1
display-instance :
536870912\17\3\41\2\7986\17500\42406\19300\4\6\1\7\40\2147483646\20\4\6\Status\21\41\2\0\400\4499\1800\27\8\16\28\6\4\29\6\1\60\40\1\61\40\0\64\6\1\65\41\2\0&
display-instance :
\0\0\0\143\40\4294967295\151\41\2\5061\400\34419\2200\170\40\0\230\4\46\5\0\New\1\Assigned\2\Fixed\3\Rejected\4\Closed\231\6\0\
}
field {
id : 8
name : Short Description
datatype : 4
fieldtype : 1
create-mode : 1
option : 1
timestamp : 1418164806
owner : Admin
last-changed : Admin
length-units : 0
maxlength : 254
clob-store-opt : 0
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
permission : 4\1
permission : 3\1
display-instance :
536870912\16\3\41\2\1012\20000\31158\22100\4\6\1\7\40\2147483647\20\4\17\Short
Description\21\41\2\0\400\11473\2100\27\8\16\28\6\4\29\6\1\60\40\1\61\40\50\65&
display-instance :
\41\2\0\0\0\0\66\41\2\27784\0\30146\2100\143\40\4294967295\151\41\2\12035\0\27220\2100\170\40\0\231\6\0\
}
field {
id : 15
name : Status History
datatype : 4
fieldtype : 1
create-mode : 2
option : 3
timestamp : 1418164805
owner : Admin
last-changed : Admin
permission : 3\1
permission : 4\1
}
field {
id : 536870913
name : Color Status
datatype : 6
fieldtype : 1
create-mode : 1
option : 4
timestamp : 1418164806
owner : Admin
last-changed : Admin
enum-value : Very Old
enum-value : Old
enum-value : New
permission : 0\2
display-instance :
536870912\17\3\41\2\1687\24500\27446\26300\4\6\1\5\6\2\7\40\2147483648\14\40\1\20\4\12\Color
Status\21\41\2\0\400\6749\1800\60\40\1\64\6\1\143\40\4294967295\&
display-instance : 151\41\2\10686\400\25759\2200\170\40\0\230\4\24\3\0\Very
Old\1\Old\2\New\288\6\0\289\4\4\0x00\290\4\4\0x00\310\6\0\
}
field {
id : 536870914
name : Table Field
datatype : 33
fieldtype : 1
create-mode : 2
option : 4
timestamp : 1418165048
owner : Admin
last-changed : Admin
tablefield-schema : Test8
tablefield-server : @
tablefield-query : (null)
tablefield-numcols: 4
tablefield-maxret : 1000
permission : 0\2
display-instance :
536870912\28\3\41\2\45556\1500\108435\24600\4\6\1\5\6\2\7\40\2147483649\14\40\1\20\4\11\Table
Field\40\41\4\45556\1500\108435\1500\108435\24600\45556\24600\1&
display-instance :
43\40\4294967295\170\40\0\216\4\28\536870913\2\1\255\2\16711680\224\40\1\226\6\0\227\6\1\5001\6\0\5006\4\10\Next
Chunk\5007\4\14\Previous Chunk\5008\4\2&
display-instance : 5\Table has not been loaded\5009\4\18\{2} of {3}
results\5013\4\10\Select All\5014\4\12\DeSelect
All\5015\4\7\Refresh\5016\4\6\Report\5023\6\0\5060\4\11&
display-instance :
\Preferences\5067\6\0\5068\4\17\536870913\1\0\255\5121\6\0\5212\6\0\
}
field {
id : 536880912
name : Column
datatype : 34
fieldtype : 1
create-mode : 2
option : 4
timestamp : 1418165048
owner : Admin
last-changed : Admin
colfield-parent : 536870914
colfield-datafield: 8
colfield-collength: 254
colfield-datasrc : 0
permission : 0\2
display-instance : 536870912\7\3\41\2\0\0\10011\0\4\6\1\20\4\17\Short
Description\220\40\10000\221\40\1\5021\6\0\5204\2\0\
}
field {
id : 536880913
name : Column2
datatype : 34
fieldtype : 1
create-mode : 2
option : 4
timestamp : 1418165048
owner : Admin
last-changed : Admin
colfield-parent : 536870914
colfield-datafield: 1
colfield-collength: 254
colfield-datasrc : 0
permission : 0\2
display-instance : 536870912\7\3\41\2\0\0\10011\0\4\6\1\20\4\10\Request
ID\220\40\10000\221\40\2\5021\6\0\5204\2\0\
}
field {
id : 536880914
name : Column3
datatype : 34
fieldtype : 1
create-mode : 2
option : 4
timestamp : 1418165048
owner : Admin
last-changed : Admin
colfield-parent : 536870914
colfield-datafield: 536870913
colfield-collength: 254
colfield-datasrc : 1
permission : 0\2
display-instance : 536870912\7\3\41\2\0\0\10011\0\4\6\1\20\4\12\Color
Status\220\40\10000\221\40\4\5021\6\0\5204\2\0\
}
field {
id : 536880915
name : Column4
datatype : 34
fieldtype : 1
create-mode : 2
option : 4
timestamp : 1418165048
owner : Admin
last-changed : Admin
colfield-parent : 536870914
colfield-datafield: 6
colfield-collength: 254
colfield-datasrc : 0
permission : 0\2
display-instance : 536870912\6\3\41\2\0\0\10011\0\4\6\1\20\4\13\Modified
Date\220\40\10000\221\40\3\5021\6\0\
}
end
begin filter
name :
TEST8:500OnGetEntry:IfMoreThan5MinutesSinceChangedThenVeryOld
timestamp : 1418165015
owner : Admin
last-changed : Admin
filter-op : 1
enable : 1
filter-order : 500
wk-conn-type : 1
schema-name : Test8
export-version : 12
filter-query : 4\2\3\2\2\1\2\99\6\2\2\300\
action {
set-field : 0\536870913\101\6\0\
}
errhandler-opt : 0
end
begin filter
name : TEST8:510OnGetEntry:IfMoreThan3MinutesSinceChangedThenOld
timestamp : 1418165473
owner : Admin
last-changed : Admin
filter-op : 1
enable : 1
filter-order : 510
wk-conn-type : 1
schema-name : Test8
export-version : 12
filter-query : 1\4\2\3\2\2\1\2\99\6\2\2\180\4\5\3\2\2\1\2\99\6\2\2\300\
action {
set-field : 0\536870913\101\6\1\
}
errhandler-opt : 0
end
begin filter
name : TEST8:520OnGetEntry:IfLessThan3MinutesSinceChangedThenNew
timestamp : 1418165148
owner : Admin
last-changed : Admin
filter-op : 1
enable : 1
filter-order : 520
wk-conn-type : 1
schema-name : Test8
export-version : 12
filter-query : 4\5\3\2\2\1\2\99\6\2\2\180\
action {
set-field : 0\536870913\101\6\2\
}
errhandler-opt : 0
end
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
