HDU- A Service Desk User Community: Forums / Customizing r11.x / [RESOLVED] Stored Query Problem (Change Orders)

Forums

HDU- A Service Desk User Community :: Forums :: Service Desk r11.X Support :: Customizing r11.x		<< Previous thread \| Next thread >>
[RESOLVED] Stored Query Problem (Change Orders)


Moderators: Admin, 4uTech CEO

Author

Post

wbvczar

Mon Jan 25 2010, 01:39PM

Registered Member #831

Joined: Tue Aug 09 2005, 10:39AM
Posts: 92

I am trying to write a stored query for a Change Order that will show all Active Change Orders for the customer that is logged in if the organization in the "organization" filed matches the customers department.

Each customer has a department (admin_org) and a division (organization) and we use both of these in the change order's "organization" field. Here is what I have so far:

organization = @cnt.organization AND active = 1

It works, but it only shows change orders where the customer's (logged in) department matches the department (admin_org) of the Requestor. It does not seem to be looking at the Organization field of the change order.

Any ideas?

[ Edited Tue Jan 26 2010, 08:17AM ]

wbvczar

Tue Jan 26 2010, 08:17AM

Registered Member #831

Joined: Tue Aug 09 2005, 10:39AM
Posts: 92

I found my problem to be a Data Partition constraint problem. I modified the change order "view" contraint to:

organization = @root.admin_org OR organization = @root.organization

and then set my stored query to:

(organization=@cnt.admin_org OR organization=@cnt.organization) AND active=1

and problem solved.

4uTech CEO

Wed Jan 27 2010, 12:26PM

CEO 4uTechnologies, Inc.

Registered Member #150

Joined: Mon Aug 16 2004, 03:58PM
Posts: 3904

nice.. so the functional org (organization_uuid) is matching the (admin_organization_uuid).. Oops.. i see you are in r11<... good job on the solution. So many people use the functional org and the Administrative org in so many different ways...

eric

Specializing in Service Desk


Jump: Back to top