Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



help with Calendars

From: therron (2015-09-08 06:10)


Hi all,

We're dabbling with Calendars for the first time. Wondering if you can help me with a couple of difficulties I'm having:

1) In Calendars, on the Work Periods tab, I want to set a default table filter to show only work periods greater-than-or-equal-to today. But it needs to be easy for the users to remove in case they need to see past work periods, so the best acceptable solution I can think of is just to make the Table Control's filter row be prepopulated with a >= <today's date>, but I can't figure out how to make it dynamically do that. It seems like the Default Value controls can only accept a static value. Anyone know if it is possible? The only other idea I can think of would be to add another attribute to the table, something like IS_PAST, as a YORN field, and run an Escalation every day to mark yesterday's Work Periods as Y, and set a default value control query filter so show IS_PAST = N.

2) Each Person is only going to have one Calendar. I tried making a read-only copy of the Calendar and the Work Periods tabs and placing them as newly-created tabs in the Person app. After adjusting Relationships for the controls, I got everything working except the Wall Calendar control wouldn't display data. Anyone ever tried this and/or know what I may have done incorrectly?

Travis Herron


From: Pat Morrow (2015-09-08 10:36)

Use sysdate (if using Oracle) instead of a static date. You can also do date arithmetic with it, (i.e use >= sysdate - 7 for anything later than one week ago).
Pat Morrow
pmorrow8@yahoo.com
--------------------------------------------
On Tue, 9/8/15, therron@pcci.edu [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
Subject: [MAXIMO List] help with Calendars
To: MAXIMO@yahoogroups.com
Date: Tuesday, September 8, 2015, 7:10 AM


 











Hi all,





We're dabbling with Calendars for the first time.
Wondering if you can help me with a couple of difficulties
I'm having:





1) In Calendars, on the Work Periods tab, I want to set a
default table filter to show only work periods
greater-than-or-equal-to today. But it needs to be easy for
the users to remove in case they need to see past work
periods, so the best acceptable solution I can think of is
just to make the Table Control's filter row be
prepopulated with a >= <today's date>, but I
can't figure out how to make it dynamically do that. It
seems like the Default Value controls can only accept a
static value. Anyone know if it is possible? The only
other idea I can think of would be to add another attribute
to the table, something like IS_PAST, as a YORN field, and
run an Escalation every day to mark yesterday's Work
Periods as Y, and set a default value control query filter
so show IS_PAST = N.





2) Each Person is only going to have one Calendar. I tried
making a read-only copy of the Calendar and the Work Periods
tabs and placing them as newly-created tabs in the Person
app. After adjusting Relationships for the controls, I got
everything working except the Wall Calendar control
wouldn't display data. Anyone ever tried this and/or
know what I may have done incorrectly?





Travis Herron

















#yiv4464962481 #yiv4464962481 --
#yiv4464962481ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv4464962481 #yiv4464962481ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv4464962481 #yiv4464962481ygrp-mkp #yiv4464962481hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv4464962481 #yiv4464962481ygrp-mkp #yiv4464962481ads {
margin-bottom:10px;}

#yiv4464962481 #yiv4464962481ygrp-mkp .yiv4464962481ad {
padding:0 0;}

#yiv4464962481 #yiv4464962481ygrp-mkp .yiv4464962481ad p {
margin:0;}

#yiv4464962481 #yiv4464962481ygrp-mkp .yiv4464962481ad a {
color:#0000ff;text-decoration:none;}
#yiv4464962481 #yiv4464962481ygrp-sponsor
#yiv4464962481ygrp-lc {
font-family:Arial;}

#yiv4464962481 #yiv4464962481ygrp-sponsor
#yiv4464962481ygrp-lc #yiv4464962481hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv4464962481 #yiv4464962481ygrp-sponsor
#yiv4464962481ygrp-lc .yiv4464962481ad {
margin-bottom:10px;padding:0 0;}

#yiv4464962481 #yiv4464962481actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv4464962481 #yiv4464962481activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv4464962481 #yiv4464962481activity span {
font-weight:700;}

#yiv4464962481 #yiv4464962481activity span:first-child {
text-transform:uppercase;}

#yiv4464962481 #yiv4464962481activity span a {
color:#5085b6;text-decoration:none;}

#yiv4464962481 #yiv4464962481activity span span {
color:#ff7900;}

