Query List/Library using Code on a Web-Enabled Form

w2truong — Tue, 31 May 2011 18:20:34 GMT

So here is the situation, I have a SharePoint library of external content types which have a series of fields. Users are allowed to create new entries using a Web-Enabled InfoPath Form through SharePoint in a browser. But before the entry is created, it has to be cross-referenced with the library to make sure there are no conflicting schedules etc. There are three criteria: one is location, one is a datetime range (start date and end date) and the last is a series of numbers. The series of numbers is a repeating text field so when it is stored in SharePoint, it formats using space delimiters (i.e. "1 2 3"). I am using a Secondary Data Source to connect to the SharePoint library.

I was able to successfully implement the first two criteria (location and datetime) using Default Value section and Insert Formulas (sample below):

Created[WorkAddress = Address and ((msxsl:string-compare(Event_Start_Date, addSeconds(_x007b_3db7d1b0_x002d_8673_x002d_4340_x002d_94e2_x002d_85023c183f1f_x007d_, -1800)) = -1 and msxsl:string-compare(Event_End_Date, addSeconds(_x007b_3db7d1b0_x002d_8673_x002d_4340_x002d_94e2_x002d_85023c183f1f_x007d_, -1800)) = 1) or (msxsl:string-compare(Event_Start_Date, addSeconds(_x007b_3db7d1b0_x002d_8673_x002d_4340_x002d_94e2_x002d_85023c183f1f_x007d_, -1800)) > -1 and msxsl:string-compare(Event_Start_Date, addSeconds(_x007b_3251b4e2_x002d_94b0_x002d_4f65_x002d_a2a1_x002d_3f9a76dc7cba_x007d_, 1800)) = -1))]

Can anyone think of a way for me to implement the last criteria, the series of numbers?

Thank You,

p.s. my description might be a little unclear so i will be glad to clarify if needed

p.s.s. if my default value formula returns multiple rows/values from my Secondary Data Source, is there a way for me to count/display the number of rows/results returned? I know that it will only display one result in the field, but it would be nice to know if there were actually multiple results.