In request search page , the data set retrieved by some filter condition , required to capture in Excel or pdf .
In web instance is it possible ?
I know this is possible in the Smart Client via the method described in the below post:
There are some functions that are intentionally not included in the Web client as the Web client is not intended to provide the functions that would be deemed a Studio user function. I will check to confirm that the export falls under this but I believe it would as it deals with extraction of data out of the system which would usually only be done by an advanced user who has the technical knowledge to then deal with that data.
Just had confirmation that this is not in the Web client intentionally and there is not a current planned version to add this in to the Web client functionality either. This action would need to be done from the Smart client instead.
@Lee Pinchbeck : Thanks for your response. But, even from smart client also ,how to retrieve the searched dataset, in excel?
Link not accessible for me.
You don’t have access because you’re not listed as a partner. Do you work for an IFS partner? I couldn’t tell from your registration information!
We are facing the same requirement now more often. We need to retrieve simple excel lists via overview screens (like request and tasks). The excel should display the columns / data defined in the UI designer. Is there a simple way to retrieve excel lists via screens directly?
Of course we are aware of the import/export functionality but this only exports dedicated tables and not search results.
Please see the answer at the bottom of this post:
Hi @Mike The FSM TechnoGeek,
unfortunately I don’t have access to to the link. Would you be so kind to post the answer over here?
Yes. You can do this from the Web Client, though it’s a little different. Some screens have an ‘export’ button on the search results. If the screen you want to export search results from does not already have an export button, then you need to add one in UI Designer.In a custom screen, add an empty <header_def/> tag in the result panel. Like this (see screenshot). This will give you an export button in the TASK screen for the Web Client.
Hi @Mike The FSM TechnoGeek ,
thanks again. Should this work without anything else or is a client script required?
Ask the community for help!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.