nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

EXISTS clause Not working in RPD - Expression builder

Saroj Kumar Behera

Hi,

I am facing when using EXISTS clause in expression builder in RPD.

Can anybody let me know how to handle this type of expressions in Expression builder in RPD.

Thanks!!

Find more posts tagged with

OAC

Accepted answers

[Deleted User]

+500 to Richard: What are you trying to achieve? Why do you have the need to write such extreme formulas in the RPD?

Never forget that whatever you write here gets interpreted row-by-row and is a very inefficient way of doing things. If you ETL your data into the correct form them this effort happens once per load instead of thousands or even millions of times for every single execution of any analysis touching that column.

All comments

RichardChan

Looks like you're combining physical and logical SQL together not sure you're able to do a subselect in the way that you have structured it there. Can you detail the logic of what you're attempting to achieve?

Nagendra Palukuri-Oracle

@Saroj Kumar Behera You can try using operator 'IN' in the column expression builder.

[Deleted User]

+500 to Richard: What are you trying to achieve? Why do you have the need to write such extreme formulas in the RPD?

Saroj Kumar Behera

Thanks all for your input. I put the logic in ETL area and try to do less formulae in RPD layer. Now its working. Thanks!!

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80