column names alias

[mburahmeh]

Hi

You can use "as" for aliasing a column name just like sql. Here is an example -

select Customers.CustomerName as name, Customers.ContactName as cName, Customers.CustomerID as cId from Orders join Customers 
on 
Orders.CustomerID=Customers.CustomerID

Originally posted by @ujjwalguptaofficial in #3 (comment)

aliasing is working fine but the returned query still contains all columns plus the alias column , what i need is how to select aliasing columns only without other columns

[ujjwalguptaofficial]

IndexedDb is NoSQL database means your whole data is stored as object & thus retrieved as object. JsStore dont filter columns because it will be extra computation.

We recommend to use what you need from the results & don't care about extra data. The data is stored locally, so its not much of issue unlike server side database.

e.g - if result is something like that -

var result = [{
    id: 1,
    name: 'ujjwal gupta',
    address: 'india',
    gender: 'male'
}]

From this result - i need only name & gender. So i will use only name & gender don't care about extra data.