Hi - I am also tring to figure out how to do things the “SQL way”, and my first try would have been something like your example, or (DIM.CODE LIKE ‘&Param OR &Param IS NULL). Neither worked. I also tried to define fixed string parameter &pct with a value of % to use in the NVL, but that didn’t help either. It seems that the functions have to be used within a function parameter. Here I have used the standard input parameter Account and the NVL simple function to get the desired output:
I agree that the executed WHERE statement does not look as it should given your input, but on the other hand, your WHERE could be boiled down to “POSTING_TYPE IN (‘M273’, ‘M274’)”.
Good! And your way of solving this with a mixture of single/multiple values points is more flexible. Just the thing for a report I am working on.
Where do I report it? I haven’t found any page for partners to report issues with the various IFS tools.
Re 2: I am pretty sure this has worked as it should previously, and it is not an extension issue as such; It has to do with the naming of .plsql files regarding the OG extension. And it is partly working, because deploying uses the files with the right names.Re 3+4: The screenshot is from Windows explorer, and the module is the standard Preventive Maintenance one. A mixture of lower and uppercase module names in the folder structures is old news in IFS, and this worked some months ago - the last time I worked on customizations for this App9 customer. And - as you can see from the next screenshot with the diff - Developer Studio does find the BASE file in the SVN repository.
Re 2: Why would you need to install an older version to verify that the file names are wrong in the current version? Re 3+4: I raise this as a DevStudio issue because DevStudio is acting up on things that used to be OK. And as I have tried to point out, DS finds the SVN file when doing a diff, but not when syncing up to the repository or trying to update and commit the file, so clearly DS is accessing SVN in two different ways - one where the case does matter, one where it does not.
Already have an account? Login
No account yet? Create an account
Enter your 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.
