Skip to main content

Hi All,

I added a persistent custom field to the entity CroHead as follows.

 

And then added it to ‘Component Repair Order’ page with below LOV filter.

 

But this does not filter ‘Cf Crm Contact’ using ‘Customer ID’ value. It’s ‘1000’ here. But it filters correctly if I change the filter as follows.

 

Is there a way to get this filtered dynamically using the ‘Customer’ value?

I went through previous community posts and F1 documentation as well but could not find a solution. It seems syntax has been changed in new cloud versions.

I checked with below syntax but still no luck.

contains(Cf_DisplayText, '$CUSTOMER_ID')
contains(Cf_DisplayText, '$oCustomer_Id]')
contains(Cf_DisplayText, '$oCUSTOMER_ID]')
contains(Cf_DisplayText, '$oCustomerId]')

 

Thanks & Best Regards,

Randini

Hi Randini.

I haven’t worked with this functionality just yet but I found an entry in the documentation that maybe can help:

https://docs.ifs.com/techdocs/23r1/040_tailoring/225_configuration/200_client_configurations/310_conditional_fields/100_conditional_lov/

Thank you much.
Best regards.
Gonzalo.

 

Hi Gonzalo,

Thank you very much for the link.

However this example is not for passing a dynamic value. I’m looking for that scenario. Anyway thanks again for your input.

Hi, Here, the value accepts an OData filter syntax. So I think we need to query core framwork team to see if we can have substitutions here. Further, good place to start is trying to do exact same thing in developer studio with marble and see what we have in page designer.

@Nils Wendelöv Is there a way to set a column value dynamically to an Odata filter? I have tried few ways through page designer but couldn’t get any to work. Maybe we are not supporting such functionality yet?

Thanks Chanaka. Yes I want to know whether we are supporting this functionality or not.

did you find the answer?

Not yet Franck

I'm looking to do the same thing ... with custom fields 

I’ll update the post if I get anything. Seems there is a high demand for this. Another person reached out to me asking whether I got a solution.

I don't know if the syntax of my fitre is correct 

 

Hi All,
 

This issue is not a bug in the application. It's important to understand that standard attributes and custom attributes have different capabilities. Custom attributes come with certain limitations as they are configuration-based.

The specific requirement mentioned here cannot be fulfilled using the page designer. There are several community links that demonstrate how to achieve this, but they are relevant to IFS Apps 10 and do not apply to the IFS Cloud track. The IFS product team recommends considering customization to achieve the desired outcome, and you can find detailed information in the IFS Documentation here:
Dynamically changing values.

You might wonder if this cannot be achieved using the page designer, then can we expect a fix in a future release?

The product development team has indicated that providing a definitive yes/no answer regarding whether this issue will be addressed in a future release is not feasible. Based on the existing design, it appears to be something that we are unable to achieve.
 

I hope this explanation clarifies the concern.

Thank you.
Kind regards,
Sandun Madola.

Thanks Sandun for the clarification

In another post the recommendation was to use Datasource Aggregate Ref parameters to filter Custom LOV field.

 

In another post the recommendation was to use Datasource Aggregate Ref parameters to filter Custom LOV field.

 

Is this information available for non-partners? The above link is restricted

In another post the recommendation was to use Datasource Aggregate Ref parameters to filter Custom LOV field.

 

Is this information available for non-partners? The above link is restricted

Here is a Word document where I collected the answer from the other Community post. IFS employee Thisara was sharing a way to filter a custom field LOV.

In another post the recommendation was to use Datasource Aggregate Ref parameters to filter Custom LOV field.

 

Is this information available for non-partners? The above link is restricted

Here is a Word document where I collected the answer from the other Community post. IFS employee Thisara was sharing a way to filter a custom field LOV.

 

I was stuck with the same problem as @Randini Jayasundara and this post saved me :)

The best part is that it’s possible to use dynamic values from the page in Datasource Aggregate Refs 

In my scenario I used a reference entity from another LOV field and it also worked!

 

LOV query looks like this

Customer env: 23R1

Reply


Terms & ConditionsCookie settings