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.
You might be able to just use
:PRLINENUM is null
IMO, it's worth a try...
Shannon
Sent from my BlackBerry 10 smartphone on the TELUS network.
Original Message
From: Ian Wright ian_wright12000@yahoo.co.uk [MAXIMO]
Sent: Wednesday, May 17, 2017 10:53 AM
To: MAXIMO@yahoogroups.com
Reply To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Re: Conditional Expression Manager - when no values
Try
1 > (select count(*) from prline where prnum = :prnum and siteid = :siteid )
If true then no prlines exist else they do
Workflow does a save on start
Reds ian
Sent from my iPhone
> On 16 May 2017, at 22:05, Michael Stringer michael.stringer@cdhb.health.nz [MAXIMO] <MAXIMO@yahoogroups.com> wrote:
>
> Hi Travis
>
> The trigger for the PR to go into workflow is a separate toolbar button to the save. (This allows a requestor to partially prepare a PR and save so they can update before submitting for approval via workflow.) We are fine with most of the PR being editable up until the PR is approved - just do not want extra lines to be added by the approver. Dropping the New Row button from the approver if a record is in workflow seemed like the simplest option.
>
> I have been trying to add an expression to check for existence of PR lines - where I seem to be coming adrift is where there are no lines at all - The null or no records seem to be where the condition is falling over. Whether trying to allow the button based on wfinstance or PRLINE appears to be behaving the same for PRs yet to get lines.
>
> Regards
> Michael
>
> From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
> Sent: Wednesday, 17 May 2017 12:58 a.m.
> To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Re: Conditional Expression Manager - when no values
>
> When does the PR go into Workflow? Immediately upon Save? If so, could you change your Workflow design to detect existence of PR Lines, such that if there are no Lines it exits the Workflow?
>
> Otherwise, change your Conditional Expression to check for existence of PR Lines too.
>
> Travis Herron
>
>
>
>
>
>