web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Is it possible to use ...

Microsoft Dynamics AX (Archived)

Is it possible to use LIKE + column value + wildcard in AX Query range?

(0) Share

Report

Report

Posted on by Community Member

Hi
I have ax query on ProjTable and I need filter values
where ProjTable.projId == ProjTable.parentId + "zero or more characters"

I tried to put in Query value of query something like this ,but didnt work.
(ProjTable.ProjId LIKE (ProjTable.parentId + " * ") )

I need to have this done just in AX query (I need query for SSRS report for Portal)

Many thanks for any hint or help

Pavel

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Pavel,

Yes it is possible to use like operator in AX queries.

Please see details on similar thing in this blog:

basicax.blogspot.com.au/.../using-not-like-in-x-select-statements.html

Hope this helps.

Thanks,

Priyanka Agarwal

Was this reply helpful? Yes No
Verified answer

Amir Nazim 5,994 on at

Like (0)

Report
Copy link

Link copied!

Yes it is possible you need to use something like

SysQuery::findOrCreateRange(ProjTable_ds.query().dataSourceTable(tableNum(projTable)),fieldNum(projTable, projId)).value(queryValue(SysQuery::ValueLikeAfter(ProjTable.parentId)));

there are two method in SysQuery class "ValueLike", "ValueLikeAfter" that will be of your use.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 34

#1

CP04-islander 34

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans