Qdabra qRules

Re: SubmitToSharePointList with filter?

shniggens — Wed, 10 Aug 2011 17:43:57 GMT

I found that using this filter - [my:Total != 0 or my:PullID !=''] works just fine for my scenario.

Re: SubmitToSharePointList with filter?

shniggens — Wed, 10 Aug 2011 17:37:07 GMT

It appears that it does not like the syntax. I get a "Failed to generate batch from mapping" error with the combined rule.

Re: SubmitToSharePointList with filter?

shniggens — Tue, 09 Aug 2011 18:08:18 GMT

That what I'm talking about!!!! Thanks! Eventually, I won't be too quick to exhaust all my mental resources.

Re: SubmitToSharePointList with filter?

Hilary Stoupa — Tue, 09 Aug 2011 17:45:16 GMT

Okay - so you want new items with non zero amounts to be submitted:

[my:Total != 0 and my:PullId = ""]

AND, if something that has been submitted gets changed to 0, it should still be submitted - but shouldn't it just be the case that if it has a PullId, it is always submitted? If so:

[my:PullId != ""]

So, to combine:

[(my:Total != 0 and my:PullId = "") or my:PullId != ""]

Re: SubmitToSharePointList with filter?

shniggens — Tue, 09 Aug 2011 15:01:55 GMT

Hilary Stoupa:

Sounds like you are saying you want:

[my:Total != 0 and my:PullID = '']

So that you submit anything that has not been submitted (i.e., pull id is equal to blank) but has a total that is not equal to zero.

Actually, now looking at it, I think I need -

[my:Total != 0 or my:PullID != '']

That way new items that equal zero will not be submitted. But items that are zeroed out later (that have already been submitted), will get updated in the list still. No, because if it zeroed out it still won't submit. Dangit!

I want new items (no ID) with values of 0 to not be submitted. But if an item gets zeroed out later (after being submitted; ie, with an ID), I want them to get updated in the list.

Re: SubmitToSharePointList with filter?

Hilary Stoupa — Tue, 09 Aug 2011 00:28:09 GMT

Well, you weren't having a Monday all by yourself - you kept telling me what you were trying to do, and I kept overlooking the ! in front of the = myself. :-}

Re: SubmitToSharePointList with filter?

shniggens — Tue, 09 Aug 2011 00:24:37 GMT

Uhhhhhh. It's Monday again. ; ) Thanks. Sometimes it's the simple things.

Re: SubmitToSharePointList with filter?

Hilary Stoupa — Mon, 08 Aug 2011 23:45:49 GMT

Your filter will submit anything that has a total not equal to zero, and a pull id not equal to blank.

Sounds like you are saying you want:

[my:Total != 0 and my:PullID = '']

So that you submit anything that has not been submitted (i.e., pull id is equal to blank) but has a total that is not equal to zero.

Re: SubmitToSharePointList with filter?

shniggens — Mon, 08 Aug 2011 23:40:09 GMT

OK, I thought it would exclude items with a total of 0, and that don't have an existing list ID. Both conditions together for one row of a repeating table. And yes, the PullID the ID I'm using for the Submit.

Re: SubmitToSharePointList with filter?

Hilary Stoupa — Mon, 08 Aug 2011 23:27:54 GMT

I don't know what PullId is. Is this the field you are putting the list id into? It will get populated after a successful submit. So, if you have a new list item, and you intend to submit it, using this XPath would exclude new items, they wouldn't have a PullId.

Re: SubmitToSharePointList with filter?

shniggens — Mon, 08 Aug 2011 20:06:04 GMT

So shouldn't this work, if I am submitting a value of not zero the first time it is submitted ?

[my:Total != 0 and my:PullID != '']

Because it is not working. It won't submit anything.

I figured I could do it this way, because when an item is edited, and possibly zeroed out, it would still submit because the ID would exist. Since it was already submitted to a list earlier.

Re: SubmitToSharePointList with filter?

Hilary Stoupa — Mon, 08 Aug 2011 19:12:18 GMT

ID is set after the SubmitToSharePointList command is run, as long as the /id parameter is provided.

The ID is the list id from the list you have submitted to - that value will already be present in your list.

Re: SubmitToSharePointList with filter?

shniggens — Sun, 07 Aug 2011 21:46:35 GMT

Yes, but is there a workaround that you can think of? Is the ID set after the SubmitToSP command is run?

Re: SubmitToSharePointList with filter?

Patrick Halstead — Sun, 07 Aug 2011 07:24:29 GMT

Are you using 2010? Copy rule will help you with the Insert.

Re: SubmitToSharePointList with filter?

shniggens — Sat, 06 Aug 2011 15:15:19 GMT

Basically to try to get around the insert workaround to copy table (I just don't want to do the insert, there's too many fields in my table to populate), I am trying to filter my submit in such a manner that it does not submit items that = 0, unless it exists in the list already. Therefor I tried to filter this way -

[my:Total != 0 and my:PullID != '']

I'm looking for an alternative to RefreshSharePointListItems command.