Finance | Project Operations, Human Resources, ...

Query to update the value in other table.

(0) Share

Report

Posted on by Community member

I have create extension of Inventtrans and add new field as enum type with value of No Yes Name Updatestatus.

When I check the inventtransTable through table browser this field is visible.

When I apply this query on this field my query did not work.

while select inventTrans
where
//inventTrans.Updatestatus ==0
InventTrans.DatePhysical!=Global::dateNull()
After commending this line my query work for me.

When I run the debugger in last step I have to update the inventtrans.updatestatus field with Yes value.

This field is not visible in debugging window.

Guys Need your help in this regard

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Martin Dráb 239,093 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I assume that your statement " my query did not work" means that your query didn't return any data. But it doesn't mean that the query doesn't work, just that there are no records (in the current company) meeting all the conditions.

Regarding debugger, you didn't describe your problem in detail, but I think you aren't looking at the Extensions node. You think the new field will be at the same level as standard fields, but it isn§t the case.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,045 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In addition to the reply from Martin, I noticed that you tried to set a range on the UpdateStatus field with a hard-coded value '0'. Have you tried using UpdateStatus::No or UpdateStatus::Yes? Depending how the new enum is created, the value 0 might not be used or used for another value.

Was this reply helpful? Yes No
Community member 10 on at

Like (0)

Report
Copy link

Link copied!

Hello Andre

Thank you very much for your response. I have also tried with NoYes value as well like below query but failed

while select inventTrans
where
//inventTrans.Updatestatus ==Updatestatus::No
InventTrans.DatePhysical!=Global::dateNull()

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

As you are able to see new field in table browser means it is synchronised successfully. But it doesn't have any value. So can you give a select statement for this field in ssms and check what value it is returning.

Also check if the enum values exist for the new enum you created. I mean, check those enum values in ssms.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Also have you added enum values for your new custom field? Also here new enum is not required you can use NoYes enum for the table field.

Was this reply helpful? Yes No