Report Script: Get Field that is not in Report v2: Difference between revisions
Content added Content deleted
mNo edit summary |
|||
Line 139: | Line 139: | ||
Example of Multiple values in SQL statement: |
Example of Multiple values in SQL statement: |
||
SELECT [Description] FROM Project WHERE ProjNo in (''''ProjA', 'ProjB'''') |
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"> |
<syntaxhighlight lang="csharp"> |
||
private string BuildSqlProjectRangeIn(long docKey) |
private string BuildSqlProjectRangeIn(long docKey) |