• State Verified Answer
  • Locked Locked
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 8059 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How can I have dynamic request properties in the request?

ruchita.mantri
over 5 years ago

Hi,

 

I have a requirement to show dynamic values in dropdown in the request. Use case is to show disabled users in the dropdown who were reporting to the logged in user. Can someone please suggest how this can be achieved? Thanks in advance.

Parents
  • 0 over 5 years ago
    Version is 8.0 and below is the condition I am using
    IsInActive = 'True' and exists(select * from Person where UID_PersonHead = N'%UserUID%')
    Am I missing something here?
  • +1 over 5 years ago in reply to ruchita.mantri

    Your query should look like the following.

    IsInActive = 1 AND UID_Person IN (Select UID_Person FROM HelperHeadPerson where UID_PersonHead = '%useruid%')

    Hints:

    • Do not use the Unicode literal N if you query for GUID columns for version 7 or above. If you do so your query performance will degrade.
    • Do get every person that a manager is responsible for (including delegated responsibilities) use the Table HelperHeadPerson. If the delegated ones are not of interest, use the query:
      IsInActive = 1 AND UID_PersonHead = '%useruid%'
    • Bind your sub-query to the current objects. Your query would return every inactive person as long as the current user is a manager of any person.

    In addition, you will need to apply Hotfix VPR#29914 that should be available via support.

Reply
  • +1 over 5 years ago in reply to ruchita.mantri

    Your query should look like the following.

    IsInActive = 1 AND UID_Person IN (Select UID_Person FROM HelperHeadPerson where UID_PersonHead = '%useruid%')

    Hints:

    • Do not use the Unicode literal N if you query for GUID columns for version 7 or above. If you do so your query performance will degrade.
    • Do get every person that a manager is responsible for (including delegated responsibilities) use the Table HelperHeadPerson. If the delegated ones are not of interest, use the query:
      IsInActive = 1 AND UID_PersonHead = '%useruid%'
    • Bind your sub-query to the current objects. Your query would return every inactive person as long as the current user is a manager of any person.

    In addition, you will need to apply Hotfix VPR#29914 that should be available via support.

Children