Hello,

I have a section called Applications which has an Owner field that points to contact lookup. The application section also has a field that points to Company Lookup. I also have a Company section. Inside this section there is a detail called Workers to which contacts are added.

I want to filter Owner lookup to show contacts who are added to the Workers detail of the company which is mapped to the Application. Please see below image. Can someone help with the lookup filter?

Like 0

Like

3 comments
Best reply

Shivani Lakshman,

Change the filter from "[UsrWorkers.UsrWorker].UsrAccount.Id" to "[UsrWorkers:UsrWorker].UsrAccount.Id"

My bad, I forgo...MoreLess

Show all comments (2)

Hello. I have two critical ideas for improving Parameter selection for example in Email Templates, especially the Macros.

Ability to JOIN datatypes on reverse relation.

Example: I am working with Email Template of type Order. I have no chance to included products of the order because the relation i...MoreLess

3 comments

I can get a Table of my Products and Products in Order when setting up a Detail or a Printable Table. I need to be able to do the same with Email Template > Macros

Show all comments (2)

Hello, 

I am trying to do something like this:

Grab information to current page, based off of value in Lookup field.

Example would be, on the current page when the User (Contact) lookup is filled in, also grab the contacts Address (String value), Phone Number (String value), and Account name (Lookup...MoreLess

Like 0

Like

1 comments

Please investigate how to work with ESQ

https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entitysche…

Then check the article by the...MoreLess

Show all comments

Hi all,

2 days ago I posted asking for odata query with relationship: https://community.bpmonline.com/questions/odata-joins

I solved this issue and I posted a solution for that.

I come back because I made working querys with 1/1 relationship but not 1/n for example the idea is to get all the contacts...MoreLess

File attachments
Like 0

Like

3 comments

Dear Uriel,

You can achieve such task by referring to the contact collection, filtering the results by Account Id. 

The request line should...MoreLess

Show all comments (2)

Hi All!

We need to make the following query in OData using Http request.

 

SQL query:

 

select A.FieldZ, B.FieldX

from A inner join B on A.FieldA = B.FieldA

Basically the idea is to get data between relationships por example in one request to get an account including their contacts

if it is possible?

 

Thank you

Regards

 

Like 0

Like

1 comments
Show all comments