Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    5
  • Views views
    320
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Advanced Search Criterion

M carmen De paz

Hello,

I try to use this criterion to find all fields used in SQL statements, but it does not work very well for me.

here are the results

as you can see the field named "sql-salidaendpoint" and used in a SELECT is in the results

but the other filed named "sql-num-dias" which is also used in another SELECT is not in the results

Why the fileds "sql-num-dias" does not appears in the results?

  • Suggested Answer

    0  

    Hi,

    If this is still an issue, you can open a support case at https://portal.microfocus.com/s/.

    Otherwise, you can right-click on sql-num-dias and select Properties and take note of how CA captures and parses this field, especially in comparison to how it does it for sql-salidaendpoint.  Then modify the criteriion as needed to ensure it returns sql-num-dias.

    One potential difference I can see is that the criterion does not return declarations located in copybooks.  Is sql-num-dias declared in a copybook?

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.