+ Start a Discussion
sathisathi 

pls give me solution

if one field have more than one value........

for ex  stock price of a company will changing every hour ....and that is updating in stock history object..........

how to get open price(starting price) ?

Jia HuJia Hu
Sorry, but what do you mean 'open price(starting price)'?
sathisathi

share price value is changing every one hour in share market......im updating that value in my account stock history object......

for example ibm company has 130(morning 9am)

                                                         120(morning 10am)

                                                         125(morning 11 am).......like that

  i need  first price(open price) in my visual force page how i can get it?

Jia HuJia Hu
In a simple way, you can use two fields, one for the first price, and the other for the changing one,..

just like Salesforce to deal with it,...
in a record, you have a CreatedDate field for keeping the starting time,
and have a LastModifiedDate field for keeping the update time.
neophyteneophyte

If these are different records that you are talking about, then query the table are use 'order by'  to arrange the records and get the record you need. You can arrange the records in ascending and descending order based on fields in the record.

 

- Anand