Difference between revisions of "ECourse Campaign Data"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| (7 intermediate revisions by the same user not shown) | |||
| 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: | 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: | ||
| − | # | + | # : The campaign Id |
| − | # | + | # : The fields you want to retrieve |
| − | # | + | # : The elements of a where clause |
| − | # | + | # : The elements of an order clause |
| − | # | + | # : The separation character desired |
| + | # : The field in the querystring to limit by | ||
| + | # : If there is no value found in the query string... continue drawing the hidden field... usually false | ||
| − | So the format is 1##A##!2##A##!3##A##!4##A##!5##B##! | + | So the format is 1##A##!2##A##!3##A##!4##A##!5##A##!6##A##!7##B##! |
So for our campaign 41. | 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##! | + | 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. | ||
| + | |||
| + | |||
| + | |||
| + | [[Category:Topic:bxp API]] | ||
| + | [[Category:Module Specific:eCourse]] | ||
| + | [[Category:Module Specific:Form Management]] | ||
| + | [[Category:Topic:JavaScript]] | ||
| + | [[Category:Topic:Systems Integration]] | ||
Latest revision as of 00:07, 10 November 2014
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:
- : The campaign Id
- : The fields you want to retrieve
- : The elements of a where clause
- : The elements of an order clause
- : The separation character desired
- : The field in the querystring to limit by
- : If there is no value found in the query string... continue drawing the hidden field... usually false
So the format is 1##A##!2##A##!3##A##!4##A##!5##A##!6##A##!7##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##!~##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.
