2,743
edits
Report Script: Get Field that is not in Report v2: Difference between revisions
Report Script: Get Field that is not in Report v2 (view source)
Revision as of 07:11, 2 August 2018
, 5 years ago→Build a Sql string of Project Multiple Values
mNo edit summary |
|||
Line 139:
Example of Multiple values in SQL statement:
SELECT [Description] FROM Project WHERE ProjNo in (''''ProjA', 'ProjB'''')
{{Note|The code in BuildSqlProjectRangeIn has not been optimized for performance.<br/>Not suitable for customer whom have more than 100 details in an Invoice.<br/>
Suggest adding filter to empty ProjNo and distinct the ProjNo before process in the loop.
}}
<syntaxhighlight lang="csharp">
private string BuildSqlProjectRangeIn(long docKey)
| |||