通过拼写OQL来实现按请购单行条件进行工作流设计

by yangjs 2013.10.31 08:53

注:脚本执行有风险,对于客户正式环境请在研发指导下执行。

原始客户问题:

希望能够在审批流中增加子行判断条件;对于子行中物料的主分类的编码左包含9且建议价格高于5000的某个人审批,否则则自动通过,目前无法在判断节点中设置子行条件。

实现如下:

判断条件:1.(select count(*) from UFIDA::U9::PR::PurchaseRequest::PRLine as prline where prline.SuggestedPrice > 5000 and prline.ItemInfo.ItemID.MainItemCategory.Code like '9%' and prline.pr = UFIDA::U9::PR::PurchaseRequest::PR.ID) > 0
2.(select count(*) from UFIDA::U9::PR::PurchaseRequest::PRLine as prline where prline.SuggestedPrice > 5000 and prline.ItemInfo.ItemID.MainItemCategory.Code like '9%' and prline.pr = UFIDA::U9::PR::PurchaseRequest::PR.ID) = 0
子行审批分配条件:SuggestedPrice > 5000 and ItemInfo.ItemID.MainItemCategory.Code like '9%'

评论 (42) -

http://elektro.umsida.ac.id/halkomentar-241-20225.html 美国 wrote at 2016/6/3 17:04:47 #

Aw, this was an exceptionally good post. Spending some time and actual effort to generate a great article… but what can I say… I put things off a whole lot and never manage to get anything done.

job slogan t shirts 美国 wrote at 2016/6/3 19:45:51 #

There's certainly a great deal to find out about this issue. I love all of the points you've made.

Job: T-Shirts & Hoodies Cheap | Job Slogan T shirts 美国 wrote at 2016/6/4 5:05:47 #

When some one searches for his necessary thing, so he/she desires to be available that in detail, therefore that thing is maintained over here.

job slogan tshirts 美国 wrote at 2016/6/5 23:32:00 #

Hi to all, because I am genuinely eager of reading this blog's post to be updated on a regular basis. It includes fastidious material.

job slogan tshirts 美国 wrote at 2016/6/6 15:27:28 #

This piece of writing will help the internet viewers for creating new blog or even a blog from start to end.

custom tshirts 美国 wrote at 2016/6/25 1:28:32 #

I think this is one of the most significant info for me. And i'm glad reading your article. But wanna remark on few general things, The site style is wonderful, the articles is really great : D. Good job, cheers

name custom t shirts 美国 wrote at 2016/8/27 3:49:59 #

Greetings! Very helpful advice in this particular article! It's the little changes which will make the biggest changes. Many thanks for sharing!  Also visit my blog:  name custom t shirts - http://forums.gogames.me/space-uid-4969634.html

Name Halloween t shirts 美国 wrote at 2016/9/18 20:03:09 #

Hurrah, that's what I was seeking for, what a material! existing here at this weblog, thanks admin of this website.

design T shirts 美国 wrote at 2016/10/3 8:51:55 #

Thanks for ones marvelous posting! I certainly enjoyed reading it, you could be a great author. I will always bookmark your blog and will come back at some point. I want to encourage you to ultimately continue your great posts, have a nice evening!

http://www.halloweencostumesdecoration.com/ 美国 wrote at 2016/10/3 9:55:16 #

It is not my first time to pay a quick visit this web site, i am browsing this site dailly and take pleasant data from here everyday.

http://www.halloweencostumesdecoration.com/ 美国 wrote at 2016/10/3 10:22:21 #

I have learn some excellent stuff here. Definitely price bookmarking for revisiting. I surprise how much effort you put to create this sort of great informative web site.

Get more 美国 wrote at 2016/10/3 10:30:06 #

Hi i am kavin, its my first occasion to commenting anyplace, when i read this paragraph i thought i could also create comment due to this brilliant piece of writing.

custom t shirts 美国 wrote at 2016/10/3 10:41:34 #

