Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..
560 views

Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

Hi All,

The customer has a requirement on a catalogue item that the approver cannot be the same as the requester. 

The following are the queries that i have tried that havent worked for the user option Approver that are using the field Contact Name on the Operator Table. The part of the query that i want and currently doesn't work is in bold

contact.name <a*" and not (contact.name#".") and contact.name<>$lo.user.name
contact.name <a*" and not (contact.name#".") and not(contact.name=$lo.user.name)
contact.name <a*" and not (contact.name#".") and contact.name<>name in $lo.operator

 

Could i please get some help with this query so that it includes the part where the requester cannot be the approver.

0 Likes
1 Solution

Accepted Solutions
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

Hi All,

 

I have found the solution. The query that worked was as belo:w:

 

contact.name <"a*" and not (contact.name#".") and not(contact.name=contact.name in $lo,operator)

View solution in original post

0 Likes
5 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

Hello Aleksandar,
hope you are doing well.

Try with this one:

contact.name <a*" and not (contact.name#".") and contact.name~=operator()

You can check the condition in bold to see if it works as expected.
Hope this helps.

BR!

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution. If you are satisfied with anyone’s response please remember to give them a LIKE by clicking on the Thumb and show your appreciation.
0 Likes
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

Hey Jose, 

Thank you for the reply. 

I tested the bekiw query that you have supplied and it had no effect. I was still able to search for my name in the approval field and select it. 

KR

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

What about this:

contact.name <a*" and not (contact.name#".") and not same(contact.name,$lo.user.name)
---
Moving on, this account is no longer active. Best regards, Kelalek
- So Long, and Thanks for All the Fish
0 Likes
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

This also didn't work. 

After implementing this query to the condition of the approval field, when clicking on search for approvers it comes up with the message "No records found". 

0 Likes
Highlighted
Frequent Contributor.. Frequent Contributor..
Frequent Contributor..

Re: Query to not allow the SRC Catalogue requester to be set as the approver of the Job

Jump to solution

Hi All,

 

I have found the solution. The query that worked was as belo:w:

 

contact.name <"a*" and not (contact.name#".") and not(contact.name=contact.name in $lo,operator)

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.