• aadev
  • NEWBIE
  • 0 Points
  • Member since 2004

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
I'm working on cleaning out some unused records in my SFDC account. i noticed that the "Storage Usage" window shows that Documents are taking up 626 KB. My problem is that I only have 2 document records and they are below 6 KB each. What is using the other 614 KB of storage? How can I clean this other storage out?
  • February 23, 2006
  • Like
  • 0

Please note there is an omission in the API 2.5 documentation concerning SOQL and LIKE.

 

The documentation is missing description of the LIKE keyword, which as in the case with SQL, allows wild card searching of text fields.

 

For example:

 

select id, firstname, lastname  from lead where lastname like 'Smith%'

 

Will match all last names starting with Smith.

 

select id, firstname, lastname  from lead where lastname like 'Smith_'

 

Will match all last names starting with Smith up to 1 additional character.  (IE Smiths will match, but Smithson will not.)

 

The documentation will be updated soon to reflect this feature.

  • December 04, 2003
  • Like
  • 0