Difference between revisions of "ECourse Campaign Data"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (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...") |
Philip Lacey (talk | contribs) |
||
| Line 3: | Line 3: | ||
The system uses two splitting paramaters | The system uses two splitting paramaters | ||
| − | ##B##! this is the end of an item | + | * ##B##! this is the end of an item |
| − | + | * ##A##! this is the spliiting of values per 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: | 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 | + | #1 : The campaign Id |
| − | 2 : The fields you want to retrieve | + | #2 : The fields you want to retrieve |
| − | 3 : The elements of a where clause | + | #3 : The elements of a where clause |
| − | 4 : The elements of an order clause | + | #4 : The elements of an order clause |
| − | 5 : The separation character desired | + | #5 : The separation character desired |
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##B##! | ||
Revision as of 14:33, 4 December 2012
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##!
