15.03.2019, 12:13 | #11 |
Участник
|
X++: static void Job64(Args _args) { QueryBuildDataSource qbds; Query query; ; query = new query(); qbds = query.addDataSource(tableNum(DimensionFinancialTag)); qbds.addRange(fieldnum(DimensionFinancialTag, FinancialTagCategory)).value(queryValue(5637145326)); qbds.addRange(fieldnum(DimensionFinancialTag, Value)).value('" ", !IFRS'); info(query.tostring()); } Цитата:
SELECT * FROM DimensionFinancialTag(DimensionFinancialTag_1)
WHERE ((FinancialTagCategory = 5637145326)) AND ((Value = N' ' AND NOT (Value = N'IFRS'))) |
|