How do I use the expand functionality in indicium? Whatever i try i always end up with invalid odata url.
I tried creating an expand statement based on the documentation, either the documentation is incorrect or I am missing something here.
the community wont allow me to add the link I use so i added a picture. I tried on tablename, id name, lookup name. Nothing seems to work.
Best answer by Anne BuitView original
They both work, I guess once you know how it works the documentation makes sense. Thanks.
Based on the documentation, the following URLS should work in your case:
to select all columns from both kerry and gitaarr
to select valuut from kerry and nameidx from gitaarr
This works, does this mean the documentation is incorrect? Since the documentation states this, which both don't seem to work. :
The so-called ‘navigation-property’ for expands uses a prefix on the last reference column.
To get directly to the look-up table (in this case, gitaarr), you can use lookup_gitaar. If the display would be ‘further up the chain’, you can short-circuit using transl_gitaar. Either would work in this case.