Happy new year to everyone.
I wanted to get this information out before end of the year, but there was not time, so now it’s going to be my first blog entry for 2017 (happy blogging)
Previously here, I discussed “A very basic example of V7 style coding with Representation and Class”.Because of that I received a question on, how do you filter a field in representation? Or how do you set up a lookup on a representation field.
In this blog entry ,I like to present you the answer to the above questions. Before we get to point, check out two online help entry “How to modify the selections query facet for a standard data table” and “How to filter rows in a standard query facet”
Both are searchable from online help ...The above online helps talk about how the look up works on a field and how you can manage the lookup.Now here is the example, (my example here is based again on ZCLIENT class which was previously discussed.) I am going to add a field to my representation which will have a lookup based on Item list and then I will further filter the lookup.
Now let’s say I want to add additional filter to this look up and only show the items that has a specific UPC code, Note: Like any development topic there might be other ways, but below is one way to accomplish this requirement.I know this look up is based on ITMMASTER representation, how do I know that?
You can set up, lookup and filter the look up of a property in a representation.
What is next:
In future blogs I am going to show how you can make this representation available in REST web services.
This tutorial helped me a lot but doesn't solve all of my problems...
I need the filter to be dynamic based on some characteristics from another field in the same representation, and not only based on the table.
Can you please help me with that?
Thanks for the help so far, it has been great so far.
© 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blogs | Community Help