• State Verified Answer
  • Replies 3 replies
  • Subscribers 96 subscribers
  • Views 380 views
  • Users 0 members are here
Options
Related

Parameterset and it-shop request

m joosen

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
  • +1

    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 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