AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
IN Functionality
 
Notifications
Clear all

Questions IN Functionality

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 5 years ago
2 Posts
2 Users
0 Reactions
1,152 Views
RSS
Nec
Posts: 1
 Nec
Topic starter
December 17, 2020 6:42 am
(@nec)
New Member
Joined: 6 years ago

Greetings ๐Ÿ™‚

I am trying to take advantage of the IN logic, and I have met this problem.ย 

The idea is that I am going to gather all unique values in a certain column into a variable. Then I am going to check if a certain value excist in the variable.

Example: Variable $X consisting of concatenated numbers with () around = (1, 4, 5, 7, 11)

Why does ('5' In ($X)) return False, when ('5' In (1, 4, 5, 7, 11)) returns True just fine?


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
March 15, 2021 4:18 am
(@timrodman)
Famed Member
Joined: 11 years ago

My recommendation would be to check the Trace to see what SQL is being generated. I haven't done much with In, but I think it might be intended for Workgroups and the Company Tree (I could be wrong on that).


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 43 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright ยฉ ยท AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

โ€นโ€บร—

    โ€นโ€บร—