The Quick Search box in Oracle Fusion ECM (Stellent) will search Content ID, Title and the full text of content by default. To change the fields this functionality uses you will need to add two configuration variables: QuickSearchFields & QuickSearchOperators.
For example, say you wanted to make the quick search use the default fields AND the comments field. Through the Admin Server then General Configuration add the following (then restart and try it out):
Possible values for Quick Search Operators:
Did you forget your sysadmin password for your Oracle Fusion ECM (Stellent) Content Server?!
There are those rare occasions where you might not know the sysadmin password for your Content Server. The reasons for this are many and varied and certainly not limited to forgetting the password or the departure of your administrator who was the "keeper of the key".
What can you do now?
You want to call a stored procedure from within your Oracle Fusion ECM Content Server (Stellent). This post will detail two ways to accomplish that. This post will also be written under the assumption that the stored procedure you are attempting to call resides in your Content Server database.
The first step is to define a query resource. This is fairly simple through Component Wizard. When you create the actual query give it a name and put the word "exec", a space, and the name of your stored procedure in the Query text area.
A template is needed display our data. The template will be attached to a service we will craft in just a few moments. With your handy component wizard create a new template. Add to it some iDocScript that looks like this:
dDocName (# of Revisions)
Now for a service with which to execute our query. Through component wizard go ahead and create the service and then add an action. The action is where we will execute our query resource which points to our stored procedure. Note the parameters textbox as we name the Result Set that will hold our data returned from the stored procedure. Do not forget to hook up your template you made earlier.
We have now used the triangle of power to produce results: Service, Query, Template. To call your query resource from Java you can use the createResultSet method of the Workspace object. You will need to copy the data from that ResultSet into a DataResultSet object and put that in the binder for your template to have access to it.
ResultSet rs = m_workspace.createResultSet("QmostRevisedContent", m_binder);
DataResultSet drs = new DataResultSet();
Here is a Sample Component to Call A Stored Procedure which demonstrates this functionality. It was developed against SQL Server, not Oracle, but the same concepts apply. The component includes a sample sql script you can run against your database to create a stored procedure for the component to execute.
I typically have a hard time in meetings and conference calls when the term Best Practice springs to life. What is a Best Practice? Perhaps I should ask what it means in the context of this post. You can read all about what Best Practice might mean here. 50% of the time I view this as one of the eighty thousand buzzwords that get tossed around during requirements gathering or the whole RFP, RFI, RF* process.
Problems with best practices:
Sure, there really is such a thing as a good course of action or a Best Practice for various issues. News Flash: Not every problem HAS a Best Practice. In fact, a fairly large number of the problems we are trying to solve are likely not going to be solvable by a Best Practice. If there was a specific, well known, highly adopted and strongly verified process to solve the issue we are dealing with it would likely mean our company is not doing anything unique or special. That would be bad because then we would have no competitive edge now would we?
Having established that a Best Practice cannot solve at least a portion of our roadblocks, and having noted we should not avoid tough, lengthy discussions we need to be aware of one more danger. Occasionally there IS a Best Practice that fits fairly well with the problem on the table. Please do not just follow the process blindly. Think for yourself. Sometimes you can just tell that there is a fundamental flaw in the process for your special scenario.
Finally, an example. I tell you, when I was a small child my parents would get upset if I would yell across the house at them. It was quickly set forth as a rule that you went and found them and talked to them normally instead of yelling at them. I offer this as a Best Practice. Now I offer an example where following the Best Practice was not the Best Solution: