Finance | Project Operations, Human Resources, ...

Answered

Query extended range failure: Syntax error near 257

(0) Share

Report

Posted on by AXDev2105

Hi everyone,

I am facing an issue.

I have a Policy on a Role.

I created an AOT Query for policy containing only one table InventTransferTable. And add a range on field InventLocationIdFrom.

For value of this range, I created a method in class SysQueryRangeUtil.

I want to only filter those LocationId(s) from InventTransferTable which map the User assigned LocationId. (which come through loop)

Either this LocationId exist in InventLocationIdFrom field or it exist in InventLocationIdTo field. here is the code:

Here is the AOT Query range image:

So when I open the TransferOrder Form, this code generate the following error:

Query extended range failure: Syntax error near 257.

I tried different code but no result.

The main loop have 6 LocationId(s). On 2 to 3 LocationId(s), It did nót get any error.

For the User Assigned Location consider, 1,2,3,4,5,6

Need help for this. Your help will appreciable.

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report

I'm not an expert on XDS but aside from the errors in the codes, even if you solve the errors, it will work with the location information of the user who made the build.(it ll not dynamic)

What you need to do is to examine the MyDepartments temp Table, make a similar table and fill it. You can use this structure to filter the query.

Was this reply helpful? Yes No
AXDev2105 10 on at

Like (0)

Report

Thank you Ergün Şahin for response.

But I am not clear with your answer. e.g. what does you mean by examine MyDepartments temp table.

Could you explain in some more detail?

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report

If you look at the table I'm talking about (or any other table starting with my..), you'll see that it fills the table with codes. After this session-based filling process, records will be automatically filtered in the query when you join (inner join) this table.

You need to look standard and set up a similar structure.

Was this reply helpful? Yes No
AXDev2105 10 on at

Like (0)

Report

Once again Thanx Ergün Şahin,

You give me a direction to resolve this issue via another way.

I implemented it, and achieved the desired results.

My findings is, that never used complex ranges in AOT query values.

I made a table and fill with desired data that I want to filter, and make the join of this table to InventTransferTable.

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report

Complex queries can be used but your situation was a little different. You cannot use a fixed value(build user values) because you are filtering on a user basis .

In this case the mapping table is a good idea, but if you use the standard table and not fill it a tmp as I mentioned (XDS-tmpTable exampls), you will need to update the table data every time the user's location changes.

I'm glad you fixed the problem. If you mark the helpful answers as verified, you will have closed the topic.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Query extended range failure: Syntax error near 257

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Query extended range failure: Syntax error near 257

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates