Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF Mobile - Joined Table Views

LegacyJun 29 2014 — edited Jun 30 2014

How to pass PK of table as FK to new AMX view.

Not sure how to go about this.

Should I specify a View Criteria of the Child view with Bind Variable of Parent Table PK. If so, how.    (ex. WHERE parent.pk = child.fk)

Do not want to have a Parameter Form, just taking the PK of parent used as FK of child view, as a Mobile Button. 

This post has been answered by Arunkumar Ramamoorthy-Oracle on Jun 30 2014
Jump to Answer

Comments

DeloitteRob

yes this does not work and I have not been able to get this to work any way yet either.

Pradeep Kumar-Oracle

Hello, Just checking if anyone got a solution to this ?

Pradeep Kumar-Oracle

Just to update on this, I tried with "FullName" instead and it worked.
So, the call should be as below -

GET "https://<host>:<port>/hcmRestApi/resources/11.13.18.05/workers?q=FullName='Doe, Mic'"
1 person found this helpful
user-uxa13

This is very frustrating. The documentation for worker api STILL (18 months later) has incorrect examples of how to retrieve a worker.

The employee api is being deprecated and we need to move everything over to the worker api. Oracle is making this job much more work than it needs to be by publishing incorrect documentation.

I hope they fix it.

Thank you @pradeep-kumar-oracle2 for your fix!!

1 person found this helpful
Martin...
Answer

Hello,

I've just tried this query again …

GET "https://<host>:<port>/hcmRestApi/resources/latest/workers?q=names.LastName='Jones'"

And it is now working :-)

200 OK
{
	"items": [
		{
			"PersonId": 300000052307100,
			"PersonNumber": "1200243",
			...
			...
			},
			"names": {
				"items": [
					{
						"PersonNameId": 300000052307101,
						"EffectiveStartDate": "2021-11-24",
						"EffectiveEndDate": "4712-12-31",
						"LegislationCode": "GB",
						"LastName": "Jones",
						...
						...
}

Thank you for the fix

Marked as Answer by Martin... · Feb 3 2024
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 28 2014
Added on Jun 29 2014
#adf, #application-development-in-java, #jdeveloper-and-adf, #mobile, #table
6 comments
2,342 views