Qdabra qRules

Re: Trying to set value in repeating table with Qrules

Hilary Stoupa — Thu, 13 Jun 2013 14:05:46 GMT

In your formula, it looks like you are wrapping your integer in single quotes - can you try w/out those?

Re: Trying to set value in repeating table with Qrules

ErnestoM — Thu, 13 Jun 2013 14:04:15 GMT

If TSD_x0020_day is on the secondary data source, I think it might be a string, though.

Try [number(TSD_x0020_day) = dayCount]

Re: Trying to set value in repeating table with Qrules

MrWilde — Thu, 13 Jun 2013 13:50:40 GMT

Hey Ernesto

TSD_x0020_day is NumberType from SharePointList

dayCount is and integer

I tried passing dayCount through number() just to make sure the data type was correct but same result

Re: Trying to set value in repeating table with Qrules

ErnestoM — Thu, 13 Jun 2013 12:36:38 GMT

What are the data types of TSD_x0020_day and dayCount?

Trying to set value in repeating table with Qrules

MrWilde — Thu, 13 Jun 2013 10:05:31 GMT

Interesting issue get my stumped!

using setvalue to set fields in repeating table from secondary data source, sharepoint list.

Currently testing and have button that sets the 7 required fields for each day.

Have count(preceding-sibling::my:DAYS1to7) + 1 to set the index of the rows

trying this SetValue command

concat("SetValue /xpath=/my:myFields/my:tsd/my:WEEKS/my:WEEK1/my:DAYS1to7/my:w1_personalLeave[../my:w1_day='", dayCount, "'] /value=", LEAVE_x0020_Hours[TSD_x0020_day = dayCount])

I am setting a field to view and the [../my:w1_day='", dayCount, "'] turns too [../my:w1_day='1'] consecuteivley, no problem

I have tested retireving details from the secondary data source

xdXDocument:GetDOM("LEAVE Data list")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:TTL_x0020_Time_x0020_Sheet_x0020[../d:TSD_x0020_day = 2]

No problem

issue is if I try and run

LEAVE_x0020_Hours[TSD_x0020_day = dayCount]

will not work. returns BLANK

Just to reiterate

THIS WORKS - LEAVE_x0020_Hours[TSD_x0020_day = 2]

THIS WORKS - dayCount

THIS WILL NOT - LEAVE_x0020_Hours[TSD_x0020_day = dayCount]

dont understand