19
Views
6
Comments
Making File Content Searchable
Discussion
Hi There

Could someone please help in assisting me with the following:

I have created a CV (Resume') database application. The application captures a candidates information and the has the option to attach his Resume' as well.

What I want to know from someone is, how can I create a search filter that will search through the content of the attached file, for example if the word C# is in a candidate's resume and I want to find all the documents that contains C# in them?

Your help will be much appreciated.
2013-11-21 00-40-55
Curt Raddatz
If you are on a Windows platform you may be able to use Windows Desktop Search (WDS) to accomplish this.  You would likely have to write an extenstion using the SDK.  Information to get you started with the SDK can be found here - https://msdn.microsoft.com/en-us/library/aa965362.aspx.
UserImage.jpg
Rudi Stols
Hi Curt

Thanks for getting back to me so quickly. This seems to be to technical for me to grasp. I have never done any high level development so wouldn't know where to start in order to write an extension for my app in order to search through document content.

Is there a way that you can please explain all of this in more basic terms to me.

Thanks
2020-03-05 15-52-45
André Vieira
Staff
Hi Rudi,

You can achieve that by using the full text search capabilities in SQL Server. Check out this post https://www.outsystems.com/forums/discussion/8934/how-to-install-configure-and-use-full-text-search/.

As indicated here Oracle Text is the equivalente for the Oracle database.
2013-11-21 00-40-55
Curt Raddatz
Andre,

I didn't propose the built in database capabilities because it looked like he was dealing with files that were not stored in the database. 

Rudi,

Since I don't know your programming background and because I haven't actually implemented this I would not know how to help you.  If you haven't done any high level development then you should contract out to someone that has done this type of work as it would probably take you a long time to do, based on that limited experience.
2020-03-05 15-52-45
André Vieira
Staff
Hi Curt,

Actually Rudi also PM'ed me. I just thought this info might help someone else....

Another option would be to use Google Drive to store the files and use their API for full text search.
2022-08-16 13-41-51
Surya V

Hi Andre im trying searching file in google drive by content in that files

I have integrated Google drive in outsystems and completed CRUD operations but searching file through content is pending.

Used the google drive IS component 

Can u solve me how to do the search using content in the attached file.


Thanks in advance 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.