BOster
Legendary Poster
Is anyone using Secured Enterprise Search (SES). I read Oracle's section in the FDA documentation titled "Understanding Secured Enterprise Search" and I really don't understand a whole lot more.
I am working on an inventory search form that is a little different than a standard search. I have a solution that will work but I am wondering if SES might provide a better solution or possibly some other feature of APPL design that is in our current tools release or future tools release that I am simply not aware of might make my problem trivial.
Here is the core functionality difference for this search form:
Basically we want the ability for a user to enter in a search string into ONE field but search that string across multiple fields (in our case six different fields). The key thing is that the these six field search off the one string must be OR'd together. So I can't simply populate six FC search fields with the value (this would AND them together). Additionally, I also need to support wild card searches and append to any other user entered QBE/FC search criteria. The "Set Selection" and "Set Selection Group" system functions won't work in this case.
Basically I need a WHERE clause that looks like this:
<font class="small">Code:</font><hr /><pre>
User Enters:
FC_SRP1 = "MBK"
FC_SRP2 = "ABC"
QC_ITM = ">123"
FC_SearchTerm = "*red brick*"
SQL:
WHERE
(SRP1="MBK" AND SRP2="ABC" AND ITM > 123)
AND
(DSC1 LIKE "%red brick%" OR DSC2 LIKE "%red brick%" OR SRTX LIKE "%red brick%")
</pre><hr />
Like I said, I have a solution and it will work, but I am wondering if there is a much easier way to do this - in other words is this type of functionality all ready built into the toolset and I just don't know about it.
I am working on an inventory search form that is a little different than a standard search. I have a solution that will work but I am wondering if SES might provide a better solution or possibly some other feature of APPL design that is in our current tools release or future tools release that I am simply not aware of might make my problem trivial.
Here is the core functionality difference for this search form:
Basically we want the ability for a user to enter in a search string into ONE field but search that string across multiple fields (in our case six different fields). The key thing is that the these six field search off the one string must be OR'd together. So I can't simply populate six FC search fields with the value (this would AND them together). Additionally, I also need to support wild card searches and append to any other user entered QBE/FC search criteria. The "Set Selection" and "Set Selection Group" system functions won't work in this case.
Basically I need a WHERE clause that looks like this:
<font class="small">Code:</font><hr /><pre>
User Enters:
FC_SRP1 = "MBK"
FC_SRP2 = "ABC"
QC_ITM = ">123"
FC_SearchTerm = "*red brick*"
SQL:
WHERE
(SRP1="MBK" AND SRP2="ABC" AND ITM > 123)
AND
(DSC1 LIKE "%red brick%" OR DSC2 LIKE "%red brick%" OR SRTX LIKE "%red brick%")
</pre><hr />
Like I said, I have a solution and it will work, but I am wondering if there is a much easier way to do this - in other words is this type of functionality all ready built into the toolset and I just don't know about it.