Hi Lewis,
I can try to explain here...feel free to call or email me to discuss further - I have modified and created my own lookups in web apps, so I've been down this road before.
You will need to edit the 'GetLookupString' and 'GetSearchFields' functions in web apps. Most of these are in the UIHelper of the respective project with which you are working.
If you look at the ProjectTimecardUIHelper, you can see this example for looking up the Project Task::
What this means...if the String = "ProjectTask" (this is passed by the lookup), then the following happens:
1. the web service lookup name is TaskTEList, but this is not actually the stored procedure that is run. There is a table in the system database, webservicelookup, that has the correlation beteween the Name and the Procedures. in this case, the TaskTEList will run the WSL_TaskTEList stored procedure.
In the 'GetSearchFields' function, you can see that Parm3 and Parm4 are listed for the ProjectTask and match the output column names of the Stored procedure (and relate to the [SearchOnly] above)
Also, each lookup is prepended with @page, @size, and @sort for proper paging of search results. and these procs are usually all dynamic SQL.
What you need to change depends on whether you need to pass another 'limiting' parameter, another search parameter, or just take over the whole lookup with your own procedure. If you do create your own stored procedures, be sure to insert records into the webservicelookup and webservicelookupit tables in the SYS database .
Again, feel free to reach out if you want to discuss.
Marc
------------------------------
Marc DeLozier
Finance SysAdmin
David Evans and Associates Inc.
Portland OR
------------------------------
Original Message:
Sent: Jul 12, 2019 02:24 PM
From: Lewis Shaw
Subject: WebApps and PVs
Hello All,
Does anyone have a guide or tips for modifying or creating PVs in WebApps?
I can create them in Dynamics no problem, but have been struggling with them in WebApps.
Thanks.
------------------------------
Lewis Shaw
Raytheon Canada Ltd
------------------------------