New to Infosteward. Need assistance with Syntax.

dataservices information steward
1

Hello. I am new to this tool. I am in need of assistance with creating filters on views and also rules.

First I am trying to create a view and in the filter I am trying to select records where one date is greater than the current date and another date is = 12/31/9999. I am having problem with the syntax in the filter.

Example:
“SAP HTR”.HRP1000.OTYPE = ‘S’
AND is_valid_date(“SAP HTR”.HRP1000.ENDDA, ‘12.31.9999’)
AND “SAP HTR”.HRP1001.BEGDA > to_date (‘sysdate ()’,‘mm,dd,yy’)

This returns no records but there are valid records.

Also if you have any suggestions on how I can learn the proper syntax for rules it would be greatly appreciated. I feel like I understand the process by struggle on the rules.

Thanks!!

sullivcm (BOB member since 2013-10-31)

2

I struggle with the syntax too.

See here for one of my previous posts with working syntax that may help you:-

Nemesis :australia: (BOB member since 2004-06-09)

3

SAP Information Steward uses the scriting language of SAP Data Services.
The User Guide ( available for SAP Cusotomers on the Help Portal: http://help.sap.com/bois ) includes a whole section 2.13 Scripting language with over 100 pages of explanation and samples.

Niels

nweigel :de: (BOB member since 2008-11-05)