Hello, of course this article is actually fastidious and I have learned lot of things from it regarding blogging. thanks.

http://www.cutehalloweencostumes.net/ 美国 wrote at 2016/10/3 11:07:23 #

I every time emailed this blog post page to all my friends, for the reason that if like to read it afterward my links will too.

design your own t shirt 美国 wrote at 2016/10/3 11:26:56 #

Post writing is also a fun, if you be familiar with after that you can write otherwise it is complicated to write.

design your own t shirt 美国 wrote at 2016/10/3 11:29:40 #

Now I am ready to do my breakfast, when having my breakfast coming yet again to read further news.

http://www.costumehalloween2016.com/ 美国 wrote at 2016/10/3 11:51:45 #

Normally I don't read post on blogs, however I would like to say that this write-up very pressured me to take a look at and do so! Your writing taste has been amazed me. Thank you, quite nice post.

http://www.cutehalloweencostumes.net/ 美国 wrote at 2016/10/3 11:58:39 #

Attractive element of content. I simply stumbled upon your site and in accession capital to claim that I get actually loved account your weblog posts. Anyway I will be subscribing for your augment or even I achievement you get entry to constantly quickly.

http://www.cutehalloweencostumes.net/ 美国 wrote at 2016/10/3 12:47:24 #

Hello there! Quick question that's completely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when viewing from my iphone 4. I'm trying to find a template or plugin that might be able to fix this problem. If you have any recommendations, please share. Thank you!

design T shirts 美国 wrote at 2016/10/5 15:42:16 #

Hi there, I found your site by the use of Google at the same time as searching for a comparable subject, your website came up, it appears good. I have bookmarked it in my google bookmarks. Hello there, just changed into alert to your weblog through Google, and located that it's truly informative. I am going to be careful for brussels. I will appreciate should you continue this in future. Numerous folks will likely be benefited out of your writing. Cheers!

personalised T shirts 美国 wrote at 2016/10/5 17:46:26 #

After exploring a handful of the blog posts on your web page, I truly like your technique of writing a blog. I added it to my bookmark webpage list and will be checking back soon. Please visit my web site too and let me know how you feel.

Buy now 美国 wrote at 2016/10/10 5:32:17 #

Hello there, I discovered your blog by the use of Google even as looking for a related topic, your website came up, it appears to be like great. I have bookmarked it in my google bookmarks. Hi there, simply became alert to your weblog via Google, and located that it's really informative. I'm going to be careful for brussels. I'll be grateful when you proceed this in future. Numerous folks will be benefited out of your writing. Cheers!

http://www.costumehalloween2016.com/ 美国 wrote at 2016/10/10 7:55:51 #

Hey there would you mind letting me know which hosting company you're working with? I've loaded your blog in 3 different internet browsers and I must say this blog loads a lot faster then most. Can you recommend a good web hosting provider at a reasonable price? Thanks, I appreciate it!

cool t shirts 美国 wrote at 2016/10/11 4:20:55 #

Good day! I simply would like to give you a huge thumbs up for your excellent information you have right here on this post. I'll be coming back to your web site for more soon.

funny ugly christmas sweaters 美国 wrote at 2016/10/12 7:03:57 #

Hello, yes this post is in fact fastidious and I have learned lot of things from it concerning blogging. thanks.

funny christmas sweaters for couples 美国 wrote at 2016/10/12 7:15:08 #

I'm curious to find out what blog platform you're using? I'm experiencing some small security problems with my latest blog and I would like to find something more safe. Do you have any suggestions?

funny ugly christmas sweaters 美国 wrote at 2016/10/12 7:18:35 #

Today, I went to the beach front with my children. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

www.funnychristmasshirts.net 美国 wrote at 2016/10/12 7:47:56 #

Hello! I could have sworn I've visited your blog before but after browsing through a few of the articles I realized it's new to me. Anyhow, I'm certainly delighted I discovered it and I'll be bookmarking it and checking back frequently!

