Aware IM User Forums

Can you configure a report rather than a document?

Use the test log to see how many items are found in the query.

If jannes is willing to provide a 30-minute webinar on Zoom or any other platform, I would love to see it.

I'll be lazy and give you some LIST_TABLE code that works. You'll have to sort through it to see if it can help. This is the HTML from an HTML document embedded in an email notification. Hope it helps. Hello <<Investigator.FirstName>>, You currently have <<Count PHS WHERE (PHS.Investigator=Investiga...

You can certainly display a picture attribute in a report. If it is stored in a document type, then no. I see lots of workarounds. Let's say you want to store everything in a document type. You can have a second attribute to store a picture and an update rule where if the document is .jpg, .png, .gi...

I use both types but always for different purposes. Like you said, I use picture type only when the object needs to be displayed on screen or in a report. I presume the document display function will display an image if needed. So, I use the picture type only if I need the picture to display on scre...

I concur with my limited understanding. Also, you probably don't need the This prefix so long as JobSystem.ob_Job is always in context and not overwritten by any other instance of the object.

We could use a bit more detail as to how these objects are related. Also, you are using the FIND action, and you say the items are being displayed somewhere. It would be key to know where/how. You must be sure the JobSystem object is in context. Perhaps describe the function more completely.

Okay, so for each job, you are copying the entire master list, and I presume the user selects the applicable labor for the job? For this, you should use the DUPLICATE action as shown here: https://www.awareim.com/dokuwiki/doku.php/a_f/a/duplicate?s[]=%2Aduplicate%2A However, I'm not sure how you rel...

No, I think your approach is off a bit. The MasterWageDetail objects are the various job descriptions and wages. In the Job object, the user selects the Union/Non-Union and Description attributes which you use to lookup the wage in the MasterWageDetail table and bring in the daily wage. So, your rul...

I think that is resolved in my second response. You want to FIND the WageDetail object based on the two selections in the Job object. That's the criteria but my second response prevails based on the information as I understand it.

Based on what I see here, you just need an update rule such as: IF Job.WageType WAS CHANGED OR Job.WorkerDescription WAS CHANGED THEN FIND WageDetail WHERE WageDetail.WageType=Job.WageType and AND WageDetail.WorkerDescription=Job.WorkerDescription Job.DailyWage=WageDetail.DailyWage On the Rule, you ...

To clear, let me reiterate your need: When you create the Job BO, you want to populate certain attributes with attributes from the reference attribute ps_MasterWageDetail. It seems you may need to do this based on one or more attributes entered in the Job BO during creation. If I have this right, he...

Why not create a summary report and use the "Applicable to Multiple" option when calling the process to create the report?

Depending on how you set up the BSV, you either established a new (separate) database or are using the standards basdb database. If you did not use a separate database, then your test database tables are all appended with your bsv name i.e., [bsv]_customers. They WILL use this naming convention in t...