topic Re: subquery in Data & Schema Discussions

subquery

ramoji9314 — Fri, 09 Feb 2024 19:39:32 GMT

Hi Team,

Glad to see you all.

I need help to get run time values by passing input. in sql query we can call as subquery.

query(
EBS_CS.CS_ESTIMATE_DETAILS.AFTER_WARRANTY_COST,
EBS_CS.CS_ESTIMATE_DETAILS.SOURCE_CODE = 'DR',
EBS_CS.CS_ESTIMATE_DETAILS.LINE_CATEGORY_CODE = 'ORDER',
EBS_CS.CS_ESTIMATE_DETAILS.CHARGE_LINE_TYPE = 'ACTUAL',
EBS_CS.CS_ESTIMATE_DETAILS.SOURCE_ID = ($repairlineid))

I need to pass repair line id as input.

Please help on this.

Re: subquery

RADSr — Thu, 15 Feb 2024 17:06:14 GMT

I'm not clear on exactly what you want - where/how do you want to use this?

If it's an insight, you can create an estimate details view in a business schema and then filter that using inquery

Or use an Incorta Result Set as the insight data source and filter that

Re: subquery

Prince — Thu, 14 Mar 2024 08:16:17 GMT

@ramoji9314 , I am not also clear about what exactly is required, but there are 2 things, one mentioned by @RADSr , and in other places, you can use variables, according the context, global or presentation variables.