CSI tools Facebook CSI tools Twitter CSI tools LinkedIn CSI tools Instagram
  • Home
  • Newsroom
    • Awards
    • Events
    • Press Releases
    • Publications
  • Software
    • By Solution
      1. Access Risk Management
      2. Access Request Management
      3. Privileged Access Management
      4. Access Role Management
      5. SAP License Audit
      6. Mass User Maintenance
    • Tools
      1. CSI Authorization Auditor
      2. CSI Automated Request Engine
      3. CSI Emergency Request
      4. CSI Role Build & Manage
      5. CSI Mass User Maintenance
      6. CSI Integrate & Collaborate
    • Pathlock
    • Legacy Tools
    • Pathlock Cloud: The Successor of CSI tools
  • Customer Center
  • Community
    • CSI tools Forum
    • Meta's Blog
    • Tech Updates
    • Training
  • About
    • Contact
    • Jobs
    • Partners
      • Become a Partner
    • References
    • Testimonials
    • Sustainability
  • Login
  • You are here:  
  • Home
  • Forum
  • CSI tools Community
  • CSI Data Xtractor
  • wildcard in the where clause
  • Index
  • Recent Topics
  • Search
  • Index
  • Recent Topics
  • Search
  • Log in

    Forgot your password?
    Forgot your username?
    Create an account

  • Log in

    Forgot your password?
    Forgot your username?
    Create an account

  1. Forum
  2. CSI tools Community
  3. CSI Data Xtractor
  4. wildcard in the where clause

wildcard in the where clause

  • Start
  • Prev
  • 1
  • Next
  • End
  • 1
  • Jan.VanHove
  • Offline
  • Administrator
  • Administrator
Less More
  • Posts: 1
  • Thank you received: 0
12 Aug 2019 12:00 #1 by Jan.VanHove
Replied by Jan.VanHove on topic wildcard in the where clause
Hi, Welcome to the CSI tools forum!

CSI DX works with SQL syntax, so the wildcard would be a percentage sign (%).
Your 'WHERE'-clause would therefore look like agr_name like 'z%'

If you need any other tips please don't hesitate to post again, or contact the support desk.

Kind regards,
Jan

Please Log in or Create an account to join the conversation.

  • pmason
  • Offline
  • New Member
  • New Member
Less More
  • Posts: 1
  • Thank you received: 0
07 Aug 2019 18:25 #2 by pmason
wildcard in the where clause was created by pmason
I did a little searching and could not find the solution. How do I do a wildcard filter on the where clause. For example agr_name like 'z*'

Please Log in or Create an account to join the conversation.

  • Start
  • Prev
  • 1
  • Next
  • End
  • 1
  1. Forum
  2. CSI tools Community
  3. CSI Data Xtractor
  4. wildcard in the where clause
Time to create page: 0.223 seconds
Powered by Kunena Forum

Get in touch

Pathlock Benelux
Support Direct
Link to the support portal https://support.pathlock.com

To gain access to the new support portal, please contact us at customersupport@pathlock.com

Tel. +32 16 308 008

Address
Kempische Steenweg 303/200
B-3500 Hasselt, Belgium

Via phone
Tel: +32 16 308 000

Last Updates

  • Pathlock Cloud: The Successor of CSI tools
  • Pathlock named Market Leader for Zero Trust by Cyber Defense Magazine

Solutions

  • SoD and Risk analysis - CSI Authorization Auditor
  • Compliant Provisioning - CSI Automated Request Engine
  • Emergency Access Management - CSI Emergency Request
  • Compliant Role and Mass User Management - CSI Role Build & Manage
  • Extract SAP data - CSI Data Xtractor
  • CSI Integrate & Collaborate

©1997-2025 Pathlock Benelux. All rights reserved. - Privacy Policy  - Cookie Policy - Code of Ethical Conduct - Sitemap