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
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.
This works, does this mean the documentation is incorrect? Since the documentation states this, which both don't seem to work. :
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
They both work, I guess once you know how it works the documentation makes sense. Thanks.