DropDown on temp data from web service

Juhl

Hi guys

I need to make a DropDown, where lookup is data from a web services, called on lookup.
Wondering the best way to do this.

My idea is to fill a temp table in OnLookup trigger, but this will force me to open a page, to pick the value.
But i need to use DropDown, and also search (filter as you type) and change column key.

Syncing the values to real tables doesn’t work, as data is different based on a previous DropDown.
So it’s a DropDown from WS, then another DropDown from WS that’s based on the one before, and then yet another.
So the dataset can’t be saved to NAV ahead of time, as the business logic from the foreign system can’t be replicated.

Any ideas ?

Need to work on web client and BC(AL) so no .NET

Slawek_Guzek

If it is supposed to be a dropdown I woudn't be touching the OnLookup trigger. Instead I'd be trying to set the relation on a field to some new table acting as a buffer for the web services call result. Then have a bespoke page defined as a lookup page on this buffer table, and then in the OnOpenPage trigger call the web service and fill the table with results obtained from web services call.

The lookup page could be defined as SourceTableTemporary=Yes so any web service call result stored in there would not start a transaction.

Slawek_Guzek

In scenarions when I need to decouple the code yet need to pass parameters to called object I am doing a simple trick and passing params through filters:

In scenarion like calling PAGE.RUNMODAL(someid, somerec), or CODEUNIT.RUN(someid, somerec) where someid comes form some setup field, and still having to pass some parameters to called object I'd be coding this as in the mockup code below:

T39.SETFILTER("Document No.", '*|'+MyParameter);
PAGE.RUNMODAL(someidcomingfromsetuptable, T39)

Then all objects which are supposed to be called that way would have a little code in OnOpenPage, or in OnRun, to retrieve requested parameter from the filter passed on rec, and the clear the filter (maybe leaving whatever is on left side of the | char as the "real" filter.


In case like this one where OnLookup trigger can't be really touched I'd be setting up conditional/filtered relation, where the condition or filter would include required parameter(s):



Then in OnOpenPage I'd try retrieve my parameters passed in filters.

Slawek_Guzek

If it is supposed to be a dropdown I woudn't be touching the OnLookup trigger. Instead I'd be trying to set the relation on a field to some new table acting as a buffer for the web services call result. Then have a bespoke page defined as a lookup page on this buffer table, and then in the OnOpenPage trigger call the web service and fill the table with results obtained from web services call.

The lookup page could be defined as SourceTableTemporary=Yes so any web service call result stored in there would not start a transaction.

Juhl

Hi Slawek

Of course, I didn't think of creating a page for the buffer table. That would work.

Only downside is validation, as you cant test for tablerelation, so the user can input anything he wants. But again that could be tested against the webservice.

Thanks.

Juhl

Next problem, I need to pass a variable to the page used for lookup.
That variable is used in OpOpenPage, to call the right web service.

Any idea Slawek?

Slawek_Guzek

In scenarions when I need to decouple the code yet need to pass parameters to called object I am doing a simple trick and passing params through filters:

In scenarion like calling PAGE.RUNMODAL(someid, somerec), or CODEUNIT.RUN(someid, somerec) where someid comes form some setup field, and still having to pass some parameters to called object I'd be coding this as in the mockup code below:

T39.SETFILTER("Document No.", '*|'+MyParameter);
PAGE.RUNMODAL(someidcomingfromsetuptable, T39)

Then all objects which are supposed to be called that way would have a little code in OnOpenPage, or in OnRun, to retrieve requested parameter from the filter passed on rec, and the clear the filter (maybe leaving whatever is on left side of the | char as the "real" filter.


In case like this one where OnLookup trigger can't be really touched I'd be setting up conditional/filtered relation, where the condition or filter would include required parameter(s):



Then in OnOpenPage I'd try retrieve my parameters passed in filters.

Juhl

Nice one.
I thought of filters too, but could not get it to work. But I get your solution.

Thanks :-)