Er ging iets niet goed
- Melding:De syntaxis bij het sleutelwoord 'WHERE' is onjuist.
- Details: SELECT TOP 80 ih.id AS tweakid,r.item_id,
r.dbobjectid,
r.coltype,
r.fieldname,COALESCE(ih.headertitle, br.headertitle) AS headertitle, r.placeholder,
r.explanation,
r.divclass,br.boo_samerowasprevious, r.unitofmeasureid,
r.addroleid,
r.message,
r.triggerfield,
r.displaytype,
r.optionsource,
r.filtercondition,
r.optionorderby,
r.optionsobjectid,
r.optionsbasetable,
ISNULL('(' + ob.strsource + ') src', ob.base_table) as optionstable,
ISNULL(ob.keyfield,'item_id') AS optionskeyfield,
ISNULL(ob.labelfield,'naam') AS optionslabelfield, obd.connectstring as optionsconnectstring,COALESCE(ih.boo_required, r.boo_required) AS boo_required,br.boo_unique,br.boo_hideduplicates as boo_hideduplicates, r.boo_autopostback,
r.boo_hastriggers,
r.boo_showemptyspan,
r.boo_showtotal,
r.minvalue,
r.maxvalue,
r.textrows,
r.width,
r.colwidth,
r.maxlength,
r.inputmask,
r.validationscript,COALESCE(ih.defaultvalue, r.defaultvalue) AS defaultvalue,br.editroleid AS editroleid, r.expression,
r.microtemplate,
r.decimals,
r.autofill,
r.align,
r.comment,
r.htmlafter,
r.optionsxml,
r.gridspecialsql,
r.grid_coltype,
r.grid_headeroption,
r.grid_colwidth,
r.syncmethod,
r.viewid,
r.viewid_target,
r.viewfilter,
r.boo_lockedforedit,
r.boo_hidden,
r.boo_autosave,
r.boo_htmlencode,
r.boo_newrow,
r.slider_precision,
r.tofieldid,
r.boo_showdefault,
r.fieldname AS fieldname_org,
ISNULL(r.expression + ' AS ' + fieldname,'[' + fieldname + ']') AS field,
ISNULL(r.expression,'[' + fieldname + ']') AS fieldexpression,
COALESCE(ih.label, br.label, r.naamnl, r.naam, r.fieldname, '') as label,ISNULL(divclass + ' ','') + ISNULL(coltype,'') AS cls,
s.connectstring AS optionsdbsource, o.base_table,
isnull(bo.keyfield,'item_id') as keyfield, isnull(bo.labelfield,'naam') as labelfield,
CASE WHEN o.basedbobjectid > 0 THEN bo.base_table ELSE o.base_table END AS roottable, s.connectstring,
u.expression AS formatExpression,
bo.fieldnamedatelocked, br.boo_showspan, br.id as brruleid FROM dbrules r WITH(nolock)
INNER JOIN dbobject o WITH(nolock) ON r.dbobjectid = o.item_id
INNER JOIN dbobject bo WITH(nolock) ON o.basedbobjectid = bo.item_id
INNER JOIN dbdatastore s WITH(nolock) ON o.dbdatastore_item_id = s.item_id
INNER JOIN unitofmeasure u WITH(nolock) ON r.unitofmeasureID = u.ID
INNER JOIN dbobject ob WITH(nolock) ON r.optionsobjectid = ob.item_id
INNER JOIN dbdatastore obd WITH(nolock) ON ob.dbdatastore_item_id = obd.item_id INNER JOIN briteviews_dbrules br WITH(nolock) ON r.item_id = br.label_id AND br.item_id = @param1
AND (br.viewroleid IS NULL OR br.viewroleid = 0 OR SUBSTRING(@param2, isnull(br.viewroleid, 1) * 10 + 1, 1) = '1')
LEFT JOIN instance_hidefields ih ON r.item_id = ih.fieldid AND ih.instanceid =
WHERE (boo_showdefault = 1 AND ISNULL(ih.boo_hide,0) = 0) OR ISNULL(boo_show,0) = 1
ORDER BY br.rank : 2 : Parameters: @param1=i:5056, @param2=10000000001110,
- Technische info: ObjectData
- Template: view_e4all_pagina