• State Not Answered
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 80 views
  • Users 0 members are here
Options
Related

Parameterset and it-shop request

m joosen
1 day ago

Hi,

Im setting up an it shop request for the first time with the non obsolete setting. I have done this several times with the old it shop

After submitting te request, we have to ask an business role manager to approve. But how can i setup this approval workflow. I cannot seem to figure out how to get the unique value from the submitted request thas is stored in parameter table and can be found by the parameterset uid. 

I can not figure out how to come from my shopping cart order to the parameterset table. 

In the designer there is an script thats gets te values to use in a workflow but in the manager there is not. 

How could this be done?

With kind regards 

Martijn

Parents
  • 0 13 hours ago

    You can create a custom approval procedure for that. A sample code for the query definition of such a procedure, assuming that the parameter contains the UID of an Org (business role), and the business role manager (and all his delegates)  should be selected would be:

    select hho.UID_PersonHead as UID_Person, dbo.QER_FGIPWORulerOrigin(hho.XObjectKey) as UID_PWORulerOrigin
        FROM PersonWantsOrg pwo
		INNER JOIN DialogParameterSet s ON pwo.XObjectKey = s.ObjectKeyUsedBy
        INNER JOIN DialogParameter pa ON s.UID_DialogParameterSet = pa.UID_DialogParameterSet
        INNER JOIN Org o on pa.ParameterValue = o.UID_Org
        INNER JOIN HelperHeadOrg hho on hho.UID_Org = o.UID_Org AND XOrigin > 0	
        WHERE pwo.UID_PersonWantsOrg = @UID_PersonWantsOrg AND pa.ParameterName = N'<YourParameterName>'

  • 0 13 hours ago in reply to Markus Weiss-Ehlers

    Hi Markus,

    Thanks in advance for your very quick responds. i'll have to check this but i think this should be the solution. is this in matter of effect the same as the script does in Designer?

    one other thing. The new IT-shop does not save the UID of the table you have selected when using a pattern. i used the display pattern option to make it more easy for the user to read (%Ident_Org%) so my UID is replaced with the 'Ident_Org' This is also unique value and can also be used in the query above. 

    i will Verify your answer as soon as i have checked it completely 

  • 0 12 hours ago in reply to m joosen

    Yes. The query gets the parameter value as the script QER_Get_ParameterValue_Of_ParameterSet_Of_PWO and in addition uses the value to identify the managers of the Org (the parametervalue contains the UID_Org in my sample).

Reply Children
No Data