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.
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.
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?
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.
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.
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!
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
@dsj , can you please elaborate more on how you use this other Lov reference here ?
I’m trying to do a similar thing but my filtration doesn't work at the moment.
in my case, in the functional object window, I have added two custom fields
to get the Object Level to Object Type entity (persistence reference field )
persistence reference using the FND Boolean (Yes No toggle)
I did the data source aggregate ref for the 2nd field and it works perfectly fine, Object Types can be filtered based on the Boolean field. but when I add the second filter to further filter the select fields based on the object level, it doesn't work and the Object type LOV become empty in the functional object window.
environment 24R2 SU 3
Below are some screen pictures
No data coming :(
in the [payload it seems the filter parameters are passing correctly, but the values are not filtering. i tried to add this as a string directly to see whether it works or not, even when i pass as a string it comes empty.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
