Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
tspafford

Senior Member
Registered:
Posts: 64
Reply with quote  #1 
Background: I am just starting to work in v9.2, cut my teeth in 6.5, 7.6.

So, nothing is where I expect it to be! LOL

I'm trying to create a query BO with one parameter. That's it

Query is

select er_fullname from er_eservicedesk where er_department = @Team order by er_fullname


"Team" as defined as a text parameter

When I test using parameter value of "Service Management Team", no errors, but no results and the BO is unusable

If I removed the parameter and hardcode the value in the query like

select er_fullname from er_eservicedesk where er_department = 'Service Management Team' order by er_fullname


It works fine
0
tspafford

Senior Member
Registered:
Posts: 64
Reply with quote  #2 
OK, no problem. Had to actually set up MetastormDefault connection in my designer and hide the validate section at bottom to see I was getting results!
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #3 
Welcome to the world of version 9. Everything is the same, but different!

I'd recommend my text and video reviews (well, I would, wouldn't I?):
http://www.processmapping.com.au/articles/MetastormBPMVersion9Review/MetastormBPMVersion9Review.html
http://www.processmapping.com.au/articles/MetastormBPM91Review/index.html
http://www.processmapping.com.au/articles/MetastormBPMVersion9ReviewVideo/index.html

and our 'quick-start' guide/demo. It may be simple stuff, but it demonstrates the differences well, I believe:
http://www.processmapping.com.au/freestuff/metastormbpm9quickstart/index.html
http://www.processmapping.com.au/freestuff/metastormbpm9quickstartvideo/index.html


Useful for working out what to use in version 9 vs version 7:
http://processmapping.com.au/freestuff/MetastormBPM9Functions/index.html

hints & tips:
http://www.processmapping.com.au/freestuff/metastormbpm9hintsandtips/index.html

It does not go into BO's and the like, but our examples show a great deal. I am shortly to release a whole new set, much of it updated (aka 'fixed') and some new functionality and solutions:
  • Release Management (for managing the development process and releases)
  • User Management (for managing users - in the system only, outside of the system we still don't know how to do that)
  • System Management (useful tool to help manage a MBPM system through the client)
plus all our libraries etc.
http://www.processmapping.com.au/freestuff/freemetastormbpm9solutions/index.html
http://metastorm.processmapping.com.au/?forum=160575

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!