Databases
StackOverflow2013
Postsdbo
POJSON Store in worklight v6.0
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJSON Store in worklight v6.0
    primarykey
    data
    text
    <p>I am trying to integrate the JSONStore standalone app in my multipage application. When I am trying to initialize the collection I am getting the following error "Uncaught TypeError: undefined is not a function". One thing I want to know is, in Worklight version 6.0 I observed that underscore (Lo-Dash) templating was used. But nowhere I found the reference given to the lodash. Also, I didn't find the lodash file anywhere. can anyone please tell me how to do this?<br> Here is my javascript code </p> <p>window.$ = window.jQuery = WLJQ; currentPage = {};</p> <p>currentPage.init = function(WL, jQuery, lodash) { alert("current page ::init called");</p> <pre><code>'use strict'; //Dependencies var $ = jQuery, _ = lodash; //CONSTANTS var PEOPLE_COLLECTION_NAME = 'people', KEY_VALUE_COLLECTION_NAME = 'keyvalue', INIT_FIRST_MSG = 'PERSISTENT_STORE_NOT_OPEN', NAME_FIELD_EMPTY_MSG = 'Name field is empty', AGE_FIELD_EMPTY_MSG = 'Age field is empty', ID_FIELD_EMPTY_MSG = 'Id field is empty', EMPTY_TABLE_MSG = 'No documents found', DESTROY_MSG = 'Destroy finished succesfully', INIT_MSG = 'Collection initialized', ADD_MSG = 'Data added to the collection', REPLACE_MSG = 'Document replaced succesfully, call find.', REMOVE_MSG = 'Documents removed: ', COUNT_MSG = 'Documents in the collection: ', CLOSE_ALL_MSG = 'JSONStore closed', REMOVE_COLLECTION_MSG = 'Removed all data in the collection', LOAD_MSG = 'New documents loaded from adapter: ', PUSH_MSG_FAILED = 'Could not push some docs, res: ', PUSH_MSG = 'Push finished', PASS_CHANGED_MSG = 'Password changed succesfully'; $('#init').click(initCollection); $('#destroy').click(destroy); $('#add-data').click(addData); $('#find-name').click(findByName); $('#find-age').click(findByAge); $('#find-all').click(findAll); $('#find-id-btn').click(findById); $('#replace').click(replace); $('#remove-id-btn').click(removeById); //Log messages to the console and status field var _logMessage = function (msg, id) { //Get reference to the status field var status = _.isUndefined(id) ? $('div#status-field') : $(id); //Put message in the status div status.text(msg); //Log message to the console WL.Logger.info(msg); }; //Show JSONStore document in a table var _showTable = function (arr) { if (_.isArray(arr) &amp;&amp; arr.length &lt; 1) { return _logMessage(EMPTY_TABLE_MSG); } //Log to the console WL.Logger.ctx({stringify: true, pretty: true}).info(arr); var //Get reference to the status field status = $('div#status-field'), //Table HTML template table = [ '&lt;table id="user_table" &gt;', '&lt;tr&gt;', '&lt;td&gt;&lt;b&gt;_id&lt;/b&gt;&lt;/td&gt;', '&lt;td&gt;&lt;b&gt;name&lt;/b&gt;&lt;/td&gt;', '&lt;td&gt;&lt;b&gt;age&lt;/b&gt;&lt;/td&gt;', '&lt;td&gt;&lt;b&gt;json&lt;/b&gt;&lt;/td&gt;', '&lt;/tr&gt;', '&lt;% _.each(people, function(person) { %&gt;', '&lt;tr&gt;', '&lt;td&gt; &lt;%= person._id %&gt; &lt;/td&gt;', '&lt;td&gt; &lt;%= person.json.name %&gt; &lt;/td&gt;', '&lt;td&gt;&lt;%= person.json.age %&gt;&lt;/td&gt;', '&lt;td&gt;&lt;%= JSON.stringify(person.json) %&gt;&lt;/td&gt;', '&lt;/tr&gt;', '&lt;% }); %&gt;', '&lt;/table&gt;' ].join(''), //Populate the HTML template with content html = _.template(table, {people : arr}); //Put the generated HTML table into the DOM status.html(html); }; //Scroll to the top every time a button is clicked $('button').on('click', function () { $('html, body').animate({scrollTop: 0}, 'slow'); }); function initCollection() { console.log("init collection method called"); alert("init collection method called"); //Get references to the input fields DOM elements var usernameField = $('input#init-username'), passwordField = $('input#init-password'); //Get values from the input fields var username = usernameField.val() || '', password = passwordField.val() || ''; //Create the optional options object passed to init var options = {}; //Check if a username was passed if (username.length &gt; 0) { options.username = username; } //If if a password was passed if (password.length &gt; 0) { options.password = password; } //JSONStore collections metadata var collections = {}; //Define the 'people' collection and list the search fields collections[PEOPLE_COLLECTION_NAME] = { searchFields : {name: 'string', age: 'integer'}, //-- Start optional adapter metadata adapter : { name: 'people', add: 'addPerson', remove: 'removePerson', replace: 'replacePerson', load: { procedure: 'getPeople', params: [], key: 'peopleList' } } //-- End optional adapter metadata }; //Define the 'keyvalue' collection and use additional search fields collections[KEY_VALUE_COLLECTION_NAME] = { searchFields : {}, additionalSearchFields : { key: 'string' } }; //Initialize the people collection WL.JSONStore.init(collections, options) .then(function () { _logMessage(INIT_MSG); _callEnhanceToAddKeyValueMethods(); }) .fail(function (errorObject) { _logMessage(errorObject.msg); }); } </code></pre> <p>Thanks in advance </p> <p>regards<br> V.H.C</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrichardsun
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload