How to add the filter criteria in external file assistant?
Based on above, I want to be able to choose which Project when exporting the external file template.
Page 1 / 1
Hello
You need to go in to your File Type details, then from there to External File Type Parameter Definition, to the Available Parameters tab. From there you can add a 3rd parameter of PROJECT_ID. Once you have added, you’ll need to go to the Parameter Sets Tab and add that new parameter in External File Parameters per Set.
Hello
You need to go in to your File Type details, then from there to External File Type Parameter Definition, to the Available Parameters tab. From there you can add a 3rd parameter of PROJECT_ID. Once you have added, you’ll need to go to the Parameter Sets Tab and add that new parameter in External File Parameters per Set.
perfect, this works, thanks!
Hello
You need to go in to your File Type details, then from there to External File Type Parameter Definition, to the Available Parameters tab. From there you can add a 3rd parameter of PROJECT_ID. Once you have added, you’ll need to go to the Parameter Sets Tab and add that new parameter in External File Parameters per Set.
BTW, I suppose PROJECT_ID is basically the field name on SQL?
Hello
You need to go in to your File Type details, then from there to External File Type Parameter Definition, to the Available Parameters tab. From there you can add a 3rd parameter of PROJECT_ID. Once you have added, you’ll need to go to the Parameter Sets Tab and add that new parameter in External File Parameters per Set.
BTW, I suppose PROJECT_ID is basically the field name on SQL?
Yes - the db name.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.