Databases
StackOverflow2013
Postsdbo
POBreeze and data type when using a .select
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBreeze and data type when using a .select
    primarykey
    data
    text
    <p>I'm curious if anyone has any insight into why adding a .Select to a breeze query and only returning a single column would cause my date field to get parsed differently ? My thought is both queries should return the same data / use the same meta data for my date fields.</p> <p>For example</p> <pre><code>Retrieving the entity that includes the date: function getACase() { var returnPromise = Q.defer(); var caseQuery = breeze.EntityQuery .from("case") .where("pkCaseID", "eq", 1013) return Q.delay(0) .then(function() { return manager.executeQuery(caseQuery) .then (function(data) { returnPromise.resolve(); return data.results; }) .fail(function(){$log.error("CaseData Query Failed")}); }) ; return returnPromise.promise(); } </code></pre> <p>CourtDate columns gets converted to a date : (actual date from database is 1/1/1950)</p> <p><img src="https://i.stack.imgur.com/uBDFP.jpg" alt="enter image description here"></p> <pre><code>Retrieving just the date column from the database: function retrieveCourtDate () { var returnPromise = Q.defer(); var query = breeze.EntityQuery .from("case") .where ("pkCaseID", "eq", 1013) .select("CourtDate"); return Q.delay(0) .then(function() { return manager.executeQuery(query) .then (function(data) { returnPromise.resolve(); return data.results; }) .fail(function(){$log.error("Date Query Failed")}); }); return returnPromise.promise(); } </code></pre> <p>CourtDate is not converted:</p> <p><img src="https://i.stack.imgur.com/gdIgQ.jpg" alt="enter image description here"></p> <p>Displayed on the screen as:<img src="https://i.stack.imgur.com/jQUOj.jpg" alt="enter image description here"></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USpehaada
    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. COTrying to repro now.
      singulars
      1. POBreeze and data type when using a .select
      1. USJay Traband
    2. COThanks Jay ! We are trying to get our dates down and figure out the best way to handle them. We are trying to always store exactly what the user input and then display the same date to other users regardless of the timezone they are in.
      singulars
      1. POBreeze and data type when using a .select
      1. USpehaada
 

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