function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
developernewbiedevelopernewbie 

Search for particluar text in custom object

Hi,

I am new to Salesforce developement and am having an roadblock trying to solve this.

I am trying to write a code that would search/find read for a certain keywords in a  line item and then classify them to a master category.

For example if there are multiple line items like below: 

Line item on opportunity A= abc/open/def/ghi;
Line item on Opportunity B = def/xyz/open/lmn
Line item on opportunity C = lmn/closed/ijk/def
Line item on Opportunity D = pqr/stu/closed/cde

I want to search for "open" and "closed" in these line items and bucket these line items to a master category:
Open and Closed

I understand search() could be a function to use but not sure how to use.

Thanks in advance!

sivaextsivaext

Hi ,

 

i hope this text stored on some field on opportunity line item

 

write a query on opportunity line item where pass a entered data as paramater

 

ex:

textfielddata =seractext;

 

 

select name, text field from opportunitylineitem where textfield like \'%'+textfielddata+'%\' limit 100

 

 

 

Bhawani SharmaBhawani Sharma
You will have to use SOSL for that.
developernewbiedevelopernewbie

Hi Bhawani,

 

Thanks for looking into this.

 

I think i wasnt clear in my original post and maybe that caused a litte confusion. 

 

The line items i included in my post are under Opportunity product object and the field name is product name. I am trying to read the product name in my trigger to search for key words like "Closed" and "Open". Once i am able to read them i want to copy it to a new object ("Status") and have a counter for the master cateogry. 

 

Hopefully this explanation helps. I am new to developer role and apologize if I dont know the developement lingo yet.

 

Thanks!