www.christmasvacationshirts.com 美国 wrote at 2016/10/12 8:16:46 #

Good replies in return of this issue with firm arguments and describing all about that.

funny ugly christmas sweaters 美国 wrote at 2016/10/12 8:17:45 #

Undeniably consider that that you said. Your favourite reason appeared to be on the net the simplest factor to consider of. I say to you, I definitely get annoyed even as folks consider issues that they plainly don't recognise about. You controlled to hit the nail upon the top and also outlined out the entire thing with no need side effect , other folks could take a signal. Will likely be again to get more. Thanks

funny christmas sweaters for couples 美国 wrote at 2016/10/12 9:17:31 #

Hey very interesting blog!

www.awesometshirtchristmas.com 美国 wrote at 2016/10/12 10:03:56 #

Hi there are using Wordpress for your blog platform? I'm new to the blog world but I'm trying to get started and create my own. Do you need any html coding expertise to make your own blog? Any help would be really appreciated!

www.funnychristmasshirts.net 美国 wrote at 2016/10/12 10:55:11 #

Great goods from you, man. I've take note your stuff previous to and you are just extremely excellent. I actually like what you have received here, certainly like what you're stating and the way in which by which you assert it. You make it enjoyable and you still take care of to keep it sensible. I can't wait to learn far more from you. This is actually a tremendous website.

www.christmasvacationshirts.com 美国 wrote at 2016/10/12 11:14:55 #

I do accept as true with all the concepts you've offered to your post. They are really convincing and will certainly work. Nonetheless, the posts are very quick for beginners. May you please lengthen them a little from next time? Thanks for the post.

christmas sweaters funny 美国 wrote at 2016/10/12 11:42:41 #

Excellent items from you, man. I've consider your stuff prior to and you are simply extremely wonderful. I actually like what you have bought here, certainly like what you are saying and the best way by which you are saying it. You're making it entertaining and you still take care of to stay it smart. I can't wait to read much more from you. This is really a terrific web site.

funny christmas sweaters for couples 美国 wrote at 2016/10/12 15:10:33 #

We're a bunch of volunteers and starting a new scheme in our community. Your site offered us with helpful info to work on. You have done a formidable activity and our entire neighborhood shall be thankful to you.

best funny christmas t-shirts 美国 wrote at 2016/10/12 15:42:30 #

First off I want to say terrific blog! I had a quick question which I'd like to ask if you don't mind. I was curious to find out how you center yourself and clear your thoughts before writing. I've had a tough time clearing my mind in getting my ideas out. I truly do enjoy writing however it just seems like the first 10 to 15 minutes are usually lost just trying to figure out how to begin. Any ideas or tips? Kudos!

www.funnychristmasshirts.net 美国 wrote at 2016/10/12 22:14:18 #

I feel this is among the most vital information for me. And i am glad reading your article. However should commentary on some common issues, The web site style is great, the articles is really great : D. Just right job, cheers

christmas sweater gif 美国 wrote at 2016/10/14 21:02:29 #

This design is steller! You obviously know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!) Fantastic job. I really loved what you had to say, and more than that, how you presented it. Too cool!

christmas sweater pattern 美国 wrote at 2016/10/15 13:38:18 #

I think that is among the such a lot vital info for me. And i am satisfied reading your article. However should statement on some basic issues, The website style is perfect, the articles is really nice : D. Excellent task, cheers

sena sofia 美国 wrote at 2016/11/18 21:31:01 #

Excellent post. I used to be checking constantly this blog and I'm impressed! Extremely helpful info specially the ultimate part 微笑 I handle such info much. I was seeking this certain info for a long time. Thank you and good luck.

edit HTML online 美国 wrote at 2018/6/6 6:44:11 #

Asking questions are genuinely fastidious thing if you are not understanding anything completely, however this piece of writing presents good understanding yet.

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
787267 条评论
11 次评分
1396182 次访问
访问统计开始于 2019年12月15日
平均日访问 6810 次
当前 108 人在线