#yiv4464962481 #yiv4464962481activity span
.yiv4464962481underline {
text-decoration:underline;}

#yiv4464962481 .yiv4464962481attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv4464962481 .yiv4464962481attach div a {
text-decoration:none;}

#yiv4464962481 .yiv4464962481attach img {
border:none;padding-right:5px;}

#yiv4464962481 .yiv4464962481attach label {
display:block;margin-bottom:5px;}

#yiv4464962481 .yiv4464962481attach label a {
text-decoration:none;}

#yiv4464962481 blockquote {
margin:0 0 0 4px;}

#yiv4464962481 .yiv4464962481bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv4464962481 .yiv4464962481bold a {
text-decoration:none;}

#yiv4464962481 dd.yiv4464962481last p a {
font-family:Verdana;font-weight:700;}

#yiv4464962481 dd.yiv4464962481last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv4464962481 dd.yiv4464962481last p
span.yiv4464962481yshortcuts {
margin-right:0;}

#yiv4464962481 div.yiv4464962481attach-table div div a {
text-decoration:none;}

#yiv4464962481 div.yiv4464962481attach-table {
width:400px;}

#yiv4464962481 div.yiv4464962481file-title a, #yiv4464962481
div.yiv4464962481file-title a:active, #yiv4464962481
div.yiv4464962481file-title a:hover, #yiv4464962481
div.yiv4464962481file-title a:visited {
text-decoration:none;}

#yiv4464962481 div.yiv4464962481photo-title a,
#yiv4464962481 div.yiv4464962481photo-title a:active,
#yiv4464962481 div.yiv4464962481photo-title a:hover,
#yiv4464962481 div.yiv4464962481photo-title a:visited {
text-decoration:none;}

#yiv4464962481 div#yiv4464962481ygrp-mlmsg
#yiv4464962481ygrp-msg p a span.yiv4464962481yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv4464962481 .yiv4464962481green {
color:#628c2a;}

#yiv4464962481 .yiv4464962481MsoNormal {
margin:0 0 0 0;}

#yiv4464962481 o {
font-size:0;}

#yiv4464962481 #yiv4464962481photos div {
float:left;width:72px;}

#yiv4464962481 #yiv4464962481photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv4464962481 #yiv4464962481photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv4464962481 #yiv4464962481reco-category {
font-size:77%;}

#yiv4464962481 #yiv4464962481reco-desc {
font-size:77%;}

#yiv4464962481 .yiv4464962481replbq {
margin:4px;}

#yiv4464962481 #yiv4464962481ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg select,
#yiv4464962481 input, #yiv4464962481 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg pre, #yiv4464962481
code {
font:115% monospace;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg * {
line-height:1.22em;}

#yiv4464962481 #yiv4464962481ygrp-mlmsg #yiv4464962481logo {
padding-bottom:10px;}


#yiv4464962481 #yiv4464962481ygrp-msg p a {
font-family:Verdana;}

#yiv4464962481 #yiv4464962481ygrp-msg
p#yiv4464962481attach-count span {
color:#1E66AE;font-weight:700;}

#yiv4464962481 #yiv4464962481ygrp-reco
#yiv4464962481reco-head {
color:#ff7900;font-weight:700;}

#yiv4464962481 #yiv4464962481ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv4464962481 #yiv4464962481ygrp-sponsor #yiv4464962481ov
li a {
font-size:130%;text-decoration:none;}

#yiv4464962481 #yiv4464962481ygrp-sponsor #yiv4464962481ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv4464962481 #yiv4464962481ygrp-sponsor #yiv4464962481ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv4464962481 #yiv4464962481ygrp-text {
font-family:Georgia;}

#yiv4464962481 #yiv4464962481ygrp-text p {
margin:0 0 1em 0;}

#yiv4464962481 #yiv4464962481ygrp-text tt {
font-size:120%;}

#yiv4464962481 #yiv4464962481ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4464962481


From: therron (2015-09-09 05:52)

Pat,

I know how to do that kind of thing in the back-end; I need it in the UI. Using Application Designer, dropping in a Default Value control on the table, and giving it a value of &SYSDATE& or sysdate or getdate() aren't working for me.

Travis Herron


From: peter.males (2015-09-09 07:17)

Hi,
Might be easiest to set up a saved public query, to filter on the dates,
Then set this as the default query for the page.
Users can remove by changing to select all records, or to another saved query