ECourse Campaign Data - Revision history

Philip Lacey at 23:07, 9 November 2014

2014-11-09T23:07:53Z

Philip Lacey at 22:33, 9 November 2014

2014-11-09T22:33:19Z

Philip Lacey at 20:46, 9 November 2014

2014-11-09T20:46:29Z

Philip Lacey at 01:23, 22 March 2014

2014-03-22T01:23:52Z

Philip Lacey at 16:13, 30 July 2013

2013-07-30T16:13:13Z

Philip Lacey at 16:35, 4 December 2012

2012-12-04T16:35:40Z

Philip Lacey at 15:38, 4 December 2012

2012-12-04T15:38:37Z

Philip Lacey at 13:34, 4 December 2012

2012-12-04T13:34:05Z

Philip Lacey at 13:33, 4 December 2012

2012-12-04T13:33:47Z

Philip Lacey: Created page with "This option allows campaign data to be stored in a hidden field on the page to reduce the amount AJAX lookups and retrieval of data from campaigns. The system uses two splitt..."

2012-12-04T13:33:09Z

Created page with "This option allows campaign data to be stored in a hidden field on the page to reduce the amount AJAX lookups and retrieval of data from campaigns. The system uses two splitt..."

New page

This option allows campaign data to be stored in a hidden field on the page to reduce the amount AJAX lookups and retrieval of data from campaigns.

The system uses two splitting paramaters

##B##! this is the end of an item

##A##! this is the spliiting of values per item

So how to construct one of these. Say you have a campaign ... campaign 41. You want to use the current items of this campaign as a list. All the items in this list are in strCDA_41_field_0_4. Step 1 is to retrieve data into the campaign. The separating charcter we will use is the tilda ~. The fields needed are:

1 : The campaign Id
2 : The fields you want to retrieve
3 : The elements of a where clause
4 : The elements of an order clause
5 : The separation character desired

So the format is 1##A##!2##A##!3##A##!4##A##!5##B##!

So for our campaign 41.

41##A##!strCDA_41_field_0_4##A##!strCDA_41_field_0_4 like '%test'##A##!intCDA_41_Id ASC##A##!~##B##!

@@ Line 33: / Line 33: @@
 [[Category:Topic:bxp API]]
-[[Category:Module Specific:eCourse Management]]
+[[Category:Module Specific:eCourse]]
 [[Category:Module Specific:Form Management]]
 [[Category:Topic:JavaScript]]
 [[Category:Topic:Systems Integration]]

@@ Line 31: / Line 31: @@
-[[Category:Learning:Systems Integration]]
 [[Category:Topic:bxp API]]
 [[Category:Module Specific:eCourse Management]]
 [[Category:Module Specific:Form Management]]
 [[Category:Topic:JavaScript]]

@@ Line 32: / Line 32: @@
 [[Category:Learning:Systems Integration]]
-[[Category:BEAPI:InScript JavaScript]]
+[[Category:Topic:bxp API]]
 [[Category:Module Specific:eCourse Management]]
 [[Category:Module Specific:Form Management]]
 [[Category:Topic:JavaScript]]

← Older revision		Revision as of 01:23, 22 March 2014
Line 29:		Line 29:

	This will create a hidden select list called selectStaffList which can then be used by your JavaScript.		This will create a hidden select list called selectStaffList which can then be used by your JavaScript.
		+
		+
		+	[[Category:Learning:Systems Integration]]
		+	[[Category:BEAPI:InScript JavaScript]]
		+	[[Category:Module Specific:eCourse Management]]
		+	[[Category:Module Specific:Form Management]]
		+	[[Category:Topic:JavaScript]]

← Older revision		Revision as of 16:13, 30 July 2013
Line 22:		Line 22:

	41##A##!strCDA_41_field_0_4##A##!strCDA_41_field_0_4 like '%test'##A##!intCDA_41_Id ASC##A##!~##A##!strCDA_41_field_0_9##A##!false##B##!		41##A##!strCDA_41_field_0_4##A##!strCDA_41_field_0_4 like '%test'##A##!intCDA_41_Id ASC##A##!~##A##!strCDA_41_field_0_9##A##!false##B##!
		+
		+
		+	Where a listing of all valid user logins is required in a select list use the following
		+
		+	00##B##!
		+
		+	This will create a hidden select list called selectStaffList which can then be used by your JavaScript.

@@ Line 15: / Line 15: @@
 # : The separation character desired
 # : The field in the querystring to limit by
-So the format is 1##A##!2##A##!3##A##!4##A##!5##A##!6##B##!
+So the format is 1##A##!2##A##!3##A##!4##A##!5##A##!6##A##!7##B##!
 So for our campaign 41.
-##A##!strCDA_41_field_0_4##A##!strCDA_41_field_0_4 like '%test'##A##!intCDA_41_Id ASC##A##!~##A##!##B##!
+##A##!strCDA_41_field_0_4##A##!strCDA_41_field_0_4 like '%test'##A##!intCDA_41_Id ASC##A##!~##A##!strCDA_41_field_0_9##A##!false##B##!

@@ Line 9: / Line 9: @@
 So how to construct one of these.  Say you have a campaign ... campaign 41.  You want to use the current items of this campaign as a list.  All the items in this list are in strCDA_41_field_0_4.  Step 1 is to retrieve data into the campaign.  The separating charcter we will use is the tilda ~.   The fields needed are:
-#1 : The campaign Id
+# : The campaign Id
-#2 : The fields you want to retrieve
+# : The fields you want to retrieve
-#3 : The elements of a where clause
+# : The elements of a where clause
-#4 : The elements of an order clause
+# : The elements of an order clause
-#5 : The separation character desired
+# : The separation character desired
 So the format is 1##A##!2##A##!3##A##!4##A##!5##B##!