x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

General Discussion Views wont accept like statement

State Not Answered
Replies 2 replies
Subscribers 138 subscribers
Views 705 views
Users 0 members are here

Browse Forums

Announcements

234

General Discussion

13k

Sage Data & Analytics

Sage Enterprise Intelligence

209

410

Sage Intelligence Reporting

121

322

Views wont accept like statement

Posted By ChrisCC over 3 years ago

Why cant sage handle LIKE in the views? Has anybody found a way around this?

Top Replies

Rafael over 3 years ago +1

Try the following for the X3 SQL View/Query: WHERE {TABLENAME}.{FIELDNAME} LIKE '%%1%%'

0 Rafael over 3 years ago

Try the following for the X3 SQL View/Query: WHERE {TABLENAME}.{FIELDNAME} LIKE '%%1%%'
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ChrisCC over 3 years ago in reply to Rafael

didnt work. Ended up having to a create it as a separate view and then have the original view call it
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Views wont accept like statement

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING