Question

Populate Entity From Dataset?

0

Hi – is there a way to populate an entity based on a Dataset? I’m trying to do this so that I can use the results of the dataset in a data grid and ultimately a Document Template.

asked 2019-11-22

SL

4 answers

SL · Answer 1 · 2019-11-22

I saw the OQL app store widget, so I’m trying that (which populates results from an OQL into an entity via a microflow). I specify this statement in the OQL microflow SELECT * FROM ACCOUNTS but get error below. Any ideas?

SL · Answer 2 · 2019-11-22

I found I need to surround the OQL statement with single quotes in the microflow; however, the single quotes cause an issue when I’m using single quotes in the OQL statement. I got around that by using two single quotes within the OQL. I’ll see if this works.

SL · Answer 3 · 2019-11-22

I get a nullpointerexception from the following in my OQL microflow (entered in the widget provided by app store). Any ideas what is causing this?

'select 0 as amt,
DD2.DueDt_Installment as DueDt, ACC_.Account_or_Policy as ACCTPOL, DD2.PmtRT as RT,
CAST(''1900-01-01 00:00:00'' AS DATETIME) as maxDT, ''NOPMT'' as GRP2
from
Coll.Accounts ACC_
inner join ACC_/Coll.DueDtSchedule_Accounts/Coll.DueDtSchedule as DD2
'

SL · Answer 4 · 2019-11-22

FYI – fix to this was to remove “as” from my alias table names and to make the field name aliases in select statement align with entity field names