Oracle WebCenter Content (MOSC)

MOSC Banner

Limitation of QueryText

Hi All,

While searching from IPM application based search screens, internally a quertext generates which hits the Content server.

Now, we want to modify that querytext by WCC side Custom component. So, how many OR clause can we pass in a single querytext?

Query will be like- (((<NOT> (dFormat <matches> `form/hcsp`)) <AND> (xIPMSYS_APP_ID <matches> `12`)) <AND> 

((xIPM_APP_12_2 >= `2020-10-18 00:00:00 +0000`) <AND> ((xIPM_APP_12_2 <= `2020-11-17 23:59:59 +0000`) 

<AND> ((xsearchID <matches> `test`)) <AND> (dID <matches> '4578' <OR> dID <matches> '4579' .......So on))))

Product Version- WCC and IPM in 12.2.1.4

Regards,

Cris